使用AspNetPager控件分页

页面后台写法

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack) { BindData();

}

}

protected void AspNetPager1_PageChanged(object sender, EventArgs e)

{

BindData();

}

public void BindData()

{

PageDataBaseOptater pdo = new PageDataBaseOptater();

AspNetPager1.RecordCount = pdo.GetRowCount("表名","where条件");

AspNetPager1.PageSize = pageSize;//pagesize可以设定

string cond = " where 条件";

DataSet ds = pdo.GetinfoList("表", AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, "记录的Id DESC", cond, "id名称"); Repeater1.DataSource = ds; Repeater1.DataBind();

}

dao层：

public class PageDataBaseOptater
{
/// <summary>
/// 获取记录数
/// </summary>
public int GetRowCount(string table,string where条件可以没有)
{
//获取表的记录总数

}
public DataSet GetinfoList(string table, int rowpage, int rowcount,
string orderFid, string Conditions,string colum_id)
{
//sqlserver2005的
//string query = "Select * From "
// + "(Select *,ROW_NUMBER() OVER(ORDER BY {2}) as RowNum From {4} {3}) as newTable "
// + "Where (RowNum BETWEEN ({0}) AND ({1}))";
//query = string.Format(query, (rowpage - 1) * rowcount , rowpage * rowcount, orderFid, Conditions, table);

string query = "Select top {0} * From {1} {2} and {3} not in(Select top {4} {3} From {1} {2} Order by {5}) Order by {5}";
query = string.Format(query, rowcount, table, Conditions, colum_id, (rowpage- 1) * rowcount, orderFid);
DataDao dao = new DataDao();
return dao.PageGetDataSet(query);
}
}

控件下载：http://download.youkuaiyun.com/detail/yysyangyangyangshan/3625510