DataGridViewComboBoxColumn setting SelectedIndex

[Tim8w]

I have a DataGridViewComboBoxColumn that I allow the user to add new items to by typing in the ComboBox and hitting the 'Enter' key. That triggers CellValidating and I do the adding there by the following:

cmbColumn.Items.Add(e.FormattedValue)


All this works well, except that it leaves the DataGridViewComboBoxColumn blank. How can I set the DataGridViewComboBoxColumn to display the e.FormattedValue?

 

[ousoonerjoe]

The assignment is very straight forward. The catch is that the data type being passed MUST be the exact same data type as the DataGridViewComboBoxColumn.ValueType.

e.Row.Cells(dcPayFlag.Index).Value = CByte(1)	 [COLOR=green]'Required to match data type of ValueType.[/color]

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[Tim8w]

ousoonerjoe,
That looks like a plausible solution, unfortunately in CellValidating where I am adding the item, the e variable is of type:

System.Windows.Forms.DataGridViewCellValidatingEventArgs

which members do not include Row.

The member variables are:
Cancel
ColumnIndex
FormattedValue
RowIndex

 

[Tim8w]

I finally figured it out. Here's what I had to do:

Dim CBox As DataGridViewComboBoxCell = CType(dgvRecipe.Rows(e.RowIndex).Cells(e.ColumnIndex), DataGridViewComboBoxCell)

cmbColumnIngredient.Items.Add(e.FormattedValue)
CBox.Value = e.FormattedValue