Well, as I said, it depends on how you plan to update your data. We use Stored Procs for everything and so we don't use the DataAdapter.Update() method, but instead send a bunch of parameters to a Stored Proc and use the SqlCommand.ExecuteNonQuery().

How have you structured your DataAccess layer? Do you plan to use the DataAdapter.Update() method for updating your backend data?

~~Bonnie



>Bonnie,
>
>From your explanation I take it that it would be more work and prone to more errors using a single DataAdaptor. I like to keep things simple... especially the debugging process! So I guess I'll just have to make do with individual DataAdaptors instead.
>
>Thanx! a lot 8 )
>
>Martin