Datatable update and merge

[balupad14 (Balamurugan)]

Hi @30ab42842da83aef823e,
It may help you.

Join Two DataTables

Trevor Napier June 27, 2016 21:44 NONE So I know going through VB/C# you can use LINQ to join two tables IE Dim query = From tl1 In InputTableOne.AsEnumerable() _ Join tl2 In InputTableTwo.AsEnumerable() _ On tl1.Field(Of Integer)(“Customer_ID”) Equals _ tl2.Field(Of Integer)(“Customer_ID”) _ Select New With _ { _ .ID = tl1.Field(Of Integer)(“Customer_ID”), _ .Customer_Name = tl1.Field(Of String)(“Customer_Name”), _ .Order_ID = tl2.Field(Of Integer)(“Order_ID”), _ .Order_Item = tl2.…

Regards
Balamurugan.S