CopyToDataTable is not a member of System.Data.Datatable

[ppr (Peter Preuss)]

Lets do it one by one

dt_ExtractedData.DefaultView.ToTable(True, Description, Amount) 

will conflict with the syntax as an array with the colnames is needed. It already returns a datatable and thats why copytodatatable is causing the issue. But it will return only the two columns, configured in the colname array

@kumar.varun2

dt_ExtractedData.DefaultView.ToTable(True, {"Description", "Amount"})

@hurmet.noka

I want to DELETE Duplicate rows based on TWO columns, but i want to keep all other columns

here you can use the LINQ provided by @kumar.varun2 or following variation

(from d in dt_ExtractedData.AsEnumerable
Group d by k1=d(“Description”).toString.Trim, k2=d(“Amount”).toString.Trim into grp=Group
Select r=grp.First()).CopyToDataTable

it will distinct the group members by taking the first group member.

For other scenarios e.g. fetch all unique groups we would filter with where grp.Count = 1

Ensure following:

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.