?
Solved

Binding combobox selectedvalue to a dataview column

Posted on 2004-08-04
7
Medium Priority
?
969 Views
Last Modified: 2008-01-16
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("SelectedValue", 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.
0
Comment
Question by:bng0005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 1

Author Comment

by:bng0005
ID: 11720817
If I do:

cboHairColor.DataBindings.Add("Text", dv, "Hair")

it will show the information, but is it the correct one to use?
0
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11720999
Did you try ??

cboHairColor.DataSource = dv
cboHairColor.DisplayMember = "column to display"
cboHairColor.ValueMember = "Hair"

-Baan
0
 
LVL 1

Author Comment

by:bng0005
ID: 11721621
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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:bng0005
ID: 11722032
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?
0
 
LVL 18

Accepted Solution

by:
DotNetLover_Baan earned 1000 total points
ID: 11722187
cool... it is nice and clear to me now...

well, keep your comboBoxes... as they are (manually added). Then you can use DataReader with proper selection of Sql Query, and display the data in the TextBoxes.
eg:  Dim SqlStr as String = SELECT * From Emp WHERE State = '" & ComboBox1.SelectedItem.ToString() & "'"
0
 
LVL 1

Expert Comment

by:xorcrack
ID: 11722849
Use:
       
cboAccountStatus.DataBindings.Add("SelectedValue", dv, "hair")

or

cboAccountStatus.DataBindings.Add("SelectedText", dv, "hair")
0
 
LVL 1

Author Comment

by:bng0005
ID: 11727477
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question