Alex Rivera | Logout

How can I remove duplicate entries from a data table

Asked 2010-12-11T06:26:15.033
47

How can I remove duplicate entries from a DataTable?

Edit
Report

1 Answer

10

Heres a easy and fast way using AsEnumerable().Distinct()

private DataTable RemoveDuplicatesRecords(DataTable dt)
{
    //Returns just 5 unique rows
    var UniqueRows = dt.AsEnumerable().Distinct(DataRowComparer.Default);
    DataTable dt2 = UniqueRows.CopyToDataTable();
    return dt2;
}
answered 2013-03-07T06:33:35.493

Your Answer