.net分页查询方法
将此代码复制到一个类中:
#region 分页查询
/// <summary>
/// 根基条件分页数据
/// </summary>
/// <param name="table">需要查询的表名称</param>
/// <param name="pageindex1">页下标</param>
/// <param name="pagesize">每页显示条数</param>
/// <param name="ziduan">查询的字段</param>
/// <param name="andstr">约束条件</param>
/// <param name="orderstr">排序条件(例如:Top Desc,TuiJian Desc,LastTime Desc)</param>
/// <returns></returns>
public static DataSet FenYe(string table,int pageindex1, int pagesize, string ziduan, string andstr,string orderstr)
{
int page = ((pageindex1 - 1) * pagesize) + 1;
StringBuilder sql = new StringBuilder();
sql.Append("select " + ziduan + " from (select ROW_NUMBER() over(order By T." + orderstr + ") as Row,T." + ziduan + " from "+table+" T where 1=1 " + andstr + " ) TT where TT.Row between " + page + " and " + pageindex1 * pagesize + " order By "+orderstr);
return SQLHelper.Query(sql.ToString());
}
#endregion
调用该方法,传入对应参数