62,046
社区成员
发帖
与我相关
我的任务
分享
//利用pagedatasource分页
PagedDataSource pgds = new PagedDataSource();
pgds.DataSource = paperList; //paperList是得到的list集合
pgds.AllowPaging = true;//允许分页
pgds.PageSize = 30;//每页数据量
pgds.CurrentPageIndex = (Convert.ToInt32(ViewState["pagen"]));//设置显示当前第几页
this.lbPageCount.Text = pgds.PageCount.ToString(); //显示共有多少页
this.lbPagen.Text = (Convert.ToInt32(ViewState["pagen"]) + 1).ToString(); //当前第几页
//如果总页数小于当前页,
if (pgds.PageCount < pgds.CurrentPageIndex + 1)
{
ViewState["pagen"] = 0;
pgds.CurrentPageIndex = (Convert.ToInt32(ViewState["pagen"]));
this.lbPageCount.Text = pgds.PageCount.ToString(); //显示共有多少页
this.lbPagen.Text = (Convert.ToInt32(ViewState["pagen"]) + 1).ToString(); //当前第几页
}
SetEnable(pgds);//是否可点??
dlPaper.DataSource = pgds;
dlPaper.DataBind();
string sql = "SELECT TOP 30 * FROM Code_Paper WHERE " + RegionIdSql + CategoryIdSql+ " AND PaperId NOT IN (SELECT TOP (30*(@PageSize-1)) PaperId FROM Code_Paper WHERE " + RegionIdSql + CategoryIdSql + ")";