Learning VB.Net - Clicked an item in a combo box and want to retrieve the corresponding data for that item

Question

0.00/5 (No votes)

See more:

Hi.

Learning VB.Net on my own. I'm connected to a database using ODBC and I'm able to retrieve data to fill in a combo box. When I click on an item in the combo box, I want to retrieve the corresponding data for the record I selected and fill in the required data fields on the form. I know how to fill in the remaining fields. I don't know how to get from clicking the combo box to retrieving the remaining data.

Can any one explain to me or provide me with the code to achieve this result?

Thanks.

Posted 25-Nov-11 8:09am

buzring

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)

OriginalGriff · Accepted Answer · 2011-11-25T08:26:00

Handle the SelectedIndexChanged event, and use the SelectedItem property:

VB

Private Sub myComboBox_SelectedIndexChanged(sender As Object, e As EventArgs) Handles myComboBox.SelectedIndexChanged
    Dim cb As ComboBox = TryCast(sender, ComboBox)
    If cb IsNot Nothing Then
        Dim item As String = DirectCast(cb.SelectedItem, String)
        ...
    End If
End Sub

I would strongly suggest you find a course, or a book - they present the material in a structured way, which should ensure that you do not miss important details as you go along. If you try to learn by "just doing it" I guarantee you will be missing lots as you go, and making things a lot harder for yourself than you need to!