[Solved] Unable to set the filter expression for self referential grid.

[giridhar]

Hi,
  I have a dataset which gives the list of id's and parent id's I am unable to set the FilterExpression
as follows, do let me know if there is some other syntax to be used.
string ID = 2839;
selfReferentialGrid.MasterTableView.FilterExpression = @"PrntID=" + ID;

Error is thrown on selfReferentialGrid.DataBind().

Would there be any problem if PrntID has null values.

Thanks and regards,
Giridhar.

[Yavor]

Hi giridhar,

One similar case is demonstrated in the following example. More specifically, the code:

 public void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                RadGrid1.MasterTableView.FilterExpression = "ParentID = 0";
            }
        }

Additionally, if you are using the 3.5 version of the controls, you can disable the linq expressions (EnableLinqExpressions=false), since the linq syntax is different.
I hope this helps.

Sincerely yours,
Yavor
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.