Hi Martin,
It all depends on how you plan to do the updates later ... if you want to use the CommandBuilder and/or you want to use the DataAdapter.Update() method, then you'd be better off using a separate DataAdapter for each table. Although I guess you could use the same DataAdapter and rebuild your Select/Insert/Delete commands each time you switch to a different table if you really need to do it that way.
If you're not using the CommandBuilder or the DataAdapter.Update() method, then it doesn't matter at all.
~~Bonnie
>Hi all!
>
>I'm finally attempting to move to ADO.NET from ADO 2.6. Some getting use to required on my part.
>
>Anyway, my question is "Is it possible to update (Insert, Update, Delete) multiple tables using a single Data Adaptor object? I know I can create a single dataset to hold multiple (even unrelated) tables. But I use one adaptor for each table in the data set. Is this alright? Or is there a more sane way of doing this?
>
>Thanx! in advance 8 )
>
>Martin