Finding duplicate items in a datatable

[Madhavi (K)]

Please refer

I want to remove duplicate rows from datatable by comparing single column

@qbss Lets consider your table as, dtTable First try getting all the duplicate rows, dtDuplicateTable = dtTable.AsEnumerable().GroupBy(Function(dr) dr.Field(Of String)(“Claim_No”)).Where(Function(g) g.Count() > 1).SelectMany(Function(g) g).ToList().CopyToDataTable Now compare the original table with duplicate table and exclude the duplicate rows from original table, dtFinalTable = dtTable.AsEnumerable().Except(dtDuplicateTable.AsEnumerable, DataRowComparer.Default).CopyToDataTable P…