GridView 当对数据量比较大的时候,他的分页功能就显得力不从心了,
下面我给个sql语句的例子 来对GridView实现 重新分页:
select top "pageSize" * from (select ROW_NUMBER() OVER (order by "进行排序字段") as RowNum,* from "tableName") as "tableName" where RowNum > "pageSize"*"pageNUm-1"
pageSize:分页的大小
pageNUm:页码
tableName:表名