Missing operand after 'NotEqualTo' operator.

[Ken]

In the code below, I get the error: Missing operand after 'NotEqualTo' operator. 

  if (!Page.IsPostBack)
            {
                grdGSRComp.MasterTableView.FilterExpression = "([Variance] NotEqualTo \'0\') ";
                GridColumn column = grdGSRComp.MasterTableView.GetColumnSafe("Variance");
                column.CurrentFilterFunction = GridKnownFunction.NotEqualTo;
                column.CurrentFilterValue = "0";
                grdGSRComp.MasterTableView.Rebind();
            }

This code runs in page_load.

tried different variations and none worked. Any ideas?

Thanks!

[Shinu]

Hello Ken,

I tried the same scenario in PreRender event which worked as expected.

C#:

protected void RadGrid1_PreRender(object sender, System.EventArgs e)
{
    if (!Page.IsPostBack)
    {
        RadGrid1.MasterTableView.FilterExpression = "([Variance] NotEqualTo \'%0%\')";
        GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("Variance");
        column.CurrentFilterFunction = GridKnownFunction.Contains;
        column.CurrentFilterValue = "0";
        RadGrid1.MasterTableView.Rebind();
    }
}

Thanks,
Shinu.

[Ken]

Thanks for your reply Shinu, however that does not work either.

All I'm trying to do is set a default filter for my grid and have it be applied automatically when the grid is loaded.

Does datasource-order assignment matter? I have my Ds in Page_Load, I tried it in prerender but that still doesn't work.

If this doesn't work in telerik then I'll just have to add a parameter and do this at the DB level.

Thanks.

[Ken]

I fixed it.

Instead of code behind, I did this in the ASPX markup and the filter expression I used is: FilterExpression="([Variance] <> 0)"