updating data collated in one DataTable back to multiple source DBs

[Jon the Blind]

I've created an object that collates data from multiple calls from separate
databases. The primary key column is a string, the idea being that the most
recent calls' values will possibly overwrite values from prior calls to
other databases.

Now I'd like to edit those values and return them to their correct databases
of origin.

My plan (but I'm hoping I'm missing something more straightforward) is to
add a column and store the database name in there at Fill time, then match
the database of my update DataAdapter's SqlConnection and only update
matching rows.

If anyone has a better approach I'd love to save a little time on this.

Regards,

Jon

 

[William Ryan eMVP]

You may be able to use DataSet.Merge to get those values into each set
respectively. You can write your Update logic however you want and you have
a lot of flexibility there but you may be better off just looping through
the rows and building a SQL Statement based on the column values (which is
essentially what the dataadapters do).

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/