使用AspNetPager控件分页

页面后台写法

protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindData(); } } protected void AspNetPager1_PageChanged(object sender, EventArgs e) { BindData(); } public void BindData() {PageDataBaseOptater pdo = new PageDataBaseOptater(); AspNetPager1.RecordCount = pdo.GetRowCount("表名","where条件"); AspNetPager1.PageSize = pageSize;//pagesize可以设定 string cond = " where 条件"; DataSet ds = pdo.GetinfoList("表", AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, "记录的Id DESC", cond, "id名称"); Repeater1.DataSource = ds; Repeater1.DataBind();}dao层：   public class PageDataBaseOptater    {       /// <summary>       /// 获取记录数        /// </summary>        public int GetRowCount(string table,string where条件可以没有)        {           //获取表的记录总数                     }        public DataSet GetinfoList(string table, int rowpage, int rowcount,            string orderFid, string Conditions,string colum_id)        {            //sqlserver2005的            //string query = "Select * From "            //    + "(Select *,ROW_NUMBER() OVER(ORDER BY {2}) as RowNum From {4} {3}) as newTable "            //    + "Where (RowNum BETWEEN ({0}) AND ({1}))";            //query = string.Format(query, (rowpage - 1) * rowcount , rowpage * rowcount, orderFid, Conditions, table);            string query = "Select top {0} * From {1} {2} and {3}  not in(Select top {4} {3} From {1} {2} Order by {5}) Order by {5}";            query = string.Format(query, rowcount, table, Conditions, colum_id, (rowpage- 1) * rowcount, orderFid);            DataDao dao = new DataDao();            return dao.PageGetDataSet(query);        }    }

控件下载：http://download.csdn.net/detail/yysyangyangyangshan/3625510