Need clarification to create LinQ query

[Logesh_Ekeshwara_Rao]

I have excel sheet I have converted it to DT and Stored in Report.DT Now I have to Filter Status collumn as passed and modules Name collumn as Customer .

This is the query Filtered_DT.Select(“[Status]=‘Passed’ And [Modules Name]=‘Customer’”) I used but it is not working it is throwing an error of “Multiple Assign-Modules count: Can not assign 'Filtered_DT.Select(”[Status]=‘Passed’ And [Modules Name]=‘Customer’“)’ to ‘Customer_Pass_count’.”

Can anyone help me to get solution of it.

[lrtetala (Lakshman Reddy)]

Hi @Logesh_Ekeshwara_Rao

Can you try the below

DT = DT.Select("[Status]='Passed' And [Modules Name]='Customer'").CopyToDataTable()

Input:

Output:

Or

If you want Customer_Pass_count then try below

Customer_Pass_count = DT.Select("[Status]='Passed' And [Modules Name]='Customer'").Count

Cheers!!