user controls

Question

hi i have 2 user controls state and city(both drop downs) when i select state user control all related cities in that state should be filled in city drop down how to do it please help

Anil Kumar · Answer

What benefit you get by separating these two dependent controls in two user controls? I think both should be in single user control.

Senthilkumar · Answer

Hi You need to create the delegate event. That even should be included in the aspx.cs page you can enable the auto post back event. When delegate event written in the current page then you can bind the control based on the selection made in state.

sathish kumar · Answer

design sql table properly... like below[ Set primary key to city name] set autopostback property of both dropdownlist to TRUE india  chennai india  bangalore india madurai india delhi usa newyork usa wasington china Beijing Russia Mascow then fill country names in 1st dropdownlist on page load time....and double click 1st dropdownlist and write even as strSQL= select cityname from tablename where country='+1stDropdownlist.SelectedItem.tosting()+'; dataReader dr= cmd.executereader(); while(dr.read()) { citydropdown.Items.Add(dr[0].tostring()); } } u can do now i think....

sathish kumar · Answer

design sql table properly... like below[ Set primary key to city name] india  chennai india  bangalore india madurai india delhi usa newyork usa wasington china Beijing Russia Mascow then fill country names in 1st dropdownlist on page load time....and double click 1st dropdownlist and write even as select cityname from tablename where country='+1stDropdownlist.SelectedItem.tosting()+' fill t above code next dropdownlist... Hope it will be useful.....