//Response.Write("Select Count("+DataFiled+") From "+DataTable);
//Response.End();
//* 取得记录总数,计算总页数
SqlCommand cmd = new SqlCommand("Select Count("+DataFiled+") From "+DataTable,Conn);
RecordCount = Convert.ToInt32(cmd.ExecuteScalar());
if ((RecordCount % PageSize) != 0)
{
PageCount = RecordCount/PageSize + 1;
}
else
{
PageCount = RecordCount/PageSize;
}
if (ToPage > PageCount)
{
CurrentPage = PageCount;
}
if (CurrentPage <= 1)
{
PageSQL = "Select Top "+PageSize+" "+DataFileds+" From "+DataTable+" Order By "+DataOrders;
}
else
{
PageSQL = "Select Top "+PageSize+" "+DataFileds+" From "+DataTable+" Where "+DataFiled+" Not In ( Select Top "+PageSize*(CurrentPage-1)+" "+DataFiled+" From "+DataTable+" Order By "+DataOrders+" ) Order By "+DataOrders;
}
SqlDataAdapter oda = new SqlDataAdapter(PageSQL,Conn);
DataSet ds = new DataSet();
oda.Fill(ds,"infList");