Adding & updating multiple tables in a dataset

[ghall426]

I want to have a dataset consisting of 3 tables. I originally did it with a single SELECT statement:

myDataAdapter = New SQLDataAdapter("SELECT * FROM Table1; SELECT * FROM Table2; SELECT * FROM Table3", myConnection)

But found (from experience and other sites) that the update command won't work for tables added like this. Instead, I needed to change my code to:

myDataAdapter1 = New SqlDataAdapter("SELECT * FROM Table1", myCon)
myDataAdapter2 = New SqlDataAdapter("SELECT * FROM Table2", myCon)
myDataAdapter3 = New SqlDataAdapter("SELECT * FROM Table3", myCon)

and issue 3 separate FILL statements to properly fill the dataset with the 3 tables.

I also found that I need to use the command builder:

myCommandBuilder = New SqlCommandBuilder(myDataAdapter1)
myCommandBuilder = New SqlCommandBuilder(myDataAdapter2)
myCommandBuilder = New SqlCommandBuilder(myDataAdapter3)

to get the update to work properly.

I use the following code, for example, to update Table 3:

myDataAdapter3.Update(myDS, "Table3")

So my question is, if I have to deal with 3 separate data adapters, why not just create 3 separate tables? What's the benefit of having all 3 tables in a single dataset of the separate adapters need to be used anyway?

Greg