Dropdownlist values based on another dropdown list
<p>I have a dropdownlist control in which i have added two list items.Both these list items are added manually by me and not from any database.Based on the selection i would like to show another dropdownlist which has a sqldatasource.</p>

<p>I am able to accomplish this if my intial dropdownlist source is also from a database
how do i accomplish this from reading the value of the dropdownlist and populating another dropdown based on the selected value</p>

<p>The second dropdownlist that needs to be populated is going to vary(from differant tables) based on the selected value in the first dropdownlist</p>

<p>Need direction ideas please</p>

<p>Thanks</p>
