Non match records in datatables

[Bhagya_Shri]

How to find Non match records in two datatables

[Gvivek9889 (Vivek Gupta)]

@Bhagya_Shri

Please try this

Dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

Dt1.AsEnumerable().Where(Function(row) Not dt2.AsEnumerable().Where(function( r ) r(“Id”).ToString.Equals(row(“Id”).ToString)).Any).CopyToDataTable

Thanks

[Chirag_Shetty_Divakar (Chirag Shetty)]

@Bhagya_Shri
dtMatched = (From rowMain In dtMain.AsEnumerable
Join rowCommon In dtFirst.AsEnumerable
On rowMain(0).toString.Trim Equals rowCommon(0).toString.Trim
Select rowCommon).CopyToDataTable

dtUnMatched = (From rowOne In dtFirst.AsEnumerable
Where Not dtMatched.Tolist.Any(Function (r) r(0).toString.Trim.Equals(rowOne(0).toString.trim))
Select rowOne).CopyToDataTable

Also can go through this thread

How to compare and find not matching item in two data tables?

Hello. I have two data tables with only a column. Most of the row values are same in both data tables. But some values are only in one data table, and some values are only in other data table. I want to compare this two data tables and get mismatching row values. Here you can see an example of data tables: DT1 DT2 Title Register Number 67 21 16 34 34 11 21 23 45 45 11 2 23 87 How can I get this mismatching values?

Hope this helps
Cheers

[Bhagya_Shri]

@Gvivek9889 Thanks for quick response