VB.NET update DataTable using ADO.NET
Posted on 2013-05-10
how is it possible to update one column of DataTable in memory with values from second DataTable using ADO.NET? Both data tables have one column identical (ID) and sources are different databases (servers)
I would like to update column Price from first DataTable to second DataTable. Both data tables are from different data sources, thats why I can't use SQL command. Or is it possible to use SQL for it?
I do not want to use LINQ in this case, although LINQ is newer technology.
I have Visual Basic 2010 and .NET Framework 4.0.