简单实用的分页类(8)

 EXEC(@sql)
end
2 Select语句
select top " + pageSize + " * from Students where SID not in (select top " + (pageIndex - 1) * int.Parse(pageSize) + " SID from Students)
3 Select语句
select * from (select * ,Row_Number()over(order by id) RowNumber from books) t
where t.RowNumber>=11 and t.RowNumber<=20
第n页: (PageIndex-1)*pageSize+1,PageIndex*pageSize
4 ListView 提供的分页不说了


摘自 朱文锋