一个简答的Access下的分页

分页
    public void listArticle()
{
CmsArticle arObj
= new CmsArticle();
DataSet ds
= arObj.listArticle();
if (ds != null)
{
PagedDataSource pds
= new PagedDataSource();
pds.DataSource
= ds.Tables[0].DefaultView;
pds.AllowPaging
= true;
pds.PageSize
= 1;
pds.CurrentPageIndex
= currentpage - 1;

rsCount
= ds.Tables[0].Rows.Count;
pageCount
= pds.PageCount;
pagesize
= pds.PageSize;

gvNewList.DataSource
= pds;
gvNewList.DataBind();


///上下页
double result;
result
= rsCount / pagesize;
string[] r = new string[2];
r
= result.ToString().Split('.');
pageCount
= Convert.ToInt32(r[0]);

if (result > pageCount)
{
pageCount
= pageCount + 1;
}

///上一页和首页
if (!pds.IsFirstPage)
{
lnkPrev.NavigateUrl
= "?page=" + Convert.ToString(currentpage - 1);
//lnkHead.NavigateUrl ="?Page=" + Convert.ToString(1);
}

///下一页和末页
if (!pds.IsLastPage)
{
lnkNext.NavigateUrl
= "?page=" + Convert.ToString(currentpage + 1);
//lnkEnd.NavigateUrl = "?Page=" + Convert.ToString(rsCount);
}
}



listInfoLabel.Text
= "全部共" + rsCount + "篇,每页" + pagesize + "篇,当前第" + currentpage + "/" + pageCount + "";
pageInfoLiteral.Text
= WebApp.Pagination.Show(currentpage, pageCount, 10, "?page=", "");
}

 

posted @ 2010-03-16 10:41  沙茶叶  阅读(202)  评论(0编辑  收藏  举报