[2005] Fill a dataset with 2 unrelated Tables.

[steve_rm]

Hello,

Just looking at your code, but could you not use just 1 adatper

i.e.

Dim da As New System.Data.SqlClient.SqlDataAdapter()
            Dim cmd As New System.Data.SqlClient.SqlCommand()
            Dim ds As DataSet
 
            cmd.CommandText = "Select * From Table1"
            cmd.CommandType = CommandType.Text
            da.SelectCommand = cmd
            da.Fill(ds, "Table1")
 
            cmd.CommandText = "Select * From Table2"
            cmd.CommandType = CommandType.Text
            da.SelectCommand = cmd
            da.Fill(ds, "Table2")

[jmcilhinney]

Hello,

Just looking at your code, but could you not use just 1 adatper

i.e.

Dim da As New System.Data.SqlClient.SqlDataAdapter()
            Dim cmd As New System.Data.SqlClient.SqlCommand()
            Dim ds As DataSet
 
            cmd.CommandText = "Select * From Table1"
            cmd.CommandType = CommandType.Text
            da.SelectCommand = cmd
            da.Fill(ds, "Table1")
 
            cmd.CommandText = "Select * From Table2"
            cmd.CommandType = CommandType.Text
            da.SelectCommand = cmd
            da.Fill(ds, "Table2")

You could but you wouldn't. If you are using DataAdapters then that would imply that you would need to Update the data too. If you didn't need to update the data then you should use a DataReader to load the data, in which case you could use the same Command with different CommandText each time.

[esweezey]

Didnt figure that. I am going to need to update both tables.
Tx