首页 > 代码库 > 分页技术方法AspNetPage

分页技术方法AspNetPage

 private void bind()  {            

    AspNetPager1.RecordCount = getCount();            

    AspNetPager1.PageSize = 5;            

     string sql = "select * from Books";            

     SqlDataAdapter da = new SqlDataAdapter(sql, ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString);            

    DataTable dt = new DataTable();            

    da.Fill((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize, AspNetPager1.PageSize, dt);            

     Repeater1.DataSource = dt.DefaultView;            

    Repeater1.DataBind();  

}

 

 

 private int getCount()  {            

    string sql = "select count(*) from Books";

            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString))            

     {                

        SqlCommand cmd = new SqlCommand(sql,conn);                

        conn.Open();                

        int num = Convert.ToInt32(cmd.ExecuteScalar());                

        conn.Close();                

        return num;            

      }  

}

 

  protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)  

  {            

        AspNetPager1.CurrentPageIndex = e.NewPageIndex;            

        bind();  

  }

 

 

 

  <webdiyer:AspNetPager ID="AspNetPager1" runat="server"            

  FirstPageText="首页" LastPageText="末页" NextPageText="下一页" NumericButtonCount="5"            

  onpagechanging="AspNetPager1_PageChanging" PageIndexBoxType="DropDownList"            

  PageSize="5" PrevPageText="上一页" ShowCustomInfoSection="Left"            

  ShowPageIndexBox="Always" >  

 

</webdiyer:AspNetPager>

分页技术方法AspNetPage