2023年6月21日发(作者：)
SQL语句分页查询数据分页查询详情：分页查询SQL语句select top (@limit) * from (select row_number() over(order by FId desc) as rownumber,* from T_Products ) temp_row whererownumber>@offset
@limit：条数@offset ：最⼩条数order by FId desc：数据根据FId倒序T_Products：表格名称分页查询通常配合计算sql计算总条数语句（select COUNT(1) from T_Products）使⽤
实例： /// /// 前台分页查询产品数据 /// /// 条数 /// 最⼩条数 /// 返回总条数 /// public DataTable GetQueryList(int limit, int offset, string Type, out int total){ //使⽤sql语句分页查询数据 string sql = "select top (@limit) * from (select row_number() over(order by FId desc) as rownumber,* from T_Products ) temp_row where rownumber>@offset "; //计算数据总条数 string totalsql = "select COUNT(1) from T_Products "; total = 32(eScalar(r, totalsql)); //使⽤键值对 对sql语句⾥的占位建进⾏替换 SqlParameter[] para = new SqlParameter[] { new SqlParameter("@limit",), new SqlParameter("@offset",),
}; para[0].Value = limit; para[1].Value = offset; //返回⼀个Table return eDataTable(r, sql, para);}
2023年6月21日发(作者：)
SQL语句分页查询数据分页查询详情：分页查询SQL语句select top (@limit) * from (select row_number() over(order by FId desc) as rownumber,* from T_Products ) temp_row whererownumber>@offset
@limit：条数@offset ：最⼩条数order by FId desc：数据根据FId倒序T_Products：表格名称分页查询通常配合计算sql计算总条数语句（select COUNT(1) from T_Products）使⽤
实例： /// /// 前台分页查询产品数据 /// /// 条数 /// 最⼩条数 /// 返回总条数 /// public DataTable GetQueryList(int limit, int offset, string Type, out int total){ //使⽤sql语句分页查询数据 string sql = "select top (@limit) * from (select row_number() over(order by FId desc) as rownumber,* from T_Products ) temp_row where rownumber>@offset "; //计算数据总条数 string totalsql = "select COUNT(1) from T_Products "; total = 32(eScalar(r, totalsql)); //使⽤键值对 对sql语句⾥的占位建进⾏替换 SqlParameter[] para = new SqlParameter[] { new SqlParameter("@limit",), new SqlParameter("@offset",),
}; para[0].Value = limit; para[1].Value = offset; //返回⼀个Table return eDataTable(r, sql, para);}
发布评论