Originally posted by CyberHawke
Well actually, it's very flexible, but as with any object, in order to use it you need to maintain an in-memory reference to that object, this is true of any programming language.

Now I have a question, if your data adapter is gone from memory, where is your data that your users still have access to it?
Data is in DataSet or DataTable which has been returned to UI layer .. dataAdapter is disposed once the data has been returned. I do not see it very flexible this way ... why do I have to maintain a freakin dataAdapter ??? My dataset or dataTable should be intelligent enough to do updates on there own ... just like VB6 recordSets ..