Problems in datagrid paging

Hi all,
I have met some problems in implementing paging with datagrid control. From what i know to do paging we must use sqlDataAdapter and dataset but I am using microsoft access database instead of SQL server as a result i cant use SqlDataAdapter and dataset to retrieve data from microsoft access. Anyone knows whether there is a way to do paging connected with access?Can i have the source code to see how it works if there is a way to solve my problem. Thanx....

to do paging in a datagrid doesn't really matter where you get the data from, as long as you have data to use. In the datagrid properties just put allowpaging = true, set the pagesize and define an event for onpageindexchanged. In that event you need to update the page index and refresh the grid.

if you want to retrieve data from access try using an oledbdataadapter.