DataList 分页方式

DataList本身不具有分页功能，所以需要用户自定义分页。

在网上搜索了一下“关于DataList分页”的一些代码，自己也写了一些，大家分享！

1.      利用PagedDataSource实现分页

前台代码：

页数： & nbsp; < asp:Label ID = " LblPageCount "  runat = " server "  Font - Bold = " True " ></ asp:Label >& nbsp;页
                 & nbsp;
                 < asp:Label ID = " LblRecord "  runat = " server "  Font - Bold = " True " ></ asp:Label >& nbsp;个 / 页
                 & nbsp;共 & nbsp; < asp:Label ID = " LblRecordCount "  runat = " server "  Font - Bold = " True " ></ asp:Label >& nbsp;条
                 < asp:LinkButton ID = " LblFristPage "  runat = " server "  OnClick = " LblFristPage_Click " > 首页 </ asp:LinkButton >
                 < asp:LinkButton ID = " LblNextPage "  runat = " server "  OnClick = " LblNextPage_Click " > 下一页 </ asp:LinkButton >
                 < asp:LinkButton ID = " LblPrivPage "  runat = " server "  OnClick = " LblPrivPage_Click " > 上一页 </ asp:LinkButton >
                 < asp:LinkButton ID = " LblEndPage "  runat = " server "  OnClick = " LblEndPage_Click " > 末页 </ asp:LinkButton >

 

 

后台代码：

       

PagedDataSource pds  =   new  PagedDataSource();
        pds.DataSource  =  cndt.DefaultView;
        pds.CurrentPageIndex  =  CurrentPage  -   1 ;
        pds.PageSize  =   15 ;
        pds.AllowPaging  =   true ;
        PageCount  =  cndt.Rows.Count  /   15   +   1 ;
         this .LblPageCount.Text  =  CurrentPage  +   " / "   +  PageCount.ToString();
         this .LblRecord.Text  =   " 15 " ;
         this .LblRecordCount.Text  =  cndt.Rows.Count.ToString();

         this .CompanyCulture.DataSource  =  pds;
         this .CompanyCulture.DataKeyField  =   " ID " ;
         this .CompanyCulture.DataBind();
        GetPage();
    }
     private   void  GetPage()
     ... {
        if (CurrentPage == 1)
        ...{
            LblFristPage.Enabled = false;
            LblPrivPage.Enabled = false;
        }
        else
        ...{
            LblPrivPage.Enabled = true;
            LblFristPage.Enabled = true;
        }
        if (CurrentPage == PageCount)
        ...{
            LblEndPage.Enabled = false;
            LblNextPage.Enabled = false;
        }
        else
        ...{
            LblEndPage.Enabled = true;
            LblNextPage.Enabled = true;
        }
    }

 

 

 

2. 利用DataSet实现分页

 前台代码：

< asp:LinkButton ID = " LbtnFirst "  runat = " server "  CommandArgument = " first "  CommandName = " Pager "
                            OnCommand = " PageClick " > 首页 </ asp:LinkButton >
                         < asp:LinkButton ID = " LbtnNext "  runat = " server "  CommandArgument = " next "  CommandName = " Pager "
                            OnCommand = " PageClick " > 下一页 </ asp:LinkButton >
                         < asp:LinkButton ID = " LbtnPrev "  runat = " server "  CommandArgument = " prev "  CommandName = " Pager "
                            OnCommand = " PageClick " > 上一页 </ asp:LinkButton >
                         < asp:LinkButton ID = " LbtnEnd "  runat = " server "  CommandArgument = " end "  CommandName = " Pager "
                            OnCommand = " PageClick " > 末页 </ asp:LinkButton >
                         & nbsp;  & nbsp;
                         < asp:Label ID = " LblPageCount "  runat = " server "  Text = " 页数 " ></ asp:Label >& nbsp;
                         < asp:Label ID = " LblPageSize "  runat = " server "  Text = " 每页记录数 " ></ asp:Label >& nbsp;
                         < asp:Label ID = " LblRecordCount "  runat = " server "  Text = " Label " ></ asp:Label >& nbsp;
                         < asp:Label ID = " LblCurrentPage "  runat = " server "  Text = " 当前页数 " ></ asp:Label >& nbsp;

 

后台代码：

  

   private   void  GetRecordNum() // 获取记录总个数
     ... {
        DataSet dt = SearchHelp.SearchHelp.GetDataSet(sqlstr);
        RecordCount = dt.Tables[0].DefaultView.Count;
    }
     private   void  BindGrid() // 根据页码获取数据
     ... {
        PageCount = RecordCount / PageSize;
        if (RecordCount % PageSize != 0)
        ...{
            PageCount++;
        }
        PageIndex = PageSize * CurrentPage;
        this.LblCurrentPage.Text = "当前第：" + (CurrentPage + 1).ToString() + "页";
        this.LblRecordCount.Text = "共有：" + RecordCount.ToString() + "条记录";
        this.LblPageSize.Text = "每页 " + PageSize.ToString() + "条记录";
        this.LblPageCount.Text = "共有：" + PageCount.ToString() + "页";
        DataSet dt = SearchHelp.SearchHelp.GetDataSet(sqlstr, PageIndex, PageSize);//查询语句sqlstr，获取记录的起始索引PageIndex，获取记录的个数PageSize
        this.CarsList.DataSource = dt.Tables[0].DefaultView;
        this.CarsList.DataBind();

protected void PageClick(object sender, CommandEventArgs e)
    ...{
        string age = e.CommandArgument.ToString();
        switch (age)
        ...{
            case "next":
                if (CurrentPage < PageCount - 1)
                ...{
                    CurrentPage++;
                }
                break;
            case "prev":
                if (CurrentPage > 0)
                ...{
                    CurrentPage--;
                }
                break;
            case "first":
                ...{
                    CurrentPage = 0;
                }
                break;
            case "end":
                ...{
                    CurrentPage = PageCount - 1;
                }
                break;
        }
        BindGrid();
    }