DataGridView and ComboBox columns

[=?Utf-8?B?Q2hyaXM=?=]

I am trying to populate a DataGridView Combobox column with a different data
binding source (dataset) depending upon a selection made in a previous
column. I can handle the previous column but how do I assign the following
properties dynamically in code?

DataPropertyNam e
DataSource
DisplayMember

I do see how to set these at design time but that won't do because I need
different data in the combobox per each row depending upon the previous
selection made.
I hope I explained the problem well enough.

[VJ]

In the Value Changed Event of previous column, you can set the properties as
below

if ( value.Equals("1 ") )
{
cb1.DataSource = dsTables.Tables["Table1"];
cb1.DisplayMemb er="Col1";
}
else
{
cb1.DataSource = dsTables.Tables["Table2"];
cb1.DisplayMemb er="Col2";
}
"Chris" <Ch***@discussi ons.microsoft.c omwrote in message
news:6F******** *************** ***********@mic rosoft.com...

>I am trying to populate a DataGridView Combobox column with a different
data
binding source (dataset) depending upon a selection made in a previous
column. I can handle the previous column but how do I assign the following
properties dynamically in code?

DataPropertyNam e
DataSource
DisplayMember

I do see how to set these at design time but that won't do because I need
different data in the combobox per each row depending upon the previous
selection made.
I hope I explained the problem well enough.

[=?Utf-8?B?UGhpbA==?=]

I am trying to do a similar sort of thing (but I populate the second combo
box from a list, not a data source) and I have found an even bigger problem.
If I select "option one" in the first column and then fill the second
column's combo box with options "1, 2, 3, 4", I have no problems. For this
example, I pick item 3 for column two. However, if I start a second row and
select "option two" in the first column and then try and fill the combo box
in column two with "5, 6, 7, 8", then I get a data error because "3", the
selection made in row one, is no longer a valid selection for the combo box
in column two. Even if you resolve the problem you are having, then you will
still be restricted by this problem.

Hopefully, someone can help us resolve this as well.

Phil

"Chris" wrote:

I am trying to populate a DataGridView Combobox column with a different data
binding source (dataset) depending upon a selection made in a previous
column. I can handle the previous column but how do I assign the following
properties dynamically in code?

DataPropertyNam e
DataSource
DisplayMember

I do see how to set these at design time but that won't do because I need
different data in the combobox per each row depending upon the previous
selection made.
I hope I explained the problem well enough.

[VJ]

Phil, you have to clear the DataSet binding, and the ComboxText before
associating a new DataSource. At the minimum, you should say ComboxBox1.Text
= "" and then bind the new datasource. If you have any code in the second
combobox selectedIndex or ValueChanged, beware of them, they might fire when
you clear text.. depending on how your property is organized..

VJ

"Phil" <Ph**@discussio ns.microsoft.co mwrote in message
news:F2******** *************** ***********@mic rosoft.com...

>I am trying to do a similar sort of thing (but I populate the second combo
box from a list, not a data source) and I have found an even bigger
problem.
If I select "option one" in the first column and then fill the second
column's combo box with options "1, 2, 3, 4", I have no problems. For
this
example, I pick item 3 for column two. However, if I start a second row
and
select "option two" in the first column and then try and fill the combo
box
in column two with "5, 6, 7, 8", then I get a data error because "3", the
selection made in row one, is no longer a valid selection for the combo
box
in column two. Even if you resolve the problem you are having, then you
will
still be restricted by this problem.

Hopefully, someone can help us resolve this as well.

Phil

"Chris" wrote:

>I am trying to populate a DataGridView Combobox column with a different
data
binding source (dataset) depending upon a selection made in a previous
column. I can handle the previous column but how do I assign the
following
properties dynamically in code?

DataPropertyNa me
DataSource
DisplayMembe r

I do see how to set these at design time but that won't do because I need
different data in the combobox per each row depending upon the previous
selection made.
I hope I explained the problem well enough.

[=?Utf-8?B?Q2hyaXM=?=]

I think this will work for a stand-alone combobox but not for a combobox used
within the atagridview.

I am instead going to add another column and depedning upon the first
selection, either column A or Column B will be active.
"VJ" wrote:

Phil, you have to clear the DataSet binding, and the ComboxText before
associating a new DataSource. At the minimum, you should say ComboxBox1.Text
= "" and then bind the new datasource. If you have any code in the second
combobox selectedIndex or ValueChanged, beware of them, they might fire when
you clear text.. depending on how your property is organized..

VJ

"Phil" <Ph**@discussio ns.microsoft.co mwrote in message
news:F2******** *************** ***********@mic rosoft.com...

I am trying to do a similar sort of thing (but I populate the second combo
box from a list, not a data source) and I have found an even bigger
problem.
If I select "option one" in the first column and then fill the second
column's combo box with options "1, 2, 3, 4", I have no problems. For
this
example, I pick item 3 for column two. However, if I start a second row
and
select "option two" in the first column and then try and fill the combo
box
in column two with "5, 6, 7, 8", then I get a data error because "3", the
selection made in row one, is no longer a valid selection for the combo
box
in column two. Even if you resolve the problem you are having, then you
will
still be restricted by this problem.

Hopefully, someone can help us resolve this as well.

Phil

"Chris" wrote:

I am trying to populate a DataGridView Combobox column with a different
data
binding source (dataset) depending upon a selection made in a previous
column. I can handle the previous column but how do I assign the
following
properties dynamically in code?

DataPropertyNam e
DataSource
DisplayMember

I do see how to set these at design time but that won't do because I need
different data in the combobox per each row depending upon the previous
selection made.
I hope I explained the problem well enough.