Multiple Database Datasets Help

[Robert Porter]

I have a case where I am creating a dataset from one database, then I want
to issue a series of updates to another database to update data based on a
common key between the two tables in two separate databases. eg

Database1.Table1

key column2 column3 ....
1232 My Prod 1234.00


Database2.Table1 (To be updated with data from the first table, key already
exists. No inserts allowed, just updates.

key column2 column3
1232 null null

So what is the best approach to this? Create 2 datasets, 1 dataset with a
datatable object from each connection, or just brute force update statements
to the second database while walking through the first dataset? I am
working in VB.NET 2003 and am not very familiar with C# so any examples in
VB.NET would be helpful.

 

[Cor]

Hi Robert,

I answered another question on you earlier which was later in this
newsgroup.

Answer again, just read one read the other and update while not using
datasets. this is batch.

Cor