I have dt1, dt2 DataTables. I have merged them to dt1 by using dt1.Merge(dt2)
But there are multiple duplicate rows and I don't have primarykey for those rows, how to eliminate duplicate records?
Asked
Active
Viewed 1,890 times
0
-
Are they 100% identical or just mostly identical? – Ann L. Aug 01 '16 at 17:51
-
This Q+A will show you a method: http://stackoverflow.com/questions/3242892/select-distinct-rows-from-datatable-in-linq – Ann L. Aug 01 '16 at 18:02
-
If you haven't unique value in the row, then you will need to compare between all columns and based on the result remove duplicates – Fabio Aug 01 '16 at 18:19