How to Retrieve mismatching data from two datatable

How to Retrieve mismatching data from two datatable. Output should be same as in the attached photo

Mismatching table should have 3,4,5,6 in one column and C,D,E,F in another

Screenshot 2023-09-04 044052


How about the following expression?

dtResult = dta.AsEnumerable.Except(dtB.AsEnumerable,DataRowComparer.Default).Union(dtB.AsEnumerable.Except(dtA.AsEnumerable,DataRowComparer.Default)).CopyToDataTable (2.8 KB)


1 Like

Resolved thanks a lot for the help @Yoichi

1 Like

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