AspNetPager的使用实例说明
1、添加引用2、在页面上拖放控件3、<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>
4、控件的基本属性设置<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText='首页' LastPageText='尾页' PagingButtonSpacing="10px" ShowPageIndexBox="Always" CustomInfoHTML="共%RecordCount%条，第%CurrentPageIndex%页 /共%PageCount% 页" NextPageText="下一页" PrevPageText ="上一页" ShowCustomInfoSection="Left" SubmitButtonText ="Go" TextAfterPageIndexBox ="页" TextBeforePageIndexBox ="转到 " UrlPaging="True" CustomInfoSectionWidth="20%" CustomInfoTextAlign="Center" onpagechanged="AspNetPager1_PageChanged"> </webdiyer:AspNetPager>
5、后台代码protected void Page_Load(object sender, EventArgs e) { string sqlStr = "select * from download where 1=1 "; if (key.Text != "") { sqlStr += "and title like '%" + key.Text + "%' order by id desc";
} else { sqlStr += "order by id desc"; } string s = ConfigurationManager.ConnectionStrings["siteconn"].ConnectionString; //定义连接字符串 SqlConnection conn = new SqlConnection(s); //新建数据库连接对象，其中s是上面的连接字符串 conn.Open(); //打开与数据库的连接 SqlCommand cmd = new SqlCommand(sqlStr, conn); AspNetPager1.AlwaysShow = true; AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = (int)cmd.ExecuteScalar(); conn.Close(); bind(); } private void bind() { string sqlStr = "select * from download where 1=1 "; if (key.Text != "") { sqlStr += "and title like '%" + key.Text + "%' order by id desc";
} else { sqlStr += "order by id desc"; } string s = ConfigurationManager.ConnectionStrings["siteconn"].ConnectionString; //定义连接字符串 SqlConnection conn = new SqlConnection(s); //新建数据库连接对象，其中s是上面的连接字符串 conn.Open(); //打开与数据库的连接 DataSet myds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(sqlStr, conn); adapter.Fill(myds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "myds"); GridView1.DataSource = myds.Tables["myds"]; GridView1.DataBind(); } protected void AspNetPager1_PageChanged(object sender, EventArgs e) { bind(); }
6、添加序号 <asp:TemplateField HeaderText="序号"> <ItemTemplate> <%# (this.AspNetPager1.CurrentPageIndex - 1) * this.AspNetPager1.PageSize + Container.DataItemIndex + 1%> </ItemTemplate> </asp:TemplateField>
