[Solved] How to add filter option in a single column on custom field

[vivek tamboli]

Hi
I am binding dataset to radgrid and i want to add filter option in a single column. Let me know how to do this.

-------------------------------------------------------

RadGrid1.DataSource = _DS.Tables[0];

RadGrid1.DataBind();

--------------------------------------------------

[Princy]

Hi,

You can use the grid's PreRender event to specify an initial filter using a specific column.

C#

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

In addition you can set the AllowFiltering property of each column to True or False depending on whether you need to  enable or disable filtering for the column.

Thanks,
Princy