C# 分页 aspnetpager

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>