bng0005
asked on
Binding combobox selectedvalue to a dataview column
I have a few comboboxes on my form that I fill through code. Now I want to bind the selected value of those comboboxes to information contained in my dataview. I tried
cboHairColor.DataBindings. Add("Selec tedValue", dv, "Hair")
as well as DisplayMember and SelectedItem instead of SelectedValue but it's not showing any data in the field.
This is the code I use to bind my text boxes to my dataview, so not sure what's not working for my comboboxes.
cboHairColor.DataBindings.
as well as DisplayMember and SelectedItem instead of SelectedValue but it's not showing any data in the field.
This is the code I use to bind my text boxes to my dataview, so not sure what's not working for my comboboxes.
Did you try ??
cboHairColor.DataSource = dv
cboHairColor.DisplayMember = "column to display"
cboHairColor.ValueMember = "Hair"
-Baan
cboHairColor.DataSource = dv
cboHairColor.DisplayMember
cboHairColor.ValueMember = "Hair"
-Baan
ASKER
I fill the combobox options on the form load like this:
cboHairColor.Items.Add("AU ")
cboHairColor.Items.Add("BD ")
cboHairColor.Items.Add("BK ")
so I can't set the datasource to the dataview. The dataview is a filtered version of my records, with the combobox being used to display one of those fields, if that makes sense
cboHairColor.Items.Add("AU
cboHairColor.Items.Add("BD
cboHairColor.Items.Add("BK
so I can't set the datasource to the dataview. The dataview is a filtered version of my records, with the combobox being used to display one of those fields, if that makes sense
ASKER
Gonna try to explain the problem a little better since it doesn't sound all that clear to me and it's my question heh.
I have a dataset that has all the customer information to be displayed in my UI. Most of the fields are displayed in textboxes and binding those to my dataview is simple enough. A few need to be bound to comboboxes. These comboboxes have their options filled in manually since they each only have like 4 or 5 different options, so I don't have a dataview of the different options to bind to the datasource of the comboboxes. What I would like to have happen is that in my main dataview, have the data for that column display in that combobox if it exists.
If it can be done this way without changing my code, great. I would like to do it that way if possible.
If I have to redo my combobox code and not add in items manually, how would I get a dataview set up with a table containing all of the items to be included in the combobox?
I have a dataset that has all the customer information to be displayed in my UI. Most of the fields are displayed in textboxes and binding those to my dataview is simple enough. A few need to be bound to comboboxes. These comboboxes have their options filled in manually since they each only have like 4 or 5 different options, so I don't have a dataview of the different options to bind to the datasource of the comboboxes. What I would like to have happen is that in my main dataview, have the data for that column display in that combobox if it exists.
If it can be done this way without changing my code, great. I would like to do it that way if possible.
If I have to redo my combobox code and not add in items manually, how would I get a dataview set up with a table containing all of the items to be included in the combobox?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use:
cboAccountStatus.DataBindi ngs.Add("S electedVal ue", dv, "hair")
or
cboAccountStatus.DataBindi ngs.Add("S electedTex t", dv, "hair")
cboAccountStatus.DataBindi
or
cboAccountStatus.DataBindi
ASKER
Baan,
The combobox isn't used for SQL selection, only display existing data in my dataview. I just want to bind the combobox to one of the columns in my dataset so the data shows in the textbox area if it exists, and if it doesn't, they can use the options in the combobox to ensure proper data entry. Pretty much I want it to act like just another text box, but still provide options for the user to select when adding records. Here's my crappy combobox art to try and explain:
__________________________ ________
|dataset info here if it exists or blank |\/ |
-------------------------- ---------- ---------- --
|Options to select down here |
|if no data for that row |
| |
-------------------------- ---------- ---------- --
Xor,
I already tried that, doesn't work for manual items added to combobox I guess. I use the exact same code for a different combobox where I set the datasource to a table within my database. I am trying to avoid adding 2 extra tables with like 5 or 6 entries each if I can.
The combobox isn't used for SQL selection, only display existing data in my dataview. I just want to bind the combobox to one of the columns in my dataset so the data shows in the textbox area if it exists, and if it doesn't, they can use the options in the combobox to ensure proper data entry. Pretty much I want it to act like just another text box, but still provide options for the user to select when adding records. Here's my crappy combobox art to try and explain:
__________________________
|dataset info here if it exists or blank |\/ |
--------------------------
|Options to select down here |
|if no data for that row |
| |
--------------------------
Xor,
I already tried that, doesn't work for manual items added to combobox I guess. I use the exact same code for a different combobox where I set the datasource to a table within my database. I am trying to avoid adding 2 extra tables with like 5 or 6 entries each if I can.
ASKER
cboHairColor.DataBindings.
it will show the information, but is it the correct one to use?