62,046
社区成员
发帖
与我相关
我的任务
分享
for (int i = 0; i < PageCount; i++)
{
HyperLink h=new HyperLink();
Literal l = new Literal();
int n = i + 1;
h.Text = n.ToString();
h.ID=n.ToString();
h.NavigateUrl = "list.aspx?pageindex=" + i.ToString();
l.Text =" ";
PH.Controls.Add(h);
PH.Controls.Add(l);
}
这是最简单的分页,把所有页码都列出来的,这是给你一个思路,其他的逻辑自己往进加吧
public DataSet GetDataByPage(int pageIndex)
{
pageIndex = 2;
int dataMin = (pageIndex - 1) * PAGE_SIZE+1;
int dataMax = pageIndex * PAGE_SIZE;
StringBuilder sqlSb = new StringBuilder();
sqlSb.Append("SELECT * FROM ( ");
sqlSb.Append("SELECT *,ROW_NUMBER() over(order by id) rownumber ");
sqlSb.Append("FROM tableName ) bb ");
sqlSb.Append($"WHERE bb.rownumber between {dataMin} and {dataMax}");
//return sqlHelper.query(sqlSb.ToString()) 执行sql 返回数据 再将返回的数据重新绑定Repeater
}