Missing operand after '=' operator

Question

I have this line of code which uses a dataview view_1 and I'm trying to filter the datagridview by product_name and its size using the RowFilter. Here is the code:

view_1.RowFilter = "product_name = '" + cboProduct.Text + "' AND size = " + cboSize.Text + "";

And when I try to run the application it says Missing operand after '=' operator. So what is that missing operand?

take a whitespace Between `'" + cboProduct.Text + "'` `AND` – Rahul May 21 '13 at 07:07 — Rahul, May 21 '13 at 07:07
A good example to use `String.Format` – I4V May 21 '13 at 07:08 — I4V, May 21 '13 at 07:08

Tim Schmelter · Answer 1 · 2013-05-21T07:32:08.007

8

~~You have a missing white-space at 'AND~~

So replace

'AND

with

' AND

Is size a string-column or an int-column? If it's a string you need quotation marks around too:

AND size = '" + cboSize.Text + "'";

or even better, use String.Format as others have commented since it insreases readability:

view_1.RowFilter = string.Format("product_name = '{0}' AND size = '{1}'"
            , cboProduct.Text
            , cboSize.Text);

edited May 21 '13 at 07:32

answered May 21 '13 at 07:06

Tim Schmelter

450,073
74
686
939

@Harvey: Is size a string-column or an int-column? If it's a string you need quotation marks around too. `AND size = '" + cboSize.Text + "'";`. Btw, instead of rewriting your question to remove the wrong part you should have added instead the information that it's still not working. Now my answer makes no sense anymore but it could have been helpful for others with a similar problem. – Tim Schmelter May 21 '13 at 07:20
Okay I get it..after putting a white-space I tried to put it in the else clause and now it's working. Thank you. – Harvey May 21 '13 at 07:32
@Harvey: Also edited my answer to show you how you can use `String.Format` to increase readability. – Tim Schmelter May 21 '13 at 07:34

Rajeev Kumar · Answer 2 · 2013-05-21T07:13:53.270

4

Write like this

view_1.RowFilter = "product_name = '" + cboProduct.Text + "' AND size = " + cboSize.Text + "";

Missing White space problem

Edit

You can also use string.Format

view_1.RowFilter =  String.Format("product_name = '{0}' AND size = {1}", cboProduct.Text,cboSize.Text);

edited May 21 '13 at 07:13

answered May 21 '13 at 07:06

Rajeev Kumar

4,901
8
48
83

score 1 · Accepted Answer · answered May 21 '13 at 07:37

I don't know what is wrong I tried to filter first if the text of cboProduct and cboSize is empty or if no selection has been made and now it's working. Thank you. Here is the code

if (cboProduct.Text == string.Empty || cboProduct.SelectedIndex == -1 || cboSize.Text == string.Empty || cboSize.SelectedIndex == -1)
            {
                view_1.RowFilter = string.Empty;
            }
            else
            {
                view_1.RowFilter = "product_name = '" + cboProduct.Text + "' AND size = " + cboSize.Text + "";
            }

score 0 · Answer 4 · answered Dec 05 '17 at 10:03

If the variable product_name is having a value that contains a space then the value needs to be wrapped in square brackets in the filter expression: So,just wrap the variable product_name by pair of square brackets like this [product_name]

view_1.RowFilter = "[product_name] = '" + cboProduct.Text + "' AND size = " + 
cboSize.Text + "";

Missing operand after '=' operator

4 Answers4