how can i select a item from combobox and get me the details that i want in another combobox?

Question

1.00/5 (1 vote)

See more:

Hello world!
i have a doubt...
my project "visual basic"

i have a comboBox, with information from databaseOracle,
that when my combobox.text receive the information i must select one of the options that was gives to me.

after i select the item from combobox.text, my other combo will be : combobox.enabled = true, and i will pike the item of combobox

problem: how can i select a item from combox and get me the details that i want in another combobox?

to understand better my program its like a stand car

If you help me,I will appreciate.

With best regards,
Nillo123.

Posted 5-Jul-13 1:46am

Nillo123

Add a Solution

Comments

Sadique KT 5-Jul-13 7:58am

pass selected text from combobox1 to database and retrieve the data for combobox2 frm DB.
You can use seleceted Index changed event or editvalue changed or any other events..

[no name] 5-Jul-13 8:38am

I have absolutely no idea what "a stand car" is but you need to research "cascading comboboxes"

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)

bhuvamehul · Accepted Answer · 2013-07-05T21:29:00

Double click on combobox in form design it will open combobox selected index change event for you.
In that event write code for retrieving data from database.
To get value of selected item of combobox:

VB

dim str as string =combobox1.selecteditem

and use it with select query in where clause, store that data in dataadapter and fill dataset

In below example I am using sql server database:
Example:

VB

Private Sub ComboBox1_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
       Dim str As String = ComboBox1.SelectedText

       Dim cn As New SqlConnection("Connection String")
       Dim cmd As New SqlCommand("Select subitem from ItemMaster where subitem='" + str + "'", cn)
       cn.Open()

       Dim da As New SqlDataAdapter(cmd)
       Dim ds As New DataSet
       da.Fill(ds)
       ComboBox2.DataSource = ds.Tables(0)

   End Sub