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
Unfortunately not - The good thing about ADO.NET is that you get an in memory represenation of a database which is disconnected from the source. The bad thing about ADO.NET is that you get an in memory represenation of a database which is disconnected from the source. <g>
The only way to get around this is to keep the connection with the source through a DataReader. You'd have to dynamically create your DataSet by reading the DataReader and continously add more records when the user reaches the end.
I'm trying to think of an easier way to get the same behavior as you would in VFP but I just don't see the possibility other than using a DataReader.