热搜：编程 Python Microsoft 编程语言 C++

gridview+objectdatasource+aspnetpager整合实例

发布时间：2023-03-04 20:34:48 来源：好代码

.

初夏的脚步刚刚走来，人们纷纷把厚重的单衣脱掉，换上了凉爽的短袖，又把旅游鞋换成了颜色各不相同的夹鞋，有淡绿色的；有洁白的；还有深蓝色的……

前台代码：


<asp:GridView ID="viewIShow" runat="server" DataSourceID="ObjectDataSource1"
 AllowPaging="True" AutoGenerateColumns="False"
 OnRowCommand="viewIShow_RowCommand" PageSize="2"
 OnPageIndexChanging="viewIShow_PageIndexChanging" 
 OnDataBound="viewIShow_DataBound">
 <Columns>
 <asp:BoundField DataField="title" HeaderText="名称" />
 <asp:BoundField DataField="clicknum" HeaderText="播放次数" />
 <asp:BoundField DataField="addtime" HeaderText="更新日期" />
 <asp:TemplateField HeaderText="操作">
 <ItemTemplate>
 <asp:LinkButton ID="LinkButton1" runat="server" CommandName="up" CommandArgument='<%#Eval("id") %>'>晋级</asp:LinkButton><asp:LinkButton
 ID="LinkButton2" runat="server" CommandName="down" CommandArgument='<%#Eval("id") %>'>降级</asp:LinkButton>
 </ItemTemplate>
 </asp:TemplateField>
 </Columns>
 <PagerTemplate>
 <table border="0" cellpadding="0" cellspacing="1" style="width: 100%; height: 100%;">
 <tr style="height: 28px; padding-left: 20px;">
 <td class="pages">
 <webdiyer:AspNetPager ID="myPage" runat="server"
 OnPageChanged="myPage_PageChanged" ></webdiyer:AspNetPager>
 </td>
 </tr>
 </table>
 </PagerTemplate>
 </asp:GridView>
 <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
 DataObjectTypeName="AUDIOSYSTEM.Model.ishow" DeleteMethod="Delete"
 InsertMethod="Add" SelectMethod="GetList" TypeName="AUDIOSYSTEM.BLL.ishow"
 UpdateMethod="Update" OnSelected="ObjectDataSource1_Selected">
 <SelectParameters>
 <asp:Parameter Name="type" Type="String" DefaultValue="week" />
 <asp:ControlParameter ControlID="txtStartTime"
 DefaultValue="2000/01/01 00:00:00" Name="start"
 PropertyName="Text" Type="DateTime" />
 <asp:ControlParameter ControlID="txtEndTime" Name="end" PropertyName="Text"
 Type="DateTime" DefaultValue="2500/01/01 00:00:00" />
 </SelectParameters>
 <DeleteParameters>
 <asp:Parameter Name="videoId" Type="Int32" />
 <asp:Parameter Name="type" Type="String" DefaultValue="week" />
 </DeleteParameters>
 </asp:ObjectDataSource>

后台代码：


protected void myPage_PageChanged(object sender, EventArgs e)
 {
 GridViewRow pagerRow = viewIShow.BottomPagerRow;
 AspNetPager myPage = (AspNetPager)pagerRow.Cells[0].FindControl("myPage");
 viewIShow.PageIndex = myPage.CurrentPageIndex - 1;
 } protected void viewIShow_DataBound(object sender, EventArgs e)
 {
 GridViewRow pagerRow = viewIShow.BottomPagerRow;
 AspNetPager myPage = (AspNetPager)pagerRow.Cells[0].FindControl("myPage"); GridView view = (GridView)sender;
 myPage.PageSize = view.PageSize;
 myPage.CurrentPageIndex = view.PageIndex +1; //GridView分页索引是从0开始，AspNetPager是从1开始的
 } protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e)
 {
 DataSet ds = (DataSet)e.ReturnValue; //ObjectDataSource查询方法返回什么类型就转成什么类型 GridViewRow pagerRow = viewIShow.BottomPagerRow;
 AspNetPager myPage = (AspNetPager)pagerRow.Cells[0].FindControl("myPage"); if (ds == null)
 {
 myPage.RecordCount = 0;
 }
 else
 {
 myPage.RecordCount = ds.Tables[0].Rows.Count;
 }
 }