Filter combobox

[Zensell]

Hi, my grid have two columns: Category and Product. Product column is a GridViewComBoxColumn and I want to filter its dropdown items depending on the category in the same row. How could I achieve this? Thanks.

[Martin Vasilev]

Hi Zensell,

Thank you for writing.

Please find a sample project as an attachment to this message, which demonstrates how to achieve functionality similar to the described one.

I hope this helps. Let me know if you have any additional questions about this.

Greetings,
Martin Vasilev
the Telerik team

[Zensell]

Thanks Martin. I am using Q2 2010 SP1. I have found an issue in that sample project:

1. Change the country of any row. For example, select 'Canada'.
2. Select the last item in the city dropdown in that row. For example, select 'Redeer'.
3. Leave the city cell.

Then the city cell in that row blanks out! Is there a fix for this?

[Emanuel Varga]

Hello Zensell,

Please try it with these changes:

void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)
{
    if (this.radGridView1.CurrentColumn.FieldName == "CityId")
    {
        RadDropDownListEditor listEditor = (RadDropDownListEditor)this.radGridView1.ActiveEditor;
        RadDropDownListEditorElement editorElement = (RadDropDownListEditorElement)listEditor.EditorElement;
        localCities.Clear();
        int currentCountryId = int.Parse(this.radGridView1.CurrentRow.Cells["CountryId"].Value.ToString());
        for (int numberOfCities = 0; numberOfCities < cities.Count; numberOfCities++)
        {
            if (cities[numberOfCities].CountryId == currentCountryId)
            {
                localCities.Add(cities[numberOfCities]);
            }
        }

        editorElement.DataSource = localCities;
        radGridView1.CurrentCell.Value = (int)e.Value == -1 ? localCities[0].Id : e.Value;
    }
}

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga