How to filter a datatable using both AND and OR condition in Select method?

[kkpatel (Kamal)]

Hi All

How to filter a datatable using both AND and OR condition in Select method ?

OR condition for a single column and AND condition for a different column.

Kindly help with an example.

[johnfelix (John Felix Yesuraj)]

@kkpatel

How to filter a datatable using both AND and OR condition in Select method

AND condition implemented for Product column
OR condition implemented for Country column

When you run the below query you will get 2 rows in output

input_dt.Select(“[Product] = ‘Chai’ and ([Country] = ‘India’ OR [Country] = ‘Great Britain’)”).CopyToDataTable

When you run the below query you will get 3 rows in output

input_dt.Select(“[Product] = ‘Chai’ and ([Country] = ‘India’ OR [Country] = ‘Great Britain’ OR [Country] = ‘Brazil’)”).CopyToDataTable

Note: Enclose the OR condition inside brackets