Using VB and trying to do a simple items collection add. Cannot seem to properly reference the designer created

Sorry about that; I messed up on the answer. I did some testing and I think this will give you what you want.

Let me know if this works or if its unclear.

Best

-Tom

Hi,

I dont write in VB but would this work? I'm not sure if you would want the new and I'm assuming As works the same in VB as it does in C#.

Is there any reason you do not work directly on the column from the grid view? Also if you want to access the comboBoxes in the column you'll probably want to go thourgh the rows property.

Sorry, this does not seem to address my question. Let me be clearer.

I can get a completely new combobox to drop into the datagridview. And it's nicely loaded with values aftrer using items.add.

But, what I cannot do is referenence the existing designer created combobox in the grid in order to populate it using items.add.

Sorry about that; I messed up on the answer. I did some testing and I think this will give you what you want.

Let me know if this works or if its unclear.

Best

-Tom

Hello.
I found this on an other forum that help me.

It will get you a reference tothe selected DataGridViewComboBoxCell.
In my example I have two comboboxes in my grid andwhen the user changes the value in the first oneit will

filter the data in the next one so only related data is shown. (didnt paste the whole example)

You have toknow whichcellyou want to reference and you do that by e.columnindex and e.rowindex.

Good luck./P

Private Sub grdAvtal_CellValueChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles grdAvtal.CellValueChanged

If grdAvtal.Columns(e.ColumnIndex).Name = "iVE_Id_Avtalspart" Then

Dim cboCellProdEnhet As DataGridViewComboBoxCell

cboCellProdEnhet = CType(grdAvtal(e.ColumnIndex + 1, e.RowIndex), DataGridViewComboBoxCell)

...

...

Thanks for this info. Could you post the link to the other forum for complete code?

Also, I think I'm trying to do something different than you show here. Although, in the end I want the same result. I want to be able to select a value in the first datagridcombobox and have it then provide a subset in the second datagridviewcombobox.

I tried to start with a datagridview control that already has two datagridviewcombobox columns. But I want to populate them by setting their datasource property dynamically at runtime. I can of course use the dataset/tableadapter/bindingsource approach, but I was trying for something more lightweight than that.

So, I retrieve a dataresultset as shown below and I set the datagridviewcombobox properties in some event (say Form.Load event for example). This code will work fine with a comboboxcontrol outside of the grid. But when it is set up as I have it below, it fails to populate the combobox in the grid.

This will return an error "No data exists for the row/column"

Same error occurs if I build a new datagridviewcomboboxcolumn and then do a datagridview1.columns.add

I don't want to build the combobox with Items.add since the datasource will have two columsn, one display and one value.

I guess my major disconnect here is trying to treat the datagridviewcombobox as a standard form combobox control. And maybe not understanding the event model of the datagridview well enough to understand the populating of said column.