一个通用的分页方法:
Select Top 5 * From xxxTable where ID NOT IN (Select Top ((当前页数-1)*5) * From xxxTable order by ID) order by ID
至于说"当前页数"可以通过Select count(*) From xxxTable / 5,结果如果是小数,那么进位(比如5.5取6),否则直接取整数(5.0取5)。
可以通过Timer方式每隔5秒(Interval设置5000)等方式后台线程完成此任务。ID是主键
For Account Validation, please follow "Verify Account+Number" at http://social.msdn.microsoft.com/Forums/en-us/home?forum=reportabug
For ASP.NET Question, please ask at http://forums.asp.net
For other questions, you can find a specific forum and then ask at http://stackexchange.com/sites
Click and Donate at http://www.freerice.com