datalist 分页

来源：互联网发布：阿里云服务器数据迁移编辑：程序博客网时间：2024/05/16 01:52

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();
  }
}