CopyToDatatable is not part of Member of System.Data.EnumerableRow

[sayali_gujarathi1 (sayali gujarathi)]

I am,getting below error while writing linQ query.

“CopyToDatatable is not part of Member of System.Data.EnumerableRow”

Assembly reference is already present in xaml file.

Can anyone help?

[mkankatala (Mahesh Kankatala)]

Hi @sayali_gujarathi1

When you are writing the linq querey and storing in a variable. Make sure to be variable datatype in datatable datatype.

Hope it helps!!

[postwick (Paul)]

Why not just use the Add Data Row activity?

[sayali_gujarathi1 (sayali gujarathi)]

Hi @mkankatala , Variable is datatable only.
Please find thr image

[arjunshenoy]

Hi @sayali_gujarathi1

Right-click on this xaml (or Main xaml) and open it using Notepad. You will see a lot of code, into which you need to add the following line:

<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>

Do it here:

Hope this helps,
Best Regards.

[sayali_gujarathi1 (sayali gujarathi)]

Hi @arjunshenoy .

Thus,reference is already present.

[ppr (Peter)]

Select(Function (x)… will select the column values but not the rows, so we cannot apply copytodatatable

Maybe you want to do:

dtSmall = dtOrig.DefaultView.ToTable(false, {"Europe"})

[sayali_gujarathi1 (sayali gujarathi)]

Hi @ppr ,

I want to read the all values from column name “Europe” as I put in the query as well.

[ppr (Peter)]

@sayali_gujarathi1

ead the all values from column name “Europe” as I put in the query as well.

we answered with
dtSmall = dtOrig.DefaultView.ToTable(false, {"Europe"})

[sayali_gujarathi1 (sayali gujarathi)]

@ppr

Thanks. It worked.

[ppr (Peter)]

Perfect
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum