asp.net and access jointly developed paging classes

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
Namespace Pager
{
public class pager
{
///<summary>
///
///</summary>
///<pa Ram Name= "strwhere" > Conditions </param>
///<param name= "pagesize" > per-page display bars </param>
///<param Name= "pageindex" > Page </param>
///<param name= "Ordercol" > Sort </param>
///<param name= " TableName "> table name </param>
///<returns></returns>
public static string Getpager (string strwhere, int pagesize, int pageindex, string ordercol, string tablename)
{
if (pageindex = 1)
{
Return " Select Top "+ pagesize. ToString () + "* from" + tablename.tostring () + "ORDER BY" + ordercol.tostring () + "DESC";
}
Else
{
StringBuilder strSQL = new StringBuilder ();
Strsql.appendformat ("select top {0} * from {1}" , pagesize, TableName);
Strsql.appendformat ("where {1} nOT in (select top {0} IDs from {2} ", PageSize * (pageindex-1), Ordercol, TableName);
if (Strwhere.trim ()!= "")
{
Strsql.appendformat ("where {0} order by {1} DESC) and {0}", Strwhere, Ordercol) ;
}
Else
{
Strsql.appendformat ("ORDER by {0} DESC)", Ordercol);
}
Strsql.appendformat ("ORDER by {0} DESC", Ordercol);
return strsql.tostring ();
}
}
}
}