Case1:In both datatable values are not matching then merge two datatable results into Datatable3. Datatable 1 Datatable2 ID Column2 ID Column2 1 Test1 3 Test3 2 Test2 4 Test4 Here we need to compare two datatble ID's then if both are not matching then we need to merge the results like below Datatable3 ID Column2 1 Test1 2 Test2 3 Test3 4 Test4
Case2: If any value is matching those record not inserted into datatable.The result like below Datatable3. Datatable 1 Datatable2 ID Column2 ID Column2 1 Test1 3 Test3 2 Test2 5 Test5 3 Test3 4 Test4 Datatable3 ID Column2 1 Test1 2 Test2 3 Test3 4 Test4 5 Test5
dataYouWant = a.Except(b).Union(b.Except(a))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)