主页 > 知识库 > gridview+objectdatasource+aspnetpager整合实例

gridview+objectdatasource+aspnetpager整合实例

热门标签:阿里云 团购网站 Mysql连接数设置 Linux服务器 电子围栏 科大讯飞语音识别系统 服务器配置 银行业务

前台代码:

复制代码 代码如下:

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;
             }
         }

您可能感兴趣的文章:
  • asp.net 使用ObjectDataSource控件在ASP.NET中实现Ajax真分页
  • 动态指定任意类型的ObjectDataSource对象的查询参数
  • ASP.NET中 ObjectDataSource控件的DataObjectTypeName属性
  • 在ASP.NET 2.0中操作数据之一:创建一个数据访问层
  • 在ASP.NET 2.0中操作数据之二:创建一个业务逻辑层
  • 在ASP.NET 2.0中操作数据之三:创建母版页和站点导航
  • 在ASP.NET 2.0中操作数据之四:使用ObjectDataSource展现数据
  • 在ASP.NET 2.0中操作数据之五:声明参数
  • 在ASP.NET 2.0中操作数据之六:编程设置ObjectDataSource的参数值

标签:衢州 大理 广元 衡水 江苏 蚌埠 萍乡 枣庄

巨人网络通讯声明:本文标题《gridview+objectdatasource+aspnetpager整合实例》,本文关键词  ;如发现本文内容存在版权问题,烦请提供相关信息告之我们,我们将及时沟通与处理。本站内容系统采集于网络,涉及言论、版权与本站无关。
  • 相关文章
  • 收缩
    • 微信客服
    • 微信二维码
    • 电话咨询

    • 400-1100-266