Remove Duplicates

Not a perfect solution, but if BDate is string this works.I concatenated columns to find duplicates.

dtDuplicates.AsEnumerable().GroupBy(Function(x) x.Field(Of String)(“Name”)+x.Field(Of String)(“BDate”)).Select(Function(y) y.First()).CopyToDataTable()

4 Likes