More on DataSets

[normanordas]

1. Are there any considerations when to use untyped and typed datasets? I find typed-datasets more useful and less error prone in typo since you can call the members exactly by the name itself besides the fact that it adds some useful methods not present in its counterpart. 2. What condition should stop me from using typed-datasets? Are there limitations? 3. Does datasets supports concurrency..i.e. move the record pointer forward, backward, BOF and EOF? How about bookmarks?

[Mike Dimmick]

I'm not sure about #1 and #2, but about #3 I'm certain: a DataSet is a disconnected data store. It doesn't have any concept of the 'current record', there is no record pointer, and no persistent connection to the database is maintained. Until you use Fill a second time, the DataSet contains only the data you originally fetched and your local modifications. Any local modifications are only replicated back to the server when you call Update on an appropriate data adapter object. Stability. What an interesting concept. -- Chris Maunder