Data Adapter's fill method does allow us to do paging where we can specify the number of records to fetch and stuff. However, it doesn't tell us how many records in total were affected by the Select Query ??? If we do not know total number of records we cannot get the PageCount/RecordCount .. any ideas ?