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.

13 Likes
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
Bug(?) - Cannot access datatable.AsEnumerable.Sum
How to split data and save in excel files
Fliter dt
How to build DataTable without using Build DataTable activity
Calculate sum, max, min for multiple columns in excel( Issue with studio)
Read data from Excel strings and manipulate them according to a specified condition
Help with Linq expression
How to compare birthdate with today
Copy Specific Excel Data to Another Worksheet?
Separate Duplicate data
How to get the data table data based on filter month wise
データテーブルでの複数キーでのソート
How DT.Selcet() convert to datatable
Filter DataTable using Startswith and count distinct values
Filtering Datarows out of a Datatable using select function
Change date format in column
How to skip the first row of a foreach loop in C#?
'CopyToDataTable' は 'System.Array' のメンバーではありません。とエラーになります。
How can add the Data Scarping Row Values
I want to remove duplicate row values on the basis of RUN ID column form excel sheet
Get Bottom N records from datatable
Remove Duplicate with condition
How to pick duplicate records based on column?
Filter/Select Non Duplicate Values
DataTable - Remove Duplicate Row
Take a specific excel cell based on variable
Computing then Copy and paste of total Regular Hours and total OT Hours of "Rest Day" Day Type
How to fix 'AsEnumerable' is not a member of 'System.Data.DataRow' in UiPath?
Filtering Excel using Select method
Bug(?) - Cannot access datatable.AsEnumerable.Sum
Check if Column Values equal current date
How can I split "Start Time" column with space, and then filter date today and today-7
LinQを使って列の中身を更新する方法について
Calculate sum,maxi and mini for the multiple columns in excel sheet?

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.

90 Likes
AsEnumerable is not a memeber of System.Data.DataTable
'CopyToDatatable' is not a member of 'System.Array'
How to convert a System.Data.DataRow[] in a datatable
AsEnumerable Error
How can I calculate a total (Sum) over a DataTable created by a "Read Range" Activity?
Copy to Datatable is not a member of System.Array
Error using CopyToDataTable Method
Comparing two excels and adding up the value of column
UiPath Studio missing namespace
Changing reference to [Microsoft.Office.Interop.Excel.dll]
Using the System.DirectoryServices namespace and Invoke Code activity
Unable to add system.directoryservices namespace in studio
Import DocumentFormat.OpenXml.Packaging namespace
Fliter dt
AutoHotKey script activity: pass variable to rest of UiPath workflow
How to do sum of column(Total profit) by Region in excel file
Copytodatatable is not a member of system array
How to get the values of a data column to a string
How to filter excel based on list of keywords in a particular column
Considering some rows of a data table
Invoke vb.net code with object class ManagementObjectSearcher
How can join two datatable and find a row according to a condition like using SQL statement query?
Writing even numbers to excel file which are read from data table
How to apply Vlookup in two different Excel files for more than 5 columns by considering one column in one excel?
Cannot use list element's property!
Read header and last updated row from excel using workbook
LINQ Query for selecting
Datatable filter string manipulation
Assign fault
Excel opreation
Certification Add Reference (DataRow[] to DataTable)
Error: "AsEnumerable" not part of "System.Data.DataTable"
How to convert string array to datetime array?
Whats the workaround, long term fix
Filter Datatable is not working
CopyToDatatable option is not coming
Filter Data Table Activity - Webdata Scrapping
Create a table with column headers and their respective filled rate
How to extract last row value from datatable
Extract specific column data from excel file
DataTable help - Getting the highest sum of results in a column
Eliminating duplicate rows by comparing values in different cells
Cleaning up the data table
Filtering Data based on value in double format doesn't filter at all
Error in PowerPoint Invoke Code
Copy of exact code not working in new xaml
Compile Error: "AsEnumerable" is not a member of "System.Data.DataTable"
Can't filter the date using the data wizard
Datatable filter copy
Remove unmatched rows
Do until customer name change on Excel
Excel write to corresponding column of every cell
How to count duplicate strings in an array
How to read each 20 rows with condition and create new sheet
How to get matching entries among two datatable's
Excel Data Extraction based on a specific word
How to get data from datatable according to the content
Sending an email using information from an Excel file
データテーブル同士の比較でエラーが表示される
Collate excel survey responses and average them
DataTable Comparision
Parallel For Each doesn't allow implicit conversion
Count the number of entries in the Excel sheet and save the number in a counter
How do I remove rows with dynamic dates
Erro - Order by "Descending" Data
How to write values in a DataTable for articles with same id
Nested 'For Each Row' Loop
Multiple lines summary Excel
Stings and LINQ
'AsEnunerable' is not a member of 'System.Data.DataTable'
Append data table is adding blank rows between the prior data set and the new data set
How to get values in excel
Return latest date from a duplicate row
Knowing if some values have a double in a specific column of datatable
Help to remove rows in datatable if they match value in a second datatable
Dt problem
CopyToDataTable is not a member of System.Data.Datatable
Delete column (error Copytodatable is not a member)
Where to add System.Data.DataSetExtensions as Project.json doesnt have any reference assembly
How to generate datatables equal invoice codes?
Datatable does not contain a defnition for 'AsEnumerable'
Filtrado excel
Getting error while trying to get distinct values from database table and covnert to Array
Linq Expression functions not showing up
Array Division / Split

That’s fixed it. Thanks very much!

1 Like