Combobox binding

[amber]

Hello,
I have 6 comboboxes, that I thought I could bind to the same datasource, and
have them display different 'selectedvalue' s', but apparently I can't...

My code is as follows:

dim drv as datarowview = me.listbox1.sel ecteditem
dim dtbDL as datatable = _dataset1.Table s(0)
dim dtvDL as new dataview(dtbDL)
dtvDL.RowFilter = "STR_ONE" = 'Matching Text'"

'Combobox 1
Me.cbo1.datasou rce = dtvDL
me.cbo1.ValueMe mber = "STR_DISPLAY_VA LUE"
me.cbo1.Display Member = "STR_DISPLAY_VA LUE"
me.cbo1.Selecte dValue = drv("ITEM_1_FRO M_DATABASE").To String

'Combobox 2
Me.cbo2.datasou rce = dtvDL
me.cbo2.ValueMe mber = "STR_DISPLAY_VA LUE"
me.cbo2.Display Member = "STR_DISPLAY_VA LUE"
me.cbo2.Selecte dValue = drv("ITEM_2_FRO M_DATABASE").To String

Obviously I'm not able to do this...whatever the value is in
ITEM_2_FROM_THE _DATABASE is displayed in both.

I want all 6 comboboxes to display the same drop downlist of (76) values,
but to display the corresponding value in the database for each item.

Make sense??
Do I need to declare a new dataview each time? and/or datatable??

Thanks!
amber

[Cor Ligthert]

Amber,

When I understand you well, than you can by creating for every combobox its
own dataview.

I hope this helps,

Cor

"amber" <am***@discussi ons.microsoft.c om>

Hello,
I have 6 comboboxes, that I thought I could bind to the same datasource,
and
have them display different 'selectedvalue' s', but apparently I can't...

My code is as follows:

dim drv as datarowview = me.listbox1.sel ecteditem
dim dtbDL as datatable = _dataset1.Table s(0)
dim dtvDL as new dataview(dtbDL)
dtvDL.RowFilter = "STR_ONE" = 'Matching Text'"

'Combobox 1
Me.cbo1.datasou rce = dtvDL
me.cbo1.ValueMe mber = "STR_DISPLAY_VA LUE"
me.cbo1.Display Member = "STR_DISPLAY_VA LUE"
me.cbo1.Selecte dValue = drv("ITEM_1_FRO M_DATABASE").To String

'Combobox 2
Me.cbo2.datasou rce = dtvDL
me.cbo2.ValueMe mber = "STR_DISPLAY_VA LUE"
me.cbo2.Display Member = "STR_DISPLAY_VA LUE"
me.cbo2.Selecte dValue = drv("ITEM_2_FRO M_DATABASE").To String

Obviously I'm not able to do this...whatever the value is in
ITEM_2_FROM_THE _DATABASE is displayed in both.

I want all 6 comboboxes to display the same drop downlist of (76) values,
but to display the corresponding value in the database for each item.

Make sense??
Do I need to declare a new dataview each time? and/or datatable??

Thanks!
amber

[Cor Ligthert]

do what you want.

:-)

[Ron Ford]

I'm not sure if this will help, but I was reading in Chris Sells 'Windows
Forms Binding in C#, footnote, page 482', that the data source is bound to
each combobox and is managed by a common Binding manager which in turn is
part of a Binding Context. The Binding amager keeps all comboboxes
synchronized to the same row in the database. However, if each combobox has
a different Binding context, hence a diferent Binding Manager, then the combo
boxes can show different rows from the same data source.

"amber" wrote:

Hello,
I have 6 comboboxes, that I thought I could bind to the same datasource, and
have them display different 'selectedvalue' s', but apparently I can't...

My code is as follows:

dim drv as datarowview = me.listbox1.sel ecteditem
dim dtbDL as datatable = _dataset1.Table s(0)
dim dtvDL as new dataview(dtbDL)
dtvDL.RowFilter = "STR_ONE" = 'Matching Text'"

'Combobox 1
Me.cbo1.datasou rce = dtvDL
me.cbo1.ValueMe mber = "STR_DISPLAY_VA LUE"
me.cbo1.Display Member = "STR_DISPLAY_VA LUE"
me.cbo1.Selecte dValue = drv("ITEM_1_FRO M_DATABASE").To String

'Combobox 2
Me.cbo2.datasou rce = dtvDL
me.cbo2.ValueMe mber = "STR_DISPLAY_VA LUE"
me.cbo2.Display Member = "STR_DISPLAY_VA LUE"
me.cbo2.Selecte dValue = drv("ITEM_2_FRO M_DATABASE").To String

Obviously I'm not able to do this...whatever the value is in
ITEM_2_FROM_THE _DATABASE is displayed in both.

I want all 6 comboboxes to display the same drop downlist of (76) values,
but to display the corresponding value in the database for each item.

Make sense??
Do I need to declare a new dataview each time? and/or datatable??

Thanks!
amber