簡單實現DateLIst分頁

最新推荐文章于 2021-01-10 12:08:46 发布

So_CooL

最新推荐文章于 2021-01-10 12:08:46 发布

阅读量1.3k

点赞数

分类专栏： VS.NET源代碼文章标签： dataset button object

本文链接：https://blog.csdn.net/So_CooL/article/details/763750

版权

VS.NET源代碼专栏收录该内容

46 篇文章 0 订阅

订阅专栏

控件介紹：2個Button 2個libel private void ToDataList() { int curpage=Convert.ToInt32(this.Label2.Text); SqlConnection con=DB.CreateDB(); SqlDataAdapter sda=new SqlDataAdapter(); sda.SelectCommand=new SqlCommand("select * from news Where redge='變更明細' order by Newstime desc",con); DataSet ds=new DataSet(); sda.Fill(ds,"emp"); System.Web.UI.WebControls.PagedDataSource ps=new System.Web.UI.WebControls.PagedDataSource(); ps.DataSource=ds.Tables["emp"].DefaultView; ps.AllowPaging=true; ps.PageSize=60; ps.CurrentPageIndex=curpage-1; this.Button1.Enabled=true; this.Button2.Enabled=true; if(curpage==1) { this.Button1.Enabled=false; } if(curpage==ps.PageCount) { this.Button2.Enabled=false; } this.DataList1.DataSource=ps; this.DataList1.DataBind(); } private void Button1_Click(object sender, System.EventArgs e) { this.Label2.Text=Convert.ToString(Convert.ToInt32(this.Label2.Text)-1); this.ToDataList(); } private void Button2_Click(object sender, System.EventArgs e) { this.Label2.Text=Convert.ToString(Convert.ToInt32(this.Label2.Text)+1); this.ToDataList(); }