Compare two datatables and get mismatched records

[Madhavi (K)]

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.