C# 分页 aspnetpager

来源：互联网发布：如何提升淘宝店铺销量编辑：程序博客网时间：2024/06/05 15:29

http://www.webdiyer.com/aspnetpager/

下载安装包，解压后将AspNetPagerCN-7.5.1\Demo\Bin拷贝到根目录

AspNetPagerCN-7.5.1\Demo\App_Code 拷贝到对应目录

AspNetPagerCN-7.5.1\Demo\App_Data 拷贝到对应目录

将原来AspNetPagerCN-7.5.1\Demo\Web.Config拷贝到

  <pages validateRequest="false"  >    <controls>      <add tagPrefix="webdiyer" namespace="Wuqi.Webdiyer" assembly="AspNetPager" />    </controls>  </pages>

网站web.config中.

修改App_Code\SqlHelper.cs

    public static readonly string CONN_STRING = ConfigurationManager.ConnectionStrings["SQLConStr"].ConnectionString;//    public static readonly string CONN_STRING = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;

实际应用enap\list.aspx.cs可修改

    void bindData()    {        Repeater1.DataSource = SqlHelper.ExecuteReader(CommandType.StoredProcedure, ConfigurationManager.AppSettings["pagedSPName"],            new SqlParameter("@startIndex", AspNetPager1.StartRecordIndex),            new SqlParameter("@endIndex", AspNetPager1.EndRecordIndex));        Repeater1.DataBind();    }

此函数的存储过程为自定义的存储过程，默认的是在AspNetPagerCN-7.5.1\Demo\Web.Config定义的

  <appSettings><!--    <add key="pagedSPName" value="P_GetPagedOrders2005" />-->  </appSettings>

阅读全文

0 0