GridView实现分页的两种方法

最新推荐文章于 2023-03-10 13:57:09 发布

耿宇丹

最新推荐文章于 2023-03-10 13:57:09 发布

阅读量888

点赞数 1

分类专栏： ASP.NET高级

本文链接：https://blog.csdn.net/gengyudan/article/details/8276692

版权

ASP.NET高级专栏收录该内容

19 篇文章 0 订阅

订阅专栏

前台设计：

<body>
    <form id="form1" runat="server">
    <div>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:studentConnectionString %>"
            DeleteCommand="DELETE FROM [student] WHERE [sid] = @original_sid AND [sname] = @original_sname AND (([classid] = @original_classid) OR ([classid] IS NULL AND @original_classid IS NULL)) AND (([sex] = @original_sex) OR ([sex] IS NULL AND @original_sex IS NULL)) AND (([age] = @original_age) OR ([age] IS NULL AND @original_age IS NULL)) AND [isking] = @original_isking AND (([photo] = @original_photo) OR ([photo] IS NULL AND @original_photo IS NULL))"
            InsertCommand="INSERT INTO [student] ([sname], [classid], [sex], [age], [isking], [photo]) VALUES (@sname, @classid, @sex, @age, @isking, @photo)"
            OldValuesParameterFormatString="original_{0}"
            SelectCommand="SELECT * FROM [student]"
            UpdateCommand="UPDATE [student] SET [sname] = @sname, [classid] = @classid, [sex] = @sex, [age] = @age, [isking] = @isking, [photo] = @photo WHERE [sid] = @original_sid AND [sname] = @original_sname AND (([classid] = @original_classid) OR ([classid] IS NULL AND @original_classid IS NULL)) AND (([sex] = @original_sex) OR ([sex] IS NULL AND @original_sex IS NULL)) AND (([age] = @original_age) OR ([age] IS NULL AND @original_age IS NULL)) AND [isking] = @original_isking AND (([photo] = @original_photo) OR ([photo] IS NULL AND @original_photo IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_sid" Type="Int32" />
                <asp:Parameter Name="original_sname" Type="String" />
                <asp:Parameter Name="original_classid" Type="Int32" />
                <asp:Parameter Name="original_sex" Type="String" />
                <asp:Parameter Name="original_age" Type="Byte" />
                <asp:Parameter Name="original_isking" Type="Boolean" />
                <asp:Parameter Name="original_photo" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="sname" Type="String" />
                <asp:Parameter Name="classid" Type="Int32" />
                <asp:Parameter Name="sex" Type="String" />
                <asp:Parameter Name="age" Type="Byte" />
                <asp:Parameter Name="isking" Type="Boolean" />
                <asp:Parameter Name="photo" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="sname" Type="String" />
                <asp:Parameter Name="classid" Type="Int32" />
                <asp:Parameter Name="sex" Type="String" />
                <asp:Parameter Name="age" Type="Byte" />
                <asp:Parameter Name="isking" Type="Boolean" />
                <asp:Parameter Name="photo" Type="String" />
                <asp:Parameter Name="original_sid" Type="Int32" />
                <asp:Parameter Name="original_sname" Type="String" />
                <asp:Parameter Name="original_classid" Type="Int32" />
                <asp:Parameter Name="original_sex" Type="String" />
                <asp:Parameter Name="original_age" Type="Byte" />
                <asp:Parameter Name="original_isking" Type="Boolean" />
                <asp:Parameter Name="original_photo" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
            PageSize="3" onpageindexchanging="GridView1_PageIndexChanging"
            onrowdatabound="GridView1_RowDataBound" ShowFooter="True">
            <PagerSettings FirstPageText="|&lt;" LastPageText="&gt;|"
                Mode="NextPreviousFirstLast" />
            <PagerTemplate>
                <asp:Button ID="Button1" runat="server" CommandArgument="First"
                    CommandName="page" Text="|<" Width="30px" />
                 <asp:Button ID="Button2" runat="server" CommandArgument="prev"
                    CommandName="page" Text="<" Width="30px" />
                 <asp:Button ID="Button3" runat="server" CommandArgument="next"
                    CommandName="page" Text=">" Width="30px" />
                 <asp:Button ID="Button4" runat="server" CommandArgument="last"
                    CommandName="page" Text=">|" Width="30px" />
                <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
            </PagerTemplate>
        </asp:GridView>

        <br />
        <br />
        <asp:GridView ID="GridView2" runat="server" AllowPaging="True"
            PageSize="3" onpageindexchanging="GridView1_PageIndexChanging"
            onrowdatabound="GridView1_RowDataBound" ShowFooter="True" Width="302px">
            <PagerSettings FirstPageText="|&lt;" LastPageText="&gt;|"
                Mode="NextPreviousFirstLast" Visible="False" />
            <PagerTemplate>
                <asp:Button ID="Button1" runat="server" CommandArgument="First"
                    CommandName="page" Text="|<" Width="30px" />
                 <asp:Button ID="Button2" runat="server" CommandArgument="prev"
                    CommandName="page" Text="<" Width="30px" />
                 <asp:Button ID="Button3" runat="server" CommandArgument="next"
                    CommandName="page" Text=">" Width="30px" />
                 <asp:Button ID="Button4" runat="server" CommandArgument="last"
                    CommandName="page" Text=">|" Width="30px" />
                <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
            </PagerTemplate>
        </asp:GridView>

        <br />
        <asp:Button ID="btnfirst" runat="server" οnclick="btnfirst_Click" Text="第一页" />
 
        <asp:Button ID="btnPrev" runat="server" οnclick="btnPrev_Click" Text="上一页" />
 
        <asp:Button ID="btnNext" runat="server" οnclick="btnNext_Click" Text="下一页" />
 
        <asp:Button ID="btnLast" runat="server" οnclick="btnLast_Click" Text="最后一页" />

    </div>
    </form>
</body>

后台设计：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace _12_6内容
{
    public partial class Page1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindStudent();
            }

        }

        private void BindStudent()
        {
            string sql = "select * from student";
            DataTable dt = _11_28DataSet111.SqlHealper1.ExecuteDataTable(sql);
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
            this.GridView2.DataSource = dt;
            this.GridView2.DataBind();
        }

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.Pager)
            {
                (e.Row.Cells[0].FindControl("Label1") as Label).Text = "第"+(GridView1.PageIndex+1).ToString()+"页，共"+GridView1.PageCount+"页";
            }
        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            if (e.NewPageIndex >= 0)
            {
            this.GridView1.PageIndex = e.NewPageIndex;
            this.BindStudent();
            }
        }

        protected void btnfirst_Click(object sender, EventArgs e)
        {
            this.GridView2.PageIndex = 0;
            this.BindStudent();
        }

        protected void btnLast_Click(object sender, EventArgs e)
        {
            this.GridView2.PageIndex = this.GridView2.PageCount - 1;
            this.BindStudent();
        }

        protected void btnPrev_Click(object sender, EventArgs e)
        {
            int index = this.GridView2.PageIndex;
            if (index >= 1)
            {
                index--;
            }
            this.GridView2.PageIndex = index;
            this.BindStudent();
        }

        protected void btnNext_Click(object sender, EventArgs e)
        {
            int index = this.GridView2.PageIndex;
            if (index <this.GridView2.PageCount+1)
            {
                index++;
            }
            this.GridView2.PageIndex = index;
            this.BindStudent();
        }
    }
}