Adding value member to the combobox

Question

0.00/5 (No votes)

See more:

.NET3.5

In my application i am allowing user to select the user full name from the combobox, i m loading the combobox with user full name from user_details table from first and last name column with a space in between, now i want my user to perform a certain task when the user is selected , hence i am trying to add a value member for every item, and that would be the employee id of the corresponding name from the user_details table, hence i modified the query to return the full name and the empID, now i need to know the code that will help me to add the empID as the value member, i.e display member would be the full name and the corresponding value member would be the empID, please check the code. Thanks.

Using cn As New SqlClient.SqlConnection(sqlConnStr)
                cn.Open()
                Using cmd As New SqlCommand(strSQLOwner, cn)
                    Using pdrOwnr As SqlDataReader = cmd.ExecuteReader
                        While pdrOwnr.Read
                  cboOwner.Items.Add(pdrOwnr.Item(0)) ' full name'
                 cboOwner.ValueMember = pdrOwnr.Item(1)'empID '
                        End While
                    End Using
                End Using
            End Using

Posted 21-Aug-10 3:50am

souvikd

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

The Zetta · Answer 1 · 2010-08-21T04:19:00

well, that is not a good way to do that. my suggesstion would be using a dataset.

I'm not very familiar with VB syntax, so spare the syntax errors :

Using datasource As new DataSet()
Using adapter As new SqlDataAdapter(cmd)
   adapter.Fill(datasource)
End Using
cboOwner.DataSource = datasource.Tables[0]
cboOwner.DisplayMember = "full name"
cboOwner.ValueMember = "empID"
End Using

This way, you wont need a while, and you will reach your goal.

---------------------

Regards

H.Maadani