How can I search more columns in DataGridView in C#

Question

I want to search more columns from the DatagridView. I am able to only search the product name, but I also want to search the Brand name and Category name. How can I achieve this?

Here is my code:

 public void LoadProducts()
    {
        int i = 0;
        dataGridView1.Rows.Clear();
        cn.Open();
        cm = new SqlCommand("select p.pcode, p.barcode, p.pdesc, b.brand, c.category, p.price1, p.price2, p.qty from tblproduct as p inner join tblbrand as b on b.id = p.bid inner join tblcategory as c on c.id = p.cid where p.pdesc like '" + txtSearch.Text + "%' order by p.pdesc", cn);
        dr = cm.ExecuteReader();
        while (dr.Read())
        {
            i++;
            dataGridView1.Rows.Add(i, dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), dr[6].ToString(), dr[7].ToString());
        }
        dr.Close();
        cn.Close();
    }

Please **do not** build SQL queries this way. You need to be parameterizing them. — Broots Waymb, Aug 26 '21 at 21:17
Speaking of SQL, you may want to brush over some introductory tutorials. You're essentially asking how to add conditions to the where clause, which is trivial. — Broots Waymb, Aug 26 '21 at 21:18
You may also want to research the best ways to use a DGV - poking strings into it, row by row is far from the best way to use it. keyword: *datasource* — Ňɏssa Pøngjǣrdenlarp, Aug 26 '21 at 21:20
Also, you should dispose your connection, command and reader with `using`, you shouldn't cache your connection object — Charlieface, Aug 26 '21 at 21:50

score -1 · Answer 1 · answered Aug 26 '21 at 21:34

After a thorough research, I finally got the solution:

public void LoadProducts()
    {
        int i = 0;
        dataGridView1.Rows.Clear();
        cn.Open();
        cm = new SqlCommand("select p.pcode, p.barcode, p.pdesc, b.brand, c.category, p.price1, p.price2, p.qty from tblproduct as p inner join tblbrand as b on b.id = p.bid inner join tblcategory as c on c.id = p.cid where p.pdesc like '" + txtSearch.Text + "%' or b.brand like '" + txtSearch.Text + "%' or c.category like '" + txtSearch.Text + "%' order by p.pdesc", cn);
        dr = cm.ExecuteReader();
        while(dr.Read())
        {
            i++;
            dataGridView1.Rows.Add(i, dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), dr[6].ToString(), dr[7].ToString());
        }
        dr.Close();
        cn.Close();
    }

How can I search more columns in DataGridView in C#

1 Answers1