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

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated.

Thank you.

3 Likes

Hi @lucas.mcgonagle

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.

43 Likes
AsEnumerable is not a memeber of System.Data.DataTable
How to convert a System.Data.DataRow[] in a datatable
'CopyToDatatable' is not a member of 'System.Array'
How can I calculate a total (Sum) over a DataTable created by a "Read Range" Activity?
AsEnumerable Error
Error using CopyToDataTable Method
Copy to Datatable is not a member of System.Array
DataTable help - Getting the highest sum of results in a column
Eliminating duplicate rows by comparing values in different cells
Filter Data Table Activity - Webdata Scrapping
Filter Datatable is not working
Whats the workaround, long term fix
Can't filter the date using the data wizard
Compile Error: "AsEnumerable" is not a member of "System.Data.DataTable"
Array Division / Split
Copy of exact code not working in new xaml
Error in PowerPoint Invoke Code
Filtering Data based on value in double format doesn't filter at all
Cleaning up the data table
CopyToDatatable option is not coming
Error: "AsEnumerable" not part of "System.Data.DataTable"
Excel opreation
Certification Add Reference (DataRow[] to DataTable)
How to apply Vlookup in two different Excel files for more than 5 columns by considering one column in one excel?
Writing even numbers to excel file which are read from data table
How can join two datatable and find a row according to a condition like using SQL statement query?
Considering some rows of a data table
How to convert string array to datetime array?
Assign fault
Datatable filter string manipulation
LINQ Query for selecting
Read header and last updated row from excel using workbook
Cannot use list element's property!
Comparing two excels and adding up the value of column
How to get the values of a data column to a string
Invoke vb.net code with object class ManagementObjectSearcher
How to filter excel based on list of keywords in a particular column
UiPath Studio missing namespace
Import DocumentFormat.OpenXml.Packaging namespace
Unable to add system.directoryservices namespace in studio
Changing reference to [Microsoft.Office.Interop.Excel.dll]
AutoHotKey script activity: pass variable to rest of UiPath workflow
Fliter dt
Using the System.DirectoryServices namespace and Invoke Code activity
Copytodatatable is not a member of system array

That’s fixed it. Thanks very much!