I want to compare two datatables, get the mismatched records using LINQ query. Please help me
Check this post: How to see which item is different when comparing two datatables - #5 by juan.lengyel
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.
1 Like
one data table
@qbss Query Provided by @Madhavi Should Work, if it doesn’t then you need to provide more information
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.