Asp.net中使用PageDataSource分頁(yè)實(shí)現(xiàn)代碼

注:封裝數(shù)據(jù)綁定控件（如 System.Web.UI.WebControls.DataGrid、System.Web.UI.WebControls.GridView、System.Web.UI.WebControls.DetailsView
    //     和 System.Web.UI.WebControls.FormView）的與分頁(yè)相關(guān)的屬性，以允許該控件執(zhí)行分頁(yè)操作。無法繼承此類。
DataList
public DataTable GetDataSet(string sql)
    {
        SqlConnection conn = this.getconn();
        SqlDataAdapter sdr = new SqlDataAdapter(sql, conn);
        DataSet rs = new DataSet();
        sdr.Fill(rs);
        return rs.Tables[0];
    }
    public PagedDataSource PageDataListBind(string sql, int currentPage, int PageSize)
    {
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = GetDataSet(sql).DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = PageSize;
        pds.CurrentPageIndex = currentPage - 1;
        return pds;
    }

 
DB db = new DB();
    PagedDataSource pds = new PagedDataSource();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            bind();
        }
    }

    public void bind()
    {
        pds = db.PageDataListBind("select * from tb_word",Convert.ToInt32(lblCurrentPage.Text),2);  
        lnkBtnFirst.Enabled = true;
        lnkBtnLast.Enabled = true;
        lnkBtnPrevious.Enabled = true;
        lnkBtnNext.Enabled = true;
        if (lblCurrentPage.Text == "1")
        {
            lnkBtnFirst.Enabled = false;
            lnkBtnPrevious.Enabled = false;
        }
        if(lblCurrentPage.Text==pds.PageCount.ToString())
        {
            lnkBtnLast.Enabled = false;
            lnkBtnNext.Enabled = false;
        }
        lblSumPage.Text = pds.PageCount.ToString();
        DataList1.DataSource = pds;
        DataList1.DataKeyField = "ID";
        DataList1.DataBind();
    }

    protected void lnkBtnFirst_Click(object sender, EventArgs e)
    {
        lblCurrentPage.Text = "1";
        bind();
    }
    protected void lnkBtnPrevious_Click(object sender, EventArgs e)
    {
        lblCurrentPage.Text = (Convert.ToInt32(lblCurrentPage.Text) - 1).ToString();
        bind();
    }
    protected void lnkBtnNext_Click(object sender, EventArgs e)
    {
        lblCurrentPage.Text = (Convert.ToInt32(lblCurrentPage.Text) + 1).ToString();
        bind();
    }
    protected void lnkBtnLast_Click(object sender, EventArgs e)
    {
        lblCurrentPage.Text = lblSumPage.Text;
        bind();
    }

form id="form1" runat="server">
    div>
        asp:DataList ID="DataList1" runat="server">
        ItemTemplate>
            table border="1">
                tr>
                    td>ID/td>td>標(biāo)題/td>td>內(nèi)容/td>
                /tr>
                tr>
                    td>%#Eval("ID") %>/td>
                    td>%#Eval("Title") %>/td>
                    td>%#Eval("Content") %>/td>
                /tr>
            /table>
        /ItemTemplate>
        /asp:DataList>
        當(dāng)前頁(yè)碼為［asp:Label ID="lblCurrentPage" runat="server" Text="1">/asp:Label>］頁(yè)
                總頁(yè)碼［asp:Label
                    ID="lblSumPage" runat="server" Text="0">/asp:Label>］頁(yè)
                asp:LinkButton ID="lnkBtnFirst" runat="server" Font-Underline="False" OnClick="lnkBtnFirst_Click" > 第一頁(yè) /asp:LinkButton>
                asp:LinkButton ID="lnkBtnPrevious" runat="server" Font-Underline="False" OnClick="lnkBtnPrevious_Click" > 上一頁(yè) /asp:LinkButton>
                asp:LinkButton ID="lnkBtnNext" runat="server" Font-Underline="False" OnClick="lnkBtnNext_Click" > 下一頁(yè) /asp:LinkButton>
                asp:LinkButton ID="lnkBtnLast" runat="server" Font-Underline="False" OnClick="lnkBtnLast_Click"> 末一頁(yè) /asp:LinkButton>
    /div>
    /form>