1,下载AspNetPager.dll 添加引用
2,将AspNetPager控件添加进工具箱(实现拖拽使用)
3,添加Repeater控件Repeater1,并设置相应显示内容
前端实现:
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<%#Eval("显示字段")%><br />
</ItemTemplate>
</asp:Repeater>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server"
onpagechanging="AspNetPager1_PageChanging" FirstPageText="首页"
LastPageText="最后" NextPageText="下一页" NumericButtonCount="5" PageSize="20"
PrevPageText="上一页" UrlPaging="True">
</webdiyer:AspNetPager>
代码实现:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
void BindData()
{
SqlConnection conn = new SqlConnection("连接数据库");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("sql语句", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
Repeater1.DataSource = pds;
Repeater1.DataBind();
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
BindData();
}