Compare two datables each row of one data table with each row of another data table

Help Studio
, , , , ,
1

Hello,
I have a scenario like I need compare two datables ex dt1 and dt2 like the first row of dt1 should be compared with all the rows present in Dt2 in the row of dt1 is not matching with any rows of dt2 I need to write that row into Excel. Can some one suggest me the best ways to do it.
Preferably using linq

2

hey @sanjay_gowda can u try the below linq and check

dt_output=dt_1.AsEnumerable.except(dt_2.AsEnumerable,system.Data.DataRowComparer.default).CopyToDataTable

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.