Hi I have a use case where i need to compare 2 data table and upda accordingly on the main datatable

[Ahmad_Rais (Ahmad)]

Hi its related to this topic where it compare 2 data table then if the data didnt found in the datatable 2 it will then add a new row and add the data in data table1.

How to Compare two data tables with specific Column data

Hi Team, Here i have two data tables DT_1 and DT_2, DT_1: [DT_1] DT_2: [DT_2] for each row in DT_2 “Phone Number” if this Phone Number is not present in DT_1 “phone” then i need to pick that data row from DT_2 and update in another excel which is DT_Final(Output). as shown below DT_Final: [DT_Final] Please suggest any solution through LINQ Thanks and regards, Sai Adarsh.

but the new thing is if it found any matching Phone Number and some of the column value is diffrent i want to update the rows in data table 1 according to the values of data in column 2, but keep in mind not all column will be updated