using like operator in if operator in C#

Question

I have a textbox for search (that is, textBox1) A user, for example, enters "aba" in textBox1. "abandon" puts in datagridiew1. The user clicks on datagriview1:

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
    richTextBox_MWE.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
    if ("richTextBox_MWE.Text like '%" + textBox1.Text + "%'")
    {
        label5.BackColor = Color.Green;
    }
}

I want if "abandon" is such as "aba" in textBox1, label5.BackColor becomes Green.

Generally, you'd like to consider Regular Expressions (msdn.microsoft.com/en-us/library/hs600312.aspx) as a .NET equivalent for SQL LIKE operator, but in this particular case you can just use .Contains() method. — Isantipov
– Isantipov, Commented Jun 20, 2014 at 12:37

Vasistan · Accepted Answer · 2014-06-20 12:40:03Z

4

Simple way is use the textBox1(where actually filter content going to change) change event

if(!String.IsNullOrEmpty(richTextBox_MWE.Text) && richTextBox_MWE.Text.Trim().Contains(textBox1.Text.Trim()))
{
  label5.BackColor = Color.Green;
}

answered Jun 20, 2014 at 12:40

Vasistan

2921 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2111639 Over a year ago

Thanks alot. I also want customed Contains Function, that is, If I enter "1" just Contains Function findes "1" not "11" or "21" or ....

Hamlet Hakobyan · Accepted Answer · 2014-06-20 12:35:13Z

2

You want to use some kind of mix of C# and sql :) You can use the String.Contains method to achieve what you want.

if(richTextBox_MWE.Text != null
    && richTextBox_MWE.Text.Contains(textBox1.Text.Trim())
{
    ...
}

answered Jun 20, 2014 at 12:35

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

Comments

Sreenath · Accepted Answer · 2014-06-20 12:36:46Z

0

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
    richTextBox_MWE.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
    if (!String.IsNullOrEmpty(richTextBox_MWE.Text) && !String.IsNullOrEmpty(textBox1.Text) && richTextBox_MWE.Text.Contains(textBox1.Text.Trim()))
    {
        label5.BackColor = Color.Green;
    }
}

Here the contains will accept the value to be searched.

answered Jun 20, 2014 at 12:36

Sreenath

1111 silver badge5 bronze badges

1 Comment

Hamlet Hakobyan Over a year ago

'' like '%%' is true.

pjamenaja · Accepted Answer · 2015-01-09 23:16:26Z

0

See snippet from my code. The txtProductCode is a text box that user is filling the product_code for searching in the list view.

        string tmpProductCode = txtProductCode.Text.Trim();
        string tmpProductCodePattern = "^" + Regex.Escape(tmpProductCode).Replace("%", ".*") + "$";

In my loop of product_code(s) the prodCode will contain the product_code value for each loop.

        productCodeClause = false;              
        if (tmpProductCode.Equals(""))
        {
            productCodeClause = true;
        }
        else
        {
            if (Regex.IsMatch(prodCode, tmpProductCodePattern))
            {
                productCodeClause = true;
            }
        }

I hope this will be helpful.

edited Jan 9, 2015 at 23:16

answered Jan 9, 2015 at 23:08

pjamenaja

11 bronze badge

Collectives™ on Stack Overflow

using like operator in if operator in C#

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related