Dataset table filtering: How to filter for rows where column "contains" a value.

Question

4.00/5 (3 votes)

See more:

I have a dataset table that contains a column named "Frequency". The following are examples of the values contained in that column:

ID Frequency
------ ----------
1 30,90
2 30,90
3 90
4 30,90
5 90,365
6 90
7 15,180

I'm trying to come up with a filter expression that will allow me to select only those rows where column Frequency contains the value "30". The only ways that I can think of to approach this would be to use "LIKE" or "CONTAINS" operators.

The following is an attempt to use "LIKE"

dSet.Tables(0).DefaultView.RowFilter = "'30' IN (Frequency)"

This produces the error: {"Only constant expressions are allowed in the expression list for the IN operator."}

The following is my attemp at useing "CONTAINS":

dSet.Tables(0).DefaultView.RowFilter = "Frequency contains (30))"

This produces the error: {"Syntax error: Missing operand after 'contains' operator."}

I've tried several variations on the CONTAINS syntax... I'm not so sure that it is supported in filtering syntax.

Any nudge in the right direction would be greatly appreciated.

Posted 8-Jun-11 6:33am

Rick Behrens

Updated 8-Jun-11 6:50am

pankajupadhyay29

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yvan Rodrigues · Answer 1 · 2011-06-08T06:58:00

You're looking for

dSet.Tables(0).DefaultView.RowFilter = "Frequency LIKE '*30*'";

However, this will also select rows where the value is 300, 130, etc. So to get only values of 30 you'd need something like:

dSet.Tables(0).DefaultView.RowFilter = "Frequency = '30' OR Frequency LIKE '30,*' OR Frequency LIKE '*,30'";

and so on so that you get all of the possibilities.

If you're using v3.5 or later of the framework you can use LINQ to make a dataview that you can use as a datasource.

var view = from DataRow row in dSet.Tables(0).Rows
           from frequency in row.Frequency.Split(new[]{','})
           where frequency == "30"
           select row;

pankajupadhyay29 · Answer 2 · 2011-06-08T06:51:00

Solution 1

use this

dSet.Tables[0].DefaultView.RowFilter = "Frequency like '%30%')";

hope this will work for you.

Posted 8-Jun-11 6:51am

pankajupadhyay29

Updated 8-Jun-11 6:52am

v2

Comments

Yvan Rodrigues 8-Jun-11 13:19pm

In case anyone is confused, * and % can be used interchangably in DataColumn expressions.

Rick Behrens 8-Jun-11 13:58pm

Thanks Yvan, that worked perfectly. Appreciate your help.