Need use LIKE % some word % C#

Question

1.00/5 (1 vote)

See more:

I use code and work fine:

C#

var KooperacijaRN = this.radni_nalozi_2018DataGridView.Rows.Cast<datagridviewrow>().Where(row => row.Cells["R.b. RN"].Value.ToString() == "KO");  
            var childCount4 = KooperacijaRN.Count();  
            this.BlokiraniRNLabel.Text = childCount4.ToString();

Need to use word %KO% in query

What I have tried:

I need

var KooperacijaRN = this.radni_nalozi_2018DataGridView.Rows.Cast<DataGridViewRow>().Where(row => row.Cells["R.b. RN"].Value.ToString() LIKE "%KO%");

But this dont work
Please help
Thank you

Posted 19-May-21 22:53pm

Goran Bibic

Updated 19-May-21 23:13pm

RickZeeland

v2

Add a Solution

Comments

CHill60 20-May-21 4:54am

"But this dont work" - does it produce anything or does it throw an exception?

BillWoodruff 20-May-21 5:04am

describe what happens and any error messages clearly

PIEBALDconsult 20-May-21 10:07am

What value are you working with?

2 solutions

Solution 2

It looks like you're not querying against the database but against an existing dataset. For this reason you can't use the LIKE as if you had run it directly on SQL, but you can use an appropriate C# version instead. For example:

C#

Rows
  .Cast<DataGridViewRow>()
  .Where(row => row.Cells["R.b. RN"].Value.ToString().ToUpper().Contains("KO"));

This essentially replicates the behaviour you're expecting from the LIKE keyword. If you want to do this from the SQL then you'll need to amend your SQL query to leverage it.

Posted 19-May-21 23:13pm

Chris Copeland

Comments

Goran Bibic 20-May-21 5:19am

I try, but no error, dont work

Chris Copeland 20-May-21 5:34am

What part isn't working? Are you not seeing the count in the textbox, or is the code just not running? Have you tried putting a breakpoint in the code to step through line-by-line and see where you're not getting the results you want?

Goran Bibic 20-May-21 7:02am

not seeing the count in the textbox...code no errors

Chris Copeland 20-May-21 8:02am

Did you do as I asked and put a breakpoint in the code to see what happens when it runs? Sounds like the code isn't running at all, which could indicate it's not being triggered for some reason. Unfortunately we can't see the rest of your code, nor do we understand how the code should be triggering, so we can't provide that answer.

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)

jekin77 · Accepted Answer · 2021-05-19T23:11:00

Solution 1

You can use Contains() for your needs

C#

var KooperacijaRN = this.radni_nalozi_2018DataGridView.Rows.Cast<DataGridViewRow>().Where(row => row.Cells["R.b. RN"].Value.ToString().ToUpper().Contains("KO"));

Posted 19-May-21 23:11pm

jekin77

Updated 19-May-21 23:13pm

v3

Comments

Goran Bibic 20-May-21 5:19am

I try, but no error, dont work