Helen,
You have to create one dataset, with two connections, two datatadapters and
two fills.
You can do that using the designer.
In code it is roughly typed
\\\
dim ds as new dataset
dim conn1 as new sqlconnection(connectionstring1)
dim conn2 as new sqlconnection(connectionstring2)
dim da1 as new sqldataadapter(sqlstring,conn1)
dim da2 as new sqldataadapter(sqlstring,conn2)
da1.fill(ds)
da2.fill(ds)
///
That is all without a try block. (The dataadapter takes care of the open and
close itself).
I hope this helps,
Cor
