combo box filter

[sigridish]

hi all! i have two combo box in my program

one has the subteam for example if you click the 1st combo box, the items would be
A1
A2
A3
A4
A5
what i want to happen is that if i chose A1 only the members of team A1 would appear in my combo box2. and by that, you need an sql statement. but how do i code that? can someone help me?

 

[jmcilhinney]

If the data is coming from a database, as it sounds like, then you have two choices:

1. Get only the data you need for the second list only when you need it.
2. Get all the data upfront and filter locally.

If the total amount of data is relatively small then I'd go with the second option. To that end:

Master/Detail (Parent/Child) Data-binding

 

[sigridish]

hi there! its not a small data. can you give me a starter code?

 

[sigridish]

well i tried this code

dim sql as string
sql = "Select * from finaltickettable where Subteam = '" & cboselect.Text & "'"
If cboselect.SelectedIndex = 0 Then
            cboselect2.Items.Add(sql)

whenever i execute the program, the data in my 2nd combo box is Select * from finaltickettable where Subteam = '" & cboselect.Text &

 

[jmcilhinney]

All you're doing is creating a String containing some SQL code. You have to actually execute that SQL code against the database to get the result set of the query. Presumably you already know how to do that because you would have done it to populate the first ComboBox. If you don't, check this out:

Retrieving and Saving Data in Databases

 

[sigridish]

actually the data in my first combo box is fixed. i placed it in the collection property.

 

[Allan Roy Balderama]

Hi sigridish,


In order to do that, you should understand first the process of creating SQL connection on your program.

Like what jmcilhinney said, you can check this link below for your to expand more your idea about this.
Retrieving and Saving Data in Databases - VBForums

We're hoping that this would help you... Regards

 

[sigridish]

hi allan! i believe you're a Filipino. since you're from paranaque. di ko maintindihan eh

 

[Allan Roy Balderama]

Yup I have a question lang. Bakit mo need na sql statement p gagamitin mo?? Do you have SQL Server service installed on your Local Machine?

Then may mga follow up questions pa ako..

 

[sigridish]

kasi pag select ko ng A1 dapat ang lalabas lang sa combo box2 is members ng A1. di ko pwede mano mano yun kasi bka mag dagdag ng members. OJT lang ako. hehe.

 

[Allan Roy Balderama]

Madali lang ung process na un, but before tayo pumunta dun. I'm asking lang sayo kung may installed SQL server service b sa PC mo???

San ka nagdadagdag ng mga members?? and pano mo na sila nailalagay sa team nila?

 

[sigridish]

ang gamit ko for my database is mysql query browser. meron dito sql server 2005 na nka install. pag gawa ko po ng database nilagay ko po sila dun

 

[jmcilhinney]

I'm glad that you guys have found some common ground but please stick to English on these forums, so everyone can help and everyone can be helped.

 

[sigridish]

sorry for that. wont happen again

 

[sigridish]

Hi jmcilhinney and allan! someone have solved this for me already. my friend from another forum helped me. thanks!