利用GridView控件实现分页效果
来源:互联网 发布:pdf可以转成ppt吗 知乎 编辑:程序博客网 时间:2024/05/23 13:03
前台设计
<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>
</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+"页";
}
}
- 利用GridView控件实现分页效果
- VS-利用GridView控件实现假分页
- GridView控件实现分页
- GridView控件实现分页
- GridView控件实现分页功能
- GridView控件实现分页功能
- 如何利用GridView与UpdatePanel组合实现无刷新:新增、编辑、删除、分页效果?
- 利用GridView与UpdatePanel组合实现无刷新:新增、编辑、删除、分页效果
- GridView手写数据源并实现分页效果
- 实现gridview 分页,左右滑动效果
- AspNetPager+GridView+SqlDataSource实现分页效果
- GridView控件自定义分页的实现
- 使用AspNetPager控件实现GridView分页
- 如何实现GridView控件分页显示数据
- 利用GridView控件实现数据添加
- 利用纯JSP技术实现分页效果
- 在cocos2d-x 3.2下利用UI下面的控件模仿实现GridView部分效果<一>实现构思
- repeater控件如何实现分页效果
- 尾递归小叙
- 声明变量
- spring版本兼容问题
- UBOOT 通过 TFTP 下载 uImage
- spring注解: @componet 、@Repository、@Service 和 @Controller
- 利用GridView控件实现分页效果
- GIS中空间分析中的八个问题
- dedecms织梦网
- hdu 2570 迷瘴
- 谈谈Dictionary和List的问题
- cocos2d-x 心得
- JAVA国际化
- hdu 1395 2^x mod n = 1给定n值 求x
- 泛型