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

本文介绍了一个用于学生信息管理的系统,包括学生信息的增删改查功能,以及使用GridView组件实现分页展示。

前台:

<body>
 <form id="form1" runat="server">
 <div>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:studentConnectionString %>"
DeleteCommand="DELETE FROM [student] WHERE [sid] = @sid"
InsertCommand="INSERT INTO [student] ([sname], [classid], [sex], [age], [isking], [photo]) VALUES (@sname, @classid, @sex, @age, @isking, @photo)"
SelectCommand="SELECT * FROM [student]"
UpdateCommand="UPDATE [student] SET [sname] = @sname, [classid] = @classid, [sex] = @sex, [age] = @age, [isking] = @isking, [photo] = @photo WHERE [sid] = @sid">
 <DeleteParameters>
 <asp:Parameter Name="sid" Type="Int32" />
 </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="sid" Type="Int32" />
 </UpdateParameters>
 </asp:SqlDataSource>
 <br />
 <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
PageSize="3" Height="172px"
Width="437px" Xonpageindexchanging="GridView1_PageIndexChanging"
AutoGenerateColumns="False" DataKeyNames="sid" DataSourceID="SqlDataSource1"
Xonrowdatabound="GridView1_RowDataBound1" >
 <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" />
 <PagerTemplate>
 <asp:Button ID="Button1" runat="server" Text="第一页" CommandName="page"
CommandArgument="first" Height="18px" Width="46px" />
 &nbsp;<asp:Button ID="Button2" runat="server" Text="上一页" CommandName="page"
CommandArgument="prev" Height="18px" Width="46px" />
 &nbsp;<asp:Button ID="Button3" runat="server" Text="下一页" CommandArgument="next"
CommandName="page" Height="18px" Width="46px" />
 &nbsp;<asp:Button ID="Button4" runat="server" Text="最末页" CommandName="page"
CommandArgument="last" Height="18px" Width="66px" />
 &nbsp;<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
 </PagerTemplate>
 </asp:GridView>
 </div>
 </form>
</body>

后台:

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 + "页";
 
}
 
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值