Filter DataTable using C# Linq

[Nikhil_Zambare1 (Nikhil Zambare)]

Dear All,

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

DT:

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

Error in Studio:

[Yoichi]

Hi,

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

Regards,

[Nikhil_Zambare1 (Nikhil Zambare)]

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

Br,
NikZ

[ashokkarale]

@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

[Nikhil_Zambare1 (Nikhil Zambare)]

Dear Ashok,

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

Br,
NikZ

[ashokkarale]

@Nikhil_Zambare1,

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

[Nikhil_Zambare1 (Nikhil Zambare)]

Dear Ashok,

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

[ashokkarale]

@Nikhil_Zambare1,

Try importing System.Xml.ReaderWriter Or System.Xml

[ashokkarale]

@Nikhil_Zambare1

Also try this.

Missing Assembly reference for DataTables as IEnumerables

Open the xaml file with this error in a text editor. Add <“AssemblyReference”>System.Xml.ReaderWriter’</“AssemblyReference”> (without the quotes) within the <sco:Collection x:TypeArguments=“AssemblyReference”> element.