aspnetpage分页问题
存储过程
if exists(select *from sysobjects where name='gettest')drop proc gettestgocreate proc gettest@startIndex INT, @pageSize INT ASwith SClass as(select row_number() over(order by id) as rownumber,id,custname,addtime from company)/**上半句产生一个临时表，表名为Small_Class,其内容来自于自查询select row_number().......**/select rownumber, id,custname,addtimefrom SClasswhere rownumber >=(@startindex-1)*@pagesize+1 and rownumber<=(@startindex-1)*@pagesize+(@pagesize)select count(*) from company
DataSet ds = new DataSet(); DataTable dt = new DataTable(); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { SetBind(); } } protected void SetBind() { ds = getmes(AspNetPager1.CurrentPageIndex, 20); dt = ds.Tables[0]; AspNetPager1.RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString()); Repeater1.DataSource = dt; Repeater1.DataBind(); } protected void PageChanged(object sender, EventArgs e) { SetBind(); } protected DataSet getmes(int startindex, int pagesize) { SqlParameter[] par = { new SqlParameter("@startindex",SqlDbType.Int), new SqlParameter("@pagesize",SqlDbType.Int) }; par[0].Value = startindex; par[1].Value = pagesize; return SqlHelper.ExecuteDataSet(SqlHelper.ConnectionString, CommandType.StoredProcedure, "gettest", par); }