Delete duplicate records from Datatable

Permanently deleted user

October 22, 2014 04:35

Is there any simple way to delete duplicates from a data table (just a single column) ?  I've tried various assignments using Distinct as well as scripting C# - was hoping this would work

 

 dtUniqRecords = dt.DefaultView.ToTable(true);  Or  dt = dt.DefaultView.ToTable(true);

But it still returns the duplicates.

 

I know there's lengthy ways to do this in WF but I was hoping for something short and sweet...

 

Thanks,

James

0

• 

  Permanently deleted user

  October 24, 2014 01:03

  Great - thanks!

  0

Please sign in to leave a comment.