Ready to get started with anonymous questions today? It's easy! Learn more.
Solved
i have problem with comboboxes
Posted on 2004-10-18
Dear Experts,
i need a solution to the above problem.
I have two combobox the first combobox called Periphery and the second called county.
I want to do this : When i select a specified periphery from the first combobox i want the second combobox to give the specified county which belongs to the periphery..
the periphery and county get the fields from the tables from the database..
Please i need help...
i need a solution to the above problem.
I have two combobox the first combobox called Periphery and the second called county.
I want to do this : When i select a specified periphery from the first combobox i want the second combobox to give the specified county which belongs to the periphery..
the periphery and county get the fields from the tables from the database..
Please i need help...
[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 Comments
U can see the following link. It shows the relationship between a combobox and a listbox. U can implement the same with two comboboxes
http://codeproject.com/cs/miscctrl/valuemembersample.asp
http://codeproject.com/cs/miscctrl/valuemembersample.asp
On SelectedIndexChanged of first ComboBox write the code to populate the other Combo
Private Sub ComboBox1_SelectedIndexCha
Dim DR As OleDbDataReader
Dim Cn As OleDbConnection = New OleDbConnection(YourConStr
Cn.Open()
Dim Cmd As OleDbCommand = New OleDbCommand("Select YourCol From Yourtable Where AnotherCol='" & ComboBox1.Text & "'", Cn)
DR = Cmd.ExecuteReader
Do While DR.Read
ComboBox2.Items.Add(DR(0))
Loop
DR.Close()
Cn.Close()
End Sub
However this will require a roundtrip to the dataBase so you can as well store all data in a dataTable and locally populate the combobox
Private Sub ComboBox1_SelectedIndexCha
Dim DR As OleDbDataReader
Dim Cn As OleDbConnection = New OleDbConnection(YourConStr
Cn.Open()
Dim Cmd As OleDbCommand = New OleDbCommand("Select YourCol From Yourtable Where AnotherCol='" & ComboBox1.Text & "'", Cn)
DR = Cmd.ExecuteReader
Do While DR.Read
ComboBox2.Items.Add(DR(0))
Loop
DR.Close()
Cn.Close()
End Sub
However this will require a roundtrip to the dataBase so you can as well store all data in a dataTable and locally populate the combobox
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to create and use a custom WaterMark textbox class. The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.
IMAGE OF WATERMARKS
STEPS
Create VB …
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place!
Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month11 days, 4 hours left to enroll
718 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.