[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")