Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


Binding combobox selectedvalue to a dataview column

Posted on 2004-08-04
Medium Priority
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.
Question by:bng0005
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

Author Comment

ID: 11720817
If I do:

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

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

Expert Comment

ID: 11720999
Did you try ??

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


Author Comment

ID: 11721621
I fill the combobox options on the form load like this:


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

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


Author Comment

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?
LVL 18

Accepted Solution

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() & "'"

Expert Comment

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


cboAccountStatus.DataBindings.Add("SelectedText", dv, "hair")

Author Comment

ID: 11727477

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                           |
 |                                                          |


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.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
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…

648 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