AspNetPager分页实例

//列举其中两个方法

//方法一

//后台程序

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class gridview : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
      
        AspNetPager1.CurrentPageIndex = 1;
     
        this.bind();
    }

    public void bind()
    {
        string sqltrn = "select * from Orders";
        SqlConnection con = db.reatesqlcon();
        SqlDataAdapter sd = new SqlDataAdapter(sqltrn,con);
        DataSet ds = new DataSet();
        sd.Fill(ds);
         DataView dv =ds.Tables[0].DefaultView;
         this.AspNetPager1.RecordCount =dv.Count;
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = dv;
        pds.AllowPaging = true;
        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
        pds.PageSize = AspNetPager1.PageSize;
        this.GridView1.DataSource = pds;
        this.GridView1.DataBind();

    }
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        this.bind();
    }
}

//方法二

private void RepeaterBind()
        {
            using (SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=123;database=db_shopping"))
            {
                SqlDataAdapter da = new SqlDataAdapter("select * from tb_product", con);
                DataSet ds = new DataSet();
                da.Fill(ds);
                AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
                da.Fill(ds,AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"tbpager");
          
                Repeater1.DataSource = ds.Tables["tbpager"].DefaultView;
                Repeater1.DataBind();
            }
        }

        protected void AspNetPager1_PageChanged(object sender, EventArgs e)
        {
            RepeaterBind();
        }