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.
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() + "' ";
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With