用sql存储过程实现分页

来源:互联网 发布:企业名录大数据 编辑:程序博客网 时间:2024/05/21 18:34

首页,上,下,最后页用一个button,事件里面用存储过程,然后绑定; 

每一页的SQL语句:
(1)首页 :select top 20 from UserTable order by ID DESC;
(2)上一页:select * from (select top 20 from UserTable where ID<@ID order by ID DESC) order by ID ASC
(3)下一页:select * from UserTable where ID > @ID order by ID ASC;
(4)尾页:select * from (select top 20 from UserTable order by ID DESC) order by ID ASC

原创粉丝点击