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>
