How to fix 'AsEnumerable' is not a member of 'System.Data.DataRow' in UiPath?

[Kakooza-Allan-Klaus]

Hi Team,

It isn’t System.Data.DataTable because it was solution that was showing up when I checked with google.

strTotalSum = requiredRow.AsEnumerable.Sum(Function (x) Convert.ToDouble(x(“Net Volume”).ToString.Trim)).ToString()

Hope the info is clear enough.

Thank you

[rahulsharma]

add the namespace

system.data.datasetextensions

[Kakooza-Allan-Klaus]

How?
They aren’t giving me any options

[Kakooza-Allan-Klaus]

It is there already

[rahulsharma]

Then i assume that bug is not yet fixed

Below thread will give you the idea.

That was a known issue which was supposed to be fixed earlier this year.

AsEnumerable not appear - Added Namespace in Main.xaml

Hi @ppr Yes added separately in the xaml also but still it wont appear. Also i cannot click on any xaml file after download or from a folder as it will start reinstalling uipath…this is altogether separate issue…just want to inform i always click on open project to view xaml file as clicking on xaml reinstalls uipath… Thanks, Boopathi

datatable.AsEnumerable cannot be access

I was trying to use AsEnumerable to calculate the sum of the value of the whole row, this function is not accessible. I have tried to add the System.Data.DataSetExtensions, but that does not seems to be working

@loginerror @Pablito can comment on whether this was taken into consideration.

[Kakooza-Allan-Klaus]

Funny thing is I’ve two projects in one it is working and in the other it isn’t working

[Kakooza-Allan-Klaus]

They’re suggesting that I should uninstall studio and then reinstall it again
And that’s along process for because am not the admin of the machine I am using

[rahulsharma]

yes that confirms bug is still there

Thanks for highlighting.

Regarding troubleshoot, I know it’s weird but

Just delete that activity and add a new one ro check

just simply closing the file completely and then trying to open can also handle this issue.

Also we can check the json foe the namespace part doe two process (working one and this one with error) to verify that are identical

[Kakooza-Allan-Klaus]

The one that isn’t working has many namespaces compared to one that is working

[Charbel1 (Charbel)]

Why are you applying AsEnumerable on a datarow and not the datatable?

[Kakooza-Allan-Klaus]

Perfect @Charbel1
I wasn’t seeing that now it’s working super fine
No it makes a lot of sense that why google also didn’t know the answer

Thanks

[Charbel1 (Charbel)]

No need!

Have a great day.

[Srini84 (Srinivas)]

@Kakooza-Allan-Klaus

In the old version there is an issue, check below for your reference

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.

But this was rectified in new versions

Hope this may help you

Thanks

[rahulsharma]

we had a troubleshoot call and ee also confirmed on this topic, this issue is not yet resolved

Shiver weird solutions worked for us and along with that, you can also add that namespace in the Json. Just open the project.json in notepad and in the namespace section add the desired namespace