i have problem with comboboxes
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...
Who is Participating?
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
http://codeproject.com/cs/miscctrl/valuemembersample.asp