Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Missing operand after 'Operator Name' operator

I am filtering my gridview using dataview. I am passing the filter command to dataview as mentioned below;

string strFilter= " 0=0 ";

if (Session["SampleSession"] != null)
        {
            strFilter= strFilter+ " and Emp Name = '" + Session["SampleSession"].ToString() + "' ";
        }
dv.RowFilter = strFilter;  // Throws an error here!

It throws an error of Missing operand after 'Operator Name' operator in above line.

i believe there is small error which i am unable to catch.

like image 747
xorpower Avatar asked Aug 08 '11 05:08

xorpower


1 Answers

Your problem is that "Emp Name" (the column name) contains a space and needs to be wrapped in square brackets in the filter expression:

strFilter= strFilter+ " and [Emp Name] = '" + Session["SampleSession"].ToString() + "' ";
like image 199
Matt Hamilton Avatar answered Sep 28 '22 17:09

Matt Hamilton