• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    gridview+objectdatasource+aspnetpager整合实例

    前台代码:

    复制代码 代码如下:

    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的参数值
    上一篇:DataGridView多维表头的实现方法
    下一篇:DataTable多列合并问题轻松搞定
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    gridview+objectdatasource+aspnetpager整合实例 gridview+objectdatasource+aspnetpager,