DataList的分页

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

飞天小鱼

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

阅读量465

点赞数

文章标签： dataset null

本文链接：https://blog.csdn.net/minjunyu/article/details/1791351

版权

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
  private void binddlp()
  {
   DataSet ds=new DataSet();
   ds=SqlHelper.ExecuteDataset(JScript.g_cnnStr(),CommandType.Text,"select top 100 * from sysobjects");
   PagedDataSource pds=new PagedDataSource();
   pds.DataSource=ds.Tables[0].DefaultView;

pds.AllowPaging=true;
pds.PageSize=8;

int CurrentPage;

   if(Request.QueryString["Page"]!=null)
   {
    CurrentPage=Convert.ToInt32(Request.QueryString["Page"]);
   }
   else
   {
    CurrentPage=1;
   }

   pds.CurrentPageIndex=CurrentPage-1;
   lblCurrentPage.Text=CurrentPage.ToString();
   lblPageCount.Text=pds.PageCount.ToString();

   if(!pds.IsFirstPage)
   {
    lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+Convert.ToInt32(CurrentPage-1);
    lnkFirst.NavigateUrl=Request.CurrentExecutionFilePath+"?Page=1";
   }
   if(!pds.IsLastPage)
   {
    lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+Convert.ToInt32(CurrentPage+1);
    lnkLast.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+pds.PageCount;
   }

   DataList1.DataSource=pds;
   DataList1.DataBind();
  }
}