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>