AspNetPager控件官方下载地址:
http://www.webdiyer.com/AspNetPager/default.aspx
1〉添加引用AspNetPager.dll
2〉前台代码如下:
- <body>
- <form id="form1" runat="server">
<div style ="text-align :center ;">
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<Webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True" - OnPageChanging="AspNetPager1_PageChanging1" BackColor="#FFFFC0" BorderColor="Blue" BorderStyle="Solid" BorderWidth="1px" FirstPageText="首页"
- LastPageText="尾页" NumericButtonType="Image" PageSize="20" ShowBoxThreshold="50" ShowInputBox="Always"></Webdiyer:AspNetPager>
</div>
</form>
</body> - --------------------------------------------------------------------------------------
后台代码: - C# code
- private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
bind();
SqlConnection conn = new SqlConnection(sqlcon); - conn.Open();//打开数据库链接
SqlCommand cmd = new SqlCommand("select COUNT(*) from dbTable", conn);
SqlDataReader dr = cmd.ExecuteReader(); - dr.Read();
- AspNetPager1.RecordCount = Convert.ToInt32(dr["count"].ToString());
- //获取表中信息的数量
- dr.Close();
conn.Close();
bind(); - }
- }
public void bind()
{
SqlConnection conn = new SqlConnection(sqlcon); - conn.Open();//打开数据库链接
- SqlDataAdapter da = new SqlDataAdapter("select * from dbtable", conn);
DataSet ds = new DataSet(); - AspNetPager1.AlwaysShow = true; //总是显示分页
AspNetPager1.PageSize = 10; //每页显示的数量
da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "dbTable");
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close(); - }
- //翻页事件
protected void AspNetPager1_PageChanged(object src, PageChangedEventArgs e) - {
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
bind();
}