Hi

Is there any property setting in Dataset or SQLAdapter to perform the same function as FetchAsNeeded in FoxPro Cursor?

FetchAsNeeded only apply to cursor view in FoxPro. Whenever FoxPro try to retrive a million records from MSSQL 2K server, by enabling FetchAsNeeded will only retrive the 1st 1000 recs. at any one time when the user scroll down or navigate to the 1001th record, it will fetch the second 1000 records.

This will improve performance dramatically... I hope ADO.Net have this functionality like in FoxPro.

Someone pls help

Thank you

Rgs
Sze Tatt
Penang
szetatt@yahorng.com.my