Filling Two Tables In A Dataset

[TedN]

I've created two query strings to get data from various tables in a database.

 

I would like to fill two table tables in a dataset with the data from each query string, e.g.

 

sqlStr1 data into dsTable1

sqlStr2 data into dsTable2.

 

 

I've tried the following and many other combinations but none seem to work.

con.Open
cmd.CommandText = sqlStr1
da.Fill(ds, "dsTable1")

cmd.CommandText = sqlStr2
da.Fill(ds, "dsTable2")
con.Close

 

I don't need any interoperability between the two tables. I'm placing the data in separate tables simply for the sake of clarity.

 

I would also prefer not to combine the two query strings.

 

 

Thanks,

Ted

Edited March 16, 2007 by TedN

[TedN]

OK. Found the answer. Use two DataAdapters.