I'm working with the DataGridView, and one of my columns uses DataGridViewComboBox cells.  What I'd like to do is handle a user changing the selected value in the combo box, and change the value in one of the other cells in the row to correspond with the selection.  Unfortunately, I can't figure out how to accomplish this.  Right now I'm handling the CellEndEdit event, but that only fires if I change the selection then click off of the cell.  Is there some way of doing what I need?  I don't understand why the DataGridViewComboBox does not have an OnSelectionChange event or something similar...

---

Looking for an advanced SQL Server 2005 book?

Expert SQL Server 2005 Development

Hi Adam,

I dont think there is an easy way to do this (although I have not worked extensively with the DataGridView in 2k5) - one way I can think of you could do this would be to hook yourself up to the DataGridView.EditingControlShowing event, the EventArgs e.Control member can then be cast to a ComboBox control to allow you to hook up the SelectedIndexChanged event to your handler. You can then update your other column when you want to when this event fires.

Remember to unregister your event handler as well - either next time EditingControlShowing fires or when CellEndEdit fires.

You might also want to experiment with only hooking yourself up once and not unhooking until you destory the form as I have a suspicion that that same combobox control might be used for editing of all cells (or that is at least the way other grids work such as DevExpress, Synfusion, Infragistics etc).

Hope this helps,

- James

Hi James.I meet I met a same problem.According to what you say,my code is such as:

private DataGridView dataGridView1 = new DataGridView();

private void AddColorColumn()
{
    DataGridViewComboBoxColumn comboBoxColumn =
        new DataGridViewComboBoxColumn();
    comboBoxColumn.Items.AddRange(
        Color.Red, Color.Yellow, Color.Green, Color.Blue);
    comboBoxColumn.ValueType = typeof(Color);
    dataGridView1.Columns.Add(comboBoxColumn);
    dataGridView1.EditingControlShowing +=
        new DataGridViewEditingControlShowingEventHandler(
        dataGridView1_EditingControlShowing);
}

private void dataGridView1_EditingControlShowing(object sender,
    DataGridViewEditingControlShowingEventArgs e)
{
    ((ComboBox)e.Control).SelectedIndexChanged +=
        new EventHandler(ComboBox_SelectedIndexChanged);
}

private void ComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
    ((ComboBox)sender).BackColor = (Color)((ComboBox)sender).SelectedItem;
}

But the problem ("only fires if I change the selection then click off of the cell")still exists，could you analyze this problem for me?