ADO.NET adapter save DataSet - multiple tables changes

[DG]

I have a dataset with two tables, and i modified rows in both.
Can i use adapter to update both tables in one command.
Also i'd like to do that with transaction (all or none changes apply)

Is it possible to use VS generated adapters for this purpose?
Thanx.

(SqlServer 2000 is DB)

 

[Cor Ligthert [MVP]]

DG,

You can the result is however only more work, there is not any advantage
using one dataadpater instead of one.

You cannot update more tables in one command, (or maybe it is possible if
you are a real great SQL expert and want to do it again with more work).

I hope this helps,

Cor

 

[jmbledsoe]

I helped build a tool called the DataSet Toolkit that allows this. It
has a class called the MultiTableDataAdapter which (as the name
suggests) allows you to update multiple tables in one
DataAdapter.Update() operation. Check it out:

http://www.hydrussoftware.com

John B.
http://johnsbraindump.blogspot.com