Updating data source

[Jhd.Honza]

Hi,
I have a small database, expecting no more than five tables with few rows. I would like to get all these data to DataSet, modify it and save back into the database. Do I have to create new DataAdapter for each table?

I don't think this is the right solution...

myTable1Adapter.Fill(myDataSet);
myTable2Adapter.Fill(myDataSet);
myTable3Adapter.Fill(myDataSet);

// do some changes

myTable1Adapter.Update(myDataSet);
myTable2Adapter.Update(myDataSet);
myTable3Adapter.Update(myDataSet);