Paging on SqlCeResultSet

Hi

I am using SqlCeResult and i want to give paging on that and read in help that you can do paging on ResultSet so . I need code example so that i can understand how to implement this in resultSet.

Thanks & Regards

Vishal

Hi,

I need to implement paging on sqlceresultset. The resultset contains about 60000 records .I want to implement paging and bind it to the grid. I read that it can be done using sqlceresultset, but did not any example anywhere.

Can someone please suggest how to acoomplish this ?

Thanks

|||

There’s no need to “page” ResultSet. RS is a live cursor which loads data only as needed, not all data at once. If bound to DataGrid it would only load visible rows and loads others only as you scroll doing “paging” for you. So just bind your grid to the RS and you're done with "paging".