Compare two DTs and match each cell

[Madhavi (K)]

Please refer this,

Compare two datatables and get mismatched records

Try this, Get rows that exists in dtTable1 but not in dtTable2 dtDifference= dtTable1.AsEnumerable().Except(dtTable2.AsEnumerable, DataRowComparer.Default).CopyToDataTable Get rows that exists in dtTable2 but not in dtTable1 dtDifference= dtTable2.AsEnumerable().Except(dtTable1.AsEnumerable, DataRowComparer.Default).CopyToDataTable Hope this helps. Let me know if it doesn’t.

Comapring two data tables

@goharmalik Please follow below steps- Considering dtDatatable1 and dtDatatable2 as two datatables, Compare Data table rows, dtDatatable1.rows.count <> dtDatatable2.Rows.count If dtatables doesn’t contain matching rows, compare datatables (from dt1 in dtDatatable1.AsEnumerable() join dt2 in dtDatatable2.AsEnumerable() On dt1.Field(of Double)(“Column1”) Equals dt2.Field(of Double) (“Column2”) Select dt1) This will return you the array of datarows. If array has data, means there are matching …