Can each combobox in a datagridview column have unique values and if so how?

[svaradan]

Hi

I have a situation where in I have two combo boxes in a datagridview control. The first combo box items are all static. But the second combo box items need to change based on the first combo box value selected. The problem I am running into is if I bind the datasource to the column the values are all the same all the time. Please help.

Sonny

[Luceafaru]

This may help:

http://www.thescripts.com/forum/post2081478-2.html

[svaradan]

Thanks for the information. It still is not helping me since my current situation is this.

I have a datagridview which has two combobox columns. I want the items listed and available for selection to change on one combobox to change based on the item selected on the other.

Hopefully this gives a clearer picture.

And thanks for helping me out with this issue.

[WereWolfx]

Thanks for the information. It still is not helping me since my current situation is this.

I have a datagridview which has two combobox columns. I want the items listed and available for selection to change on one combobox to change based on the item selected on the other.

Hopefully this gives a clearer picture.

And thanks for helping me out with this issue.

Did you found the solution? I got the exact same situation here...

Thank you

W

[ambp]

In order two have two combobox columns that one is based on the previose one you have to do the following:
* Create a global bindingSource
BindingSource filteredCmbColumn2= new BindingSource();
DataView dv = new DataView(dtCmbColumn1);//create a dataview from the first cmbColumn.
filteredCmbColumn2.DataSource = dv;//secend column's datasource is the dataview from first cmbColumn.

In the event: Cell_BeginEdit()
// Set the combobox cell datasource to the filtered BindingSource
DataGridViewComboBoxCell dgcb = (DataGridViewComboBoxCell)datagridview1[e.ColumnIndex, e.RowIndex];
dgcb.DataSource = filteredCmbColumn2;

// Filter the BindingSource based upon the region selected
this.filteredCmbColumn2.Filter = "..."

In the event Cell_EndEdit()
// Reset combobox cell to the unfiltered BindingSource
this.filteredCmbColumn2.RemoveFilter();