将模版列功能改造成博客内容列表， 并使完成分页 （使用分页模板完成，显示上一页，下一页，第一页，最后一页，和当前第x页，共y页 。）

-------前台代码 

 <form id="form1" runat="server">
    <div>
   
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:TestConnectionString3 %>"
            DeleteCommand="DELETE FROM [Student] WHERE [sId] = @sId"
            InsertCommand="INSERT INTO [Student] ([sName], [sAge], [sSex], [sphoto]) VALUES (@sName, @sAge, @sSex, @sphoto)"
            SelectCommand="SELECT [sId], [sName], [sAge], [sSex], [sphoto] FROM [Student]"
           
            UpdateCommand="UPDATE [Student] SET [sName] = @sName, [sAge] = @sAge, [sSex] = @sSex, [sphoto] = @sphoto WHERE [sId] = @sId">
            <DeleteParameters>
                <asp:Parameter Name="sId" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="sName" Type="String" />
                <asp:Parameter Name="sAge" Type="Int32" />
                <asp:Parameter Name="sSex" Type="String" />
                <asp:Parameter Name="sphoto" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="sName" Type="String" />
                <asp:Parameter Name="sAge" Type="Int32" />
                <asp:Parameter Name="sSex" Type="String" />
                <asp:Parameter Name="sphoto" Type="String" />
                <asp:Parameter Name="sId" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
   
    </div>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
        AllowSorting="True" AutoGenerateColumns="False" ClientIDMode="Static"
        onpageindexchanging="GridView1_PageIndexChanging"
        onrowdatabound="GridView1_RowDataBound" PageSize="3">
        <EmptyDataTemplate>
            姓名：<asp:TextBox ID="TextBox1" runat="server" Text='<%#Eval("sName") %>'> </asp:TextBox>
             年龄：<asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("sAge") %>'> </asp:TextBox>
              照片：<asp:TextBox ID="TextBox3" runat="server" Text='<%#Eval("sphoto") %>'>
            </asp:TextBox>
        </EmptyDataTemplate>
        <PagerSettings FirstPageText="|&amp;lt;" LastPageText="&amp;gt;|"
            Mode="NextPreviousFirstLast" />
        <PagerTemplate>
            <asp:Button ID="Button1" runat="server" CommandArgument="First"
                CommandName="page" Text="第一页" />
            <asp:Button ID="Button2" runat="server" CommandArgument="prev"
                CommandName="page" Text="上一页" />
            <asp:Button ID="Button3" runat="server" CommandArgument="next"
                CommandName="page" Text="下一页" />
            <asp:Button ID="Button4" runat="server" CommandArgument="last"
                CommandName="page" Text="末一页" />
            <br />
            <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        </PagerTemplate>
    </asp:GridView>
    </form>

------后台代码

 public partial class WebForm1 : 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 = SqlHelper.ExecuteDataTable(sql);
            this.GridView1.DataSource = dt;
            this.GridView1.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();
            }
          
        }
    }