[Solved] filter dropdownlist on edit item

[Jon Markee]

I have two columns in a radgrid. 

Column1 = Client
Column2 = Category

The catgory column is related to employees.  When I select edit item on the grid i need my category dropdownlist to only show categories for that client.  And if I switch the client in edit item mode i need the category drop down list to update to reflect the new categories.


Thanks,

Jon

[Shinu]

Hello,

I guess you are using DropDownColumns in your grid. If so, you can access the first dropdownlist in the editform for a column and then attach SelectedIndexChanged event as shown below.

CS:

protected void RadGrid1_ItemCreated(object sender, Telerik.Web.UI.GridItemEventArgs e)
        {
            if (e.Item is GridEditableItem && e.Item.IsInEditMode)
            {
                DropDownList ddlist = (e.Item as GridEditableItem)["Client"].Controls[0] as DropDownList;
                ddlist.AutoPostBack = true;
                ddlist.SelectedIndexChanged += new EventHandler(ddlist_SelectedIndexChanged);
            }
        }

Then access the second dropdown in the EditForm in the SelectedIndexChanged event of the first dropdown to populate based on the selection.

CS:

 void ddlist_SelectedIndexChanged(object sender, EventArgs e)
    {
            GridEditableItem editedItem = (sender as DropDownList).NamingContainer as GridEditableItem;
           DropDownList ddList2 = editedItem["Category"].Controls[0] as DropDownList;
            // Set the DataSource for ddList2 with custom code here
    }

Also checkout the following demo which depicts similar scenario: Accessing Cells and Rows

-Shinu.

[Jon Markee]

Thanks so much.