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.

7 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.

59 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'
AsEnumerable Error
How can I calculate a total (Sum) over a DataTable created by a "Read Range" Activity?
Error using CopyToDataTable Method
Copy to Datatable is not a member of System.Array
How to extract last row value from datatable
Nested 'For Each Row' Loop
How to write values in a DataTable for articles with same id
Erro - Order by "Descending" Data
How do I remove rows with dynamic dates
How to get values in excel
Parallel For Each doesn't allow implicit conversion
DataTable Comparision
Collate excel survey responses and average them
データテーブル同士の比較でエラーが表示される
Sending an email using information from an Excel file
How to get data from datatable according to the content
Excel Data Extraction based on a specific word
How to get matching entries among two datatable's
How to read each 20 rows with condition and create new sheet
Do until customer name change on Excel
Datatable filter copy
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
Invoke vb.net code with object class ManagementObjectSearcher
How to filter excel based on list of keywords in a particular column
Copytodatatable is not a member of system array
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
How to get the values of a data column to a string

That’s fixed it. Thanks very much!

1 Like