[Solved] Multi-column filtering at code-behind

[Liji Jose]

Hi,

In RadGrid, is it possible to set multi-column filtering, what I mean by multi-column filtering is for the same column can I set a filter expression using logical operators, ie., like FilterExpression = "ID equals OR greater Than 10".(ID being the column)

How can I set the filter expression at code-behind?

Could u plz reply me with the code snippet....

-Liji Gilesh

[Princy]

Hi,

You can manipulate the RadGrid1.MasterTableView.FilterExpression as  shown below:

  protected void Button1_Click(object sender, EventArgs e)
        {
            RadGrid1.MasterTableView.FilterExpression = "[CustomerID] = 'ALFKI' OR [CustomerID] = 'CENTC' ";

            RadGrid1.Rebind();
        }

Thanks,
Princy

[Liji Jose]

Thanks Princy for the reply....

Further more, can I set the same at runtime, ie., with filter menu can I set the same?

Awaiting ur reply,
Liji Gilesh

[Princy]

Hi Liji,

Please  have a look at the links below on how to localize the filter menu options to add your custom filter and also on how to manually set the Filter Expression for the custom filter.

Localizing filtering menu options

Operating with the FilterExpression of Telerik RadGrid manually

Thanks,

Princy