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