62,271
社区成员
发帖
与我相关
我的任务
分享
<configuration>
<appSettings>
<add key="DataBaseType" value="1"/>
<add key="PagerSQLKey" value="28526830"/>
</appSettings>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.;Initial Catalog=Nature_Demo;persist security info=False;user id=sa;pwd=admin;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<pages>
<!--注册自定义控件-->
<controls>
<add assembly="Nature.WebControls" namespace="Nature.WebControls" tagPrefix="Nature"/>
</controls>
</pages>
<!--其他代码省略-->
</system.web>
</configuration>
public partial class _Default : System.Web.UI.Page
{
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
//数据访问函数库的实例
DataAccessLibrary dal = DALFactory.CreateDAL();
this.PagerTest .DAL = dal;
//定义QuickPager_SQL,设置Page属性
PagerTest.PagerSQL.Page = this;
//设置显示数据的控件
PagerTest.ShowDataControl = this.rpt_Test;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SetPagerInfo(); //设置表名、字段名等
}
}
#region 给QuickPager_SQL 设置属性,以便拼接SQL
private void SetPagerInfo()
{
PagerTest.PagerSQL.TableName = "News_Info"; //表名或者视图名称
PagerTest.PagerSQL.TableShowColumns = "*"; //需要显示的字段
PagerTest.PagerSQL.TablePKColumn = "NewsID"; //主键名称,不支持复合主键
PagerTest.PagerSQL.TableOrderByColumns = "NewsID desc "; //排序字段,根据分页算法而定,可以支持多个排序字段
PagerTest.PagerSQL.TableQuery = ""; //查询条件
PagerTest.PageSize = 4; //一页显示的记录数
PagerTest.NaviCount = 3;
//设置分页方式
PagerTest.PagerSQL.SetPagerSQLKind = PagerSQLKind.Max_TopTop;
PagerTest.PageIndex = 2;
}
#endregion
}
<form id="form1" runat="server">
<div>
<asp:Repeater ID="rpt_Test" runat="server">
<ItemTemplate>
<p><%#Eval("NewsTitle") %></p>
</ItemTemplate>
</asp:Repeater>
<Nature:QuickPager ID="PagerTest" runat="server" />
</div>
</form>