使用分頁模闆完成，顯示上一頁，下一頁，第一頁，最後一頁，和目前第x頁，共y頁 。

部落格内容清單前台：

<asp:GridView ID="GridView2" runat="server" AllowPaging="True" 

        AutoGenerateColumns="False" DataKeyNames="sid" 

        onrowdatabound="GridView2_RowDataBound" PageSize="3" 

        onpageindexchanging="GridView1_PageIndexChanging" ShowFooter="True">

        <Columns>

            <asp:BoundField DataField="sid" HeaderText="sid" InsertVisible="False" 

                ReadOnly="True" SortExpression="sid" />

            <asp:BoundField DataField="sname" HeaderText="sname" SortExpression="sname" />

            <asp:BoundField DataField="classid" HeaderText="classid" 

                SortExpression="classid" />

            <asp:BoundField DataField="sex" HeaderText="sex" SortExpression="sex" />

            <asp:BoundField DataField="age" HeaderText="age" SortExpression="age" />

            <asp:CheckBoxField DataField="isking" HeaderText="isking" 

                SortExpression="isking" />

            <asp:BoundField DataField="photo" HeaderText="photo" SortExpression="photo" />

        </Columns>

        <PagerSettings FirstPageText="|&amp;lt;" LastPageText="&amp;gt;|" 

            Mode="NextPreviousFirstLast" Visible="False" />

        <PagerTemplate>

            <asp:Button ID="Button1" runat="server" CommandArgument="First" 

                CommandName="page" Text="|&lt;" />

            &nbsp;<asp:Button ID="Button2" runat="server" CommandArgument="prev" 

                CommandName="page" Text="&lt;" />

            &nbsp;<asp:Button ID="Button3" runat="server" CommandArgument="next" 

                CommandName="page" Text="&gt;" />

            &nbsp;<asp:Button ID="Button4" runat="server" CommandArgument="Last" 

                CommandName="page" Text="&gt;|" />

            &nbsp;<asp:Label ID="Label1" runat="server"></asp:Label>

        </PagerTemplate>

    </asp:GridView>

    <br />

    <br />

    <asp:Button ID="btnFirst" runat="server" οnclick="btnFirst_Click" Text="第一頁" />

&nbsp;<asp:Button ID="btnPrev" runat="server" οnclick="btnPrev_Click" Text="上一頁" />

&nbsp;<asp:Button ID="btnNext" runat="server" οnclick="btnNext_Click" Text="下一頁" />

&nbsp;<asp:Button ID="btnLast" runat="server" οnclick="btnLast_Click" Text="末頁" />

&nbsp;<asp:Label ID="Label2" runat="server"></asp:Label>

背景：

protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                BindStudent();

            }

        }

        private void BindStudent()

        {

            string sql = "select * from student";

            DataTable dt = SQLHelper.ExecuteDataTable(sql);

            this.GridView2.DataSource = dt;

            this.GridView2.DataBind();

        }

  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();

        }

        protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)

        {

                Label2.Text = "第" + (GridView2.PageIndex + 1).ToString() + "頁，共" + GridView2.PageCount + "頁";

        }

-------------------------------------------------------------------------------------------------

Web.config:

    <connectionStrings>

        <add name="studentConnectionString" connectionString="Data Source=PC_THINK-THINK;Initial Catalog=student;Persist Security Info=True;User ID=sa;Password=111111"

            providerName="System.Data.SqlClient" />

        <add name="studentConnectionString2" connectionString="Data Source=PC_THINK-THINK;Initial Catalog=student;Persist Security Info=True;User ID=sa;Password=111111"

            providerName="System.Data.SqlClient" />

    </connectionStrings>

SQLHelper.cs:

    public static DataTable ExecuteDataTable(string sql, params SqlParameter[] pms)

    {

        DataTable dt = new DataTable();

        SqlDataAdapter adapter = new SqlDataAdapter(sql,connStr);

        if (pms != null)

        {

            adapter.SelectCommand.Parameters.AddRange(pms);

        }

        adapter.Fill(dt);

        return dt;

    }

在這道題中用到了資料集 DataSet1.xsd

----------------------------------------------------------------------------------------------------