AspNetPager的使用实例说明

2013 年 2 月 4 日3460

欢迎进入.NET社区论坛,与300万技术人员互动交流 >>进入

  1、添加引用

  2、在页面上拖放控件

  3、

  <%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>

  4、控件的基本属性设置

  <webdiyer:AspNetPager 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>

【责编:peter】

0 0