举个简单的例子,如果要显示第20-30条记录,SQL语句可以这样写: select * from tablename where id in (select top 30 * from talbename order by id asc) order by id desc
sorry,写错了. select top 10 * from tablename where id in (select top 30 * from talbename order by id asc) order by id desc 即:升序选择前30条记录,然后从这30条记录中降序选择前十条记录.就是这个思路.
用四个按钮,首页,末页,上一页,下一页.
需要几个变量记录:每页可显示记录数,总记录数,当前页数,总页数.
通过代码维护按钮状态,用SQL语句控制DBGrid中显示的数据.
select * from tablename where id in (select top 30 * from talbename order by id asc) order by id desc
select top 10 * from tablename where id in (select top 30 * from talbename order by id asc) order by id desc
即:升序选择前30条记录,然后从这30条记录中降序选择前十条记录.就是这个思路.