C# POS problems

[fhau013]

what does this mean really need your help thank you!

[pritaeas]

Your query is invalid. It needs to be:

WHERE column1 LIKE '%something%' AND column2 LIKE '%something%'

[fhau013]

ifthe vaalue of '%something%' is in the text box what will be query? :)

[pritaeas]

Type your line with the query here, so I can copy and fix it.

[fhau013]

private void txtproductname_TextChanged(object sender, EventArgs e)
        {

            DataView dv = new DataView(dbdataset);
            dv.RowFilter = string.Format(" SELECT * FROM productstbl WHERE product_description AND product_code LIKE '%{0}%'", txtproductname.Text);
            datagriditems.DataSource = dv;

        }

[pritaeas]

dv.RowFilter = string.Format("SELECT * FROM productstbl WHERE product_description LIKE '%{0}%' OR product_code LIKE '%{0}%'", txtproductname.Text);

[fhau013]

it still have an error

Syntax error: Missing operand after 'productstbl' operator.

what doesthis mean?

[fhau013]

by the way sir im using mysql