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

No, you kinda have to "QueryAsNeeded" in that you only query for the LEAST amount of data [fields and rows] that you need at any one time.

BOb