Programmatically loading Filter Values

[Michael]

I am trying to help the user select filter values by clicking on a grid row and then programmatically loading those values into the filter columns.  I have two problems.  My columns are automatically generated and columns are not found in the foreach loop.  Secondly, the CurrentFilterValue does not seem to accept values.

Thanks for any assistance.

 

protected void radGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)

{

 

 

 

 

if (e.CommandName == "RowClick" && e.Item is GridDataItem)

{

 

 

 

foreach (GridColumn column in radGrid1.MasterTableView.Columns)  

{

 

 

 

string IDx = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex][column.UniqueName].ToString();

column.CurrentFilterValue = IDx;

}

 

 

 

}

}

 

 

 

 

  

[Princy]

Hi,

You can use the RenderColumns collection to access the autogenerated columns collection snd set the filter expression for the mastertableview. Check out the code below:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.CommandName == "RowClick" && e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            foreach (GridColumn column in RadGrid1.MasterTableView.RenderColumns)
            {
                if (column is GridBoundColumn)
                {
                   string IDx = item[column.UniqueName].Text;
                   column.CurrentFilterValue = IDx;
                   column.CurrentFilterFunction = GridKnownFunction.Contains;
                   RadGrid1.MasterTableView.FilterExpression = "(["+column.UniqueName+"] = " + IDx + ")";
                }
            }
            RadGrid1.Rebind();
        }
    }

Thanks,
Princy