ASP.NET 分頁資料來源:: PagedDataSource //可分頁資料來源

Demo

        int pagetCount = Convert.ToInt32(this.Label1.Text);
         SqlConnection con = DB.con;
         SqlDataAdapter sda = new SqlDataAdapter();
         DataSet ds = new DataSet();
         PagedDataSource ps = new PagedDataSource();//可分頁資料來源
         sda.SelectCommand = new SqlCommand("select top(90) * from books", con);
        try
         {
             con.Open();
             sda.Fill(ds, "books");
             ps.DataSource = ds.Tables["books"].DefaultView;//初始化可分頁資料來源的資料來源屬性
             ps.AllowPaging = true;//設定為可分頁
             ps.PageSize = 10;//設定每頁顯示多少行資料
             ps.CurrentPageIndex = pagetCount - 1;//設定當前頁
            this.Button1.Enabled = true;
            this.Button2.Enabled = true;

            this.Repeater1.DataSource = ps;//用可分頁資料來源初始Repeater控制項
            this.Repeater1.DataBind(); //綁定   
            if (pagetCount==1)
             {
                this.Button1.Enabled = false;
             }
            if (pagetCount == ps.PageCount)
             {
                this.Button2.Enabled = false;
             }