让DataList实现分页功能

DataList可以一次显示多条记录且风格自由,可以制作出十分优秀的界面,但其本身不具有分页功能.不过我们可以通过增加几个Label控件,让DataList实现分页功能,示例代码如下:

protected void DataListBind()
       {
           AccessDataSource ads = new AccessDataSource();
           ads.SelectCommand = "select * from board order by board_time desc";
           ads.DataFile = "~/App_Data/news.mdb";
           DataView dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);
           PagedDataSource objPage = new PagedDataSource();
           objPage.DataSource = dv;
           objPage.AllowPaging = true;
           objPage.PageSize = 2;
           Int32 CurPage,TolPage;
           TolPage = objPage.PageCount;
           if (Request.QueryString["Page"] != null)
           {
               CurPage = Convert.ToInt32(Request.QueryString["Page"]);
           }
           else
           {
               CurPage = 1 ;
           }
           objPage.CurrentPageIndex = CurPage - 1;
           lblCurPage.Text = "当前第" + CurPage.ToString() + "页,共" + TolPage.ToString()+"页";

           lnkFirst.NavigateUrl=Request.CurrentExecutionFilePath+"?Page=1&main_id="+Request.QueryString["main_id"];
           lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TolPage.ToString() + "&main_id=" + Request.QueryString["main_id"];
           if (!objPage.IsFirstPage)
           {
               lnkPerv.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) + "&main_id=" + Request.QueryString["main_id"];
           }
           else
           {
               lnkPerv.Visible = false;
               lnkFirst.Visible = false;
           }
           if (!objPage.IsLastPage)
           {
               lnlNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) + "&main_id=" + Request.QueryString["main_id"];
           }
           else
           {
               lnlNext.Visible = false;
               lnkLast.Visible = false;
           }
           DataList1.DataSource = objPage;
           DataList1.DataBind();
       }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值