sql 语句分页查询

举例:  一次查询5条,从第0条开始

 

一次查询5条从第5条开始 

 由上面两条例子我们可以做一个简单的封装

/// <summary>
/// 根据分页查询
/// </summary>
/// <param name="pageSize">一页多少条</param>
/// <param name="pageNumber">当前第几页</param>
/// <returns></returns>
public DataSet GetLogList(int pageSize, int pageNumber)
{string sql = $"select top {pageSize} * from LoginLogs where LogId not in (select top {pageSize * (pageNumber-1)} LogId from LoginLogs)";//下面这个写法要报语法错误 @pagesize和@pagesize_pageNumber, 不知道什么原因,如果有大佬知道可以告诉我一声//string sql = "select top @pageSize * from LoginLogs where LogId not in (select top @pageSize_pageNumber LogId from LoginLogs)";//SqlParameter[] sp =//{//    new SqlParameter("@pageSize",(int)pageSize),//    new SqlParameter("@pageSize_pageNumber",(int)pageSize * (int)pageNumber)//};DataSet dt = SqlHelper.GetDataTable(sql);return dt;
}