Filter DataTable using C# Linq

Help Studio
,
1

Dear All,

I am not able to filter DataTable using C# Linq.

DT:
image

Linq Query: dt_Users.AsEnumerable().Where(row => row.Field(“Salary”).Contains(“USD”)).CopyToDataTable()

Error in Studio:

image
image784×196 10.4 KB

2

Hi,

For now, can you try to save the project, close Studio and reopen the project? Automatic recovery feature might run.

Regards,

3

I have also created new project for test and have tried to do the same. Still the same error.

Br,
NikZ

4

@Nikhil_Zambare1,

  1. Close the Studio
  2. Take a backup of your projects project.json file
  3. Delete the project.json from project
  4. Open the project by double clicking on Main.xaml from File Explorer.
  5. UiPath Studio should rebuild the project.json will all require packages restored.
  6. Recheck the code.

Thanks,
Ashok :slight_smile:

5

Dear Ashok,

Thanx for your time.
I have tried as you directed. The issue is still there.

Br,
NikZ

6

@Nikhil_Zambare1,

What’s the source of the datatable is it from Read Range or Build Datatable?

7

Dear Ashok,

I am using excel read range activity.
I also have imported system.linq namespace.

8

@Nikhil_Zambare1,

Try importing System.Xml.ReaderWriter Or System.Xml

9

@Nikhil_Zambare1

Also try this.

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.