DaniWeb IT Discussion Community - View Single Post

Re: populate two dropdownlist

Dec 1st, 2007

You need to specify what country to use when you pull the data for the second drop down.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
string sql = "SELECT stateid,statename FROM countrystate where country_id='{0}' ";
SqlDataAdapter da1 = new SqlDataAdapter( string.Format(sql,countryid) );
string sql = "SELECT stateid,statename FROM countrystate where country_id='{0}' ";
SqlDataAdapter da1 = new SqlDataAdapter( string.Format(sql,countryid) );

This way it will only contain the states for that country.