现在要用asp.net 2.0+Access 2003数据库完成分页功能。帖主要的代码。URL测试参数 /category.aspx?size=3&page=4&category=Career的时候，我希望查出来的是第4页的数据，但无论怎么更改page的参数，数据的显示都不正确，总是筛选出前面的几笔记录。请问高手这是怎么回事呢？
1、数据访问层PostADL.cs
C# code:
/// <summary>
/// 根据文章的类别及页码，分页显示文章信息
/// </summary>
/// <param name="pageSize">每页要显示的记录笔数</param>
/// <param name="pageIndex">当前所在的页面码</param>
/// <param name="category">文章的类别</param>
/// <returns></returns>
public List<Post> PostPager(int pageSize, int pageIndex, string category)
{
List<Post> lstPost = new List<Post>();
Post post = null;
string cmdText = "SELECT TOP " + pageSize + " A.post_id, A.post_title, A.post_content, A.post_time, A.user_id, A.post_from_name, A.post_from_url, A.post_approved, A.post_recommend, A.post_on_top, A.post_author, A.comment_lock, B.column_id, B.column_name, C.tag_id, C.tag_name, D.user_name from post_def A, column_def B, tag_def C, user_def D WHERE "
+ "A.post_id NOT IN (select top " + pageSize * pageIndex + " post_id from post_def) "
+ "AND A.column_id = B.column_id "
