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
Bug(?) - Cannot access datatable.AsEnumerable.Sum
dtUpg.AsEnumerable().Where(function(row) dtMaster.AsEnumerable().Select(function(r) r.Field(Of String)("Column0".ToString)).Any(function(x) x = row.Field(Of String)("Column1".ToString))).ToArray
How to split data and save in excel files
Fliter dt
How to build DataTable without using Build DataTable activity
How can I split "Start Time" column with space, and then filter date today and today-7
Check if Column Values equal current date
Bug(?) - Cannot access datatable.AsEnumerable.Sum
Filtering Excel using Select method
Computing then Copy and paste of total Regular Hours and total OT Hours of "Rest Day" Day Type
How to pick duplicate records based on column?
DataTable - Remove Duplicate Row
Filter/Select Non Duplicate Values
Get Bottom N records from datatable
I want to remove duplicate row values on the basis of RUN ID column form excel sheet
Take a specific excel cell based on variable
Remove Duplicate with condition
Filtering Datarows out of a Datatable using select function
How to get the data table data based on filter month wise
Read data from Excel strings and manipulate them according to a specified condition
Filter DataTable using Startswith and count distinct values
How DT.Selcet() convert to datatable
データテーブルでの複数キーでのソート
Help with Linq expression
Copy Specific Excel Data to Another Worksheet?
Separate Duplicate data
How to compare birthdate with today
Calculate sum, max, min for multiple columns in excel( Issue with studio)
Calculate sum,maxi and mini for the multiple columns in excel sheet?
LinQを使って列の中身を更新する方法について

Hi @lucas.mcgonagle

EDIT
20.10 fixed this issue for newly created project.

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.

68 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
Count the number of entries in the Excel sheet and save the number in a counter
Excel write to corresponding column of every cell
Remove unmatched rows
How to count duplicate strings in an array
Extract specific column data from excel file
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
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
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
Can't filter the date using the data wizard

That’s fixed it. Thanks very much!

1 Like