Update database with a dataset?

[Q. John Chen]

All,

I am using VS2005.

I have a dataset MyDataSet with several DataTableAdapte rs defined (say
CompanyDataTabl e, DepartmentDataT able)
After I modified the data in the data tables of the dataset, I want
to put the change back to the database. So, I am doing the following:
MyDataSetTableA dapters.Company TableAdapter adapter = new ..
adapter.Update( myDataSet.Compa nyDataTable);

MyDataSetTableA dapters.Departm entTableAdapter adaperDept = new ..
adapterDept.Upd ate(myDataSet.D epartmentDataTa ble)

The above worked but I have quite a few tables. Is there a method that
I can do and update all at once instead one table at a time?

TIA,

John

[Usenet User]

On Thu, 24 Apr 2008 11:40:42 -0700 (PDT), "Q. John Chen"
<qj****@email.c omwrote:

>All,

I am using VS2005.

I have a dataset MyDataSet with several DataTableAdapte rs defined (say
CompanyDataTab le, DepartmentDataT able)
After I modified the data in the data tables of the dataset, I want
to put the change back to the database. So, I am doing the following:
MyDataSetTableA dapters.Company TableAdapter adapter = new ..
adapter.Update( myDataSet.Compa nyDataTable);

MyDataSetTableA dapters.Departm entTableAdapter adaperDept = new ..
adapterDept.Upd ate(myDataSet.D epartmentDataTa ble)

The above worked but I have quite a few tables. Is there a method that
I can do and update all at once instead one table at a time?

TIA,

John

Not really. Ultimately, updating each table will result in a separate
set of SQL UPDATE statements.

You may simplify your coding if you create a reusable method that will
look for updates in a dataset and update each table. For example:

public static void UpdateDataSet( DataSet data )
{
foreach( DataTable table in data.Tables )
{
// If table has changes, update the data in the DB
...
}
}