ajax drop down auto populate from database

[yenom red]

i have a drop down list tied to a database called location.
what i hope to achieve is once a location is selected, my other drop down list will auto-populate a list of department in that location. how do i go about on connecting the two drop down list together so when location is changed, it connects to the appropriate row in the database?

[Frinavale]

The term for this is Cascading DropDownLists.

What you need to do is handle the SelectedIndex changed of the first DropDownList and populate the second one based on what the user selected.