DataTable select with delimiter

[bczm8703]

Hi,

is it possible to do a row filter or linq where splitting the filter string by commas

Name	Department
User 1	HR
User 2	PR
User 3	IT
User 4	Sales

i would like to pass in a search string, eg: HR,PR,

user 1 and user 2 should come out

 

[Skydiver]

What is the backing database behind that table? Or are you trying to do the filtering on the client side?

 

[bczm8703]

Database is using ms sql. I am looking at filtering it after receiving the data from the DB and before binding the GridView

 

[jmcilhinney]

That's what OR operators are for. You want rows where a column contains one value OR another value. If you read the documentation for the appropriate member, that will point you to the DataColumn.Expression property documentation to learn the appropriate syntax.

 

[Skydiver]

I can't recall whether the client side DataTable supports IN SQL operator, and I'm too lazy to check right now. I do know they SQL Server supports it.

 

[Skydiver]

Yup, IN is supported.

DataColumn.Expression Property (System.Data)

Gets or sets the expression used to filter rows, calculate the values in a column, or create an aggregate column.

docs.microsoft.com