access 分页查询

Int32 _Count = RecordCount - NoRecordCount;
 if (_Count > _RecordCount)
 {
      _Count = _RecordCount;
 }

OleDbDataAdapter OledbComm1 = new OleDbDataAdapter("select * from (select top " + _Count + " * from (select top " + (NoRecordCount + _RecordCount) + " * from CS_Article_Master order by A_SN)  order by A_SN desc) order by A_SN", _Mycon);//排序以第一个排序和第三个排序为准，第二个排序是与之相反