Searching for records using RowFilter

  • Thread starter Thread starter Amit Anand via .NET 247
  • Start date Start date
A

Amit Anand via .NET 247

Hi All

I have a Data Table which has records like this

Name Descr Items
1 decr1 a,b,c
2 descr2 a,b
3 descrx a
4 descr4 b,c


Now I want to search for all those records which have a in the column Items
so my search should return Name 1,2 and 3
I tried using RowFilter with an IN clause but it somehow does not work.
If someone could provide mw with a sample it would be of gr8 help.

Thanks
 
Amit,

If items in Items column are all single letter, then you might use
Items LIKE '%a%'
 
Back
Top