asp.net 分页sql语句(结合aspnetpager)

数据库操作类： 代码如下:/// <summary> /// 取得总数 /// </summary> /// <returns></returns> public string getTotal() { StringBuilder sb = new StringBuilder(); sb.Append(“select count(*) total from Test”); DataTable dt = DBHelper.ExecuteDt(sb.ToString()); return dt.Rows[0][0].ToString(); } /// <summary> /// 根据当前页码，每页