分页控件AspNetPager的使用

前台代码---控件属性设置

AlwaysShow="True" //允许显示
onpagechanged="AspNetPager1_PageChanged" //分页事件
PageSize="3" //每页显示多少项
CustomInfoHTML="第%CurrentPageIndex%页，共%PageCount%页，每页%PageSize%条"
//数据项详细信息显示
CustomInfoSectionWidth="30%" //控件大小

 

 后台代码

 　　记录条数

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
String sql = "select * from info order by id desc";
SqlDataAdapter da = new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
da.Fill(ds, "Table");
AspNetPager1.RecordCount = ds.Tables["Table"].Rows.Count;

　　数据显示

String sql = "select * from info" + str + " order by id desc";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds,(AspNetPager1.CurrentPageIndex-1)*AspNetPager1.PageSize,

　　　　　　AspNetPager1.PageSize, "Table");
repLog.DataSource = ds.Tables["Table"].DefaultView;
repLog.DataBind();

 

转载于:https://www.cnblogs.com/daocao/archive/2010/03/20/1690378.html