AspNetPager分页控件用法
哪位高手帮帮我AspNetPager用在DataList上怎么用,谢谢了。 --------------------编程问答-------------------- http://www.webdiyer.com/controls/aspnetpager有详细的帮助和示例项目 --------------------编程问答-------------------- 先在类里写两函数,代码如下public DataSet getPage(string SQLQuery, int currentpage, int pagesize, out int recordcount)
{
SqlDataAdapter da = new SqlDataAdapter(SQLQuery,conn);
DataSet ds = new DataSet();
int startrow = (currentpage - 1) * pagesize;
da.Fill(ds, startrow, pagesize, "table");
recordcount = getPagecount(SQLQuery);
return ds;
}
//返回总记录数
public int getPagecount(string SQLQuery)
{
SQLQuery = System.Text.RegularExpressions.Regex.Replace(SQLQuery, "ORDER BY.*", "");
SQLQuery = string.Format("select count(*) from ("+SQLQuery+") as temp");
SqlCommand cmd = new SqlCommand(SQLQuery,conn);
int recordcount = (int)cmd.ExecuteScalar();
return recordcount;
}
然后在工具箱中加入AspNetPager.dll,然后拖到DATALIST下面
在绑定DATALIST函数中调用上面的类
代码,如:
public void lynewsbind()
{
int recordcount;
string sql = string.Format("select * from news ");
DBConn conn = new DBConn();
DataSet ds = conn.getPage(sql,AspNetPager1.CurrentPageIndex,AspNetPager1.PageSize,out recordcount);
AspNetPager1.RecordCount = recordcount;
lydtl.DataSource = ds;
lydtl.DataBind();
}
然后在AspNetPager1_PageChanged中调用绑定代码
如:
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
lynewsbind();
}
就行了 --------------------编程问答-------------------- 作者已经给了说明的链接了,#1的就是 --------------------编程问答-------------------- 每次有aspnetpager的问题1楼必出来,佩服 --------------------编程问答-------------------- 真是的,顶一下 --------------------编程问答-------------------- 那如果是多种条件查询的, 数据源的查询条件是不一样的 该怎么做? --------------------编程问答--------------------
学习学习
补充:.NET技术 , ASP.NET