asp.net2.0分页代码

"select Top pageCount * from table where id not in (select top pageCount * CurrentpageID id from table where" + sWhere + " order by id asc) and" + sWhere;
sWhere:

http://community.csdn.net/Expert/topicview.asp?id=5738401

分页基本上三种：一种利用sql语句分页。
                               还有一种用DataAdapter对象的Fill方法。
                               还有一种利用PagedDataSource