private void indexListBind()

??? {

??????? try

??????? {

??????????? string parID = Request.QueryString["id"].ToString();

??????????? int curPage = Convert.ToInt32(this.lb_pageIndex.Text) - 1;//獲取當前頁碼,我用的是一個lable.當了中間變量

??????????? con = Admin_DB.getConn();

??????????? con.Open();

??????????? DataSet ds = new DataSet();

??????????? string Path = "~";

??????????? OleDbDataAdapter sda = new OleDbDataAdapter("select ID,'" + Path + "'+imagePath as imagePath,introduce from D_Picture where parID=@parID", con);

??????????? sda.SelectCommand.Parameters.Add(new OleDbParameter("@parID", parID));

??????????? sda.Fill(ds, "index");

????? ??????System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();//實例化分頁數據源

??????????? ps.DataSource = ds.Tables["index"].DefaultView;//將要綁定在datalist上的datatable給分頁數據源

??????????? ps.AllowPaging = true;

??????????? ps.PageSize = 8;//每頁顯示幾條記錄

??? ????????ps.CurrentPageIndex = curPage;//設置當前頁的索引(當前頁碼減1就是)

??????????? this.btn_up.Enabled = true;

??????????? this.btn_next.Enabled = true;

??????????? this.btn_frist.Enabled = true;

??????????? this.btn_end.Enabled = true;

??????????? endPage = ps.PageCount;

??????????? if (curPage == 0)//當是第一頁是.上一頁和首頁的按鈕不可用

??????????? {

??????????????? this.btn_up.Enabled = false;

??????????????? this.btn_frist.Enabled = false;

??????????? }

??????????? if (curPage == ps.PageCount - 1)//當是最后一頁時下一頁和最后一頁的按鈕不可用

??????????? {

??????????????? this.btn_next.Enabled = false;

??????????????? this.btn_end.Enabled = false;

??????????? }

??????????? this.indexList.DataSource = ps;

??????????? this.indexList.DataKeyField = "ID";

??????????? this.indexList.DataBind();

??????????? con.Close();

??????? }

??????? catch (Exception ex)

??????? {

??????????? Console.WriteLine(ex.Message);

??????? }

?

??? }

??? protected void btn_frist_Click(object sender, EventArgs e)

??? {

??????? this.lb_pageIndex.Text = "1";

??????? this.indexListBind();

??? }

??? protected void btn_up_Click(object sender, EventArgs e)

??? {

??????? int page = int.Parse(this.lb_pageIndex.Text) - 1;

??????? this.lb_pageIndex.Text = page.ToString();

??????? this.indexListBind();

??? }

??? protected void btn_next_Click(object sender, EventArgs e)

??? {

??????? int page = int.Parse(this.lb_pageIndex.Text) + 1;

??????? this.lb_pageIndex.Text = page.ToString();

??????? this.indexListBind();

??? }

??? protected void btn_end_Click(object sender, EventArgs e)

??? {

??????? this.lb_pageIndex.Text = endPage.ToString();

??????? this.indexListBind();

}

轉載于:https://www.cnblogs.com/Miton/archive/2011/06/01/2066069.html

總結

以上是生活随笔為你收集整理的datalist 分页的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。