DropDownList Control problem!!

Question

hello Friends.

i had created cascading dropdownlist control for same as country/state/city

on page load event m retrieving values of those dropdownlist control..by select query

like...

ddlcountry.Text=dr[0].ToString();
ddlstate.Text=dr[1].ToString();
ddlcity.Text=dr[2].ToString();

on page load event i had filled country dropdownlist control....then on selectedindexchanged event of country dropdownlist control i had filled state dropdownlist control...and on selectedindexchanged event of state dropdownlist control the city dropdownlist control had filled..

problem is country dropdownlist control showing its value bt state & city did not...

tell me whr m doing wrong?!!

Kirtan Patel · Answer

Friend I have corrected your code Mistake Found Are Below :) + Database was Not Correctly Designed ( Relationships were not Exist and Some Field were not connected by foreign key as it should be ) + you were referring city with CityName instead of CityID in TestData + You have used global DataSet ds but Every Time when you call Fill method It Was Writing in Table[0] actually you have to create new Object Every time + any Some other Changes I have made Just Take a Look at code you will know it :) ----------------------------------------------------------------------------------------------------------------- Download Corrected Code From Here and please check  do you like this answer check box

kritika · Answer

ok...i got whr i was wrong..!!! infect i forgot abt conversion.....and abt database it was initially created without any relationship which i came to knw tht i forgot after u pointing out ma miskates.. thank a lot...

kritika · Answer

hey frnd.. i just uploaded file ..Test.rar plz tell me whr m going wrong? thanks.

Kirtan Patel · Answer

Hi Kritika  I know where you doin mistake .. just send me your Project Files(zip) in mail or Upload it to http://mediafire.com and mail me the download link of project at kirtan007@gmail.com :)