- 时间:2021-01-23 12:32 编辑: 来源: 阅读:
- 扫一扫,手机访问
摘要:asp.net Repeater之非常好的数据分页
分页控件源代码如下:
[url=javascript:]</ItemTemplate>
<FooterTemplate>
</ul>
</div>
</FooterTemplate>
</WebControl:RepeaterPages>
</body>
</html>
后台代码:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
namespace FrameWork.Web
{
public partial class Index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
protected void Bind()
{
string Sql = "select count(Sys_NewsList_ID) from Sys_NewsList";//查询Sql语句
#region 列表选项
#region 分页控件基本属性
RepeaterPages1.SqlString = Sql;//用于统计总记录数和进行数据分页的Sql语句
RepeaterPages1.LastPage = "< Prev";
RepeaterPages1.NextPage = "Next > ";
RepeaterPages1.PageBeforeHtml = "";
RepeaterPages1.PageLastHtml = "";
#region 构造Url参数
System.Text.StringBuilder StrBulider = new System.Text.StringBuilder();
StrBulider.Append("&a=");
#endregion
RepeaterPages1.Url = StrBulider.ToString();
#endregion
#region 数据绑定
RepeaterPages1.DataSource = RepeaterPages1.getObjectRecordCount(true, "PageView", "Sys_NewsList", "Sys_NewsList_ID", " Sys_NewsList_ID desc", " Sys_NewsList_ID is not null");
RepeaterPages1.DataBind();
#endregion
#endregion
}
}
}