Country Drop Down List in Asp.net
-
Hi All, I am creating a job portal in asp.net2.0 and mysql as backend.... I want to create a drop down list.... which displays the list of states according to the country selected in the first dropdownlist by the user.. i have used the sqldatasource and wen i am inserting the following select query => "select statename from state where countryname=@countryname"... its not working for the mysql :omg: ... though its working very fine if i use the database as MSSQL :) .... Plz help to solve this problem... Thanks in Advance.... :thumbsup: Regards, Rajan Arora :-D
-
Hi All, I am creating a job portal in asp.net2.0 and mysql as backend.... I want to create a drop down list.... which displays the list of states according to the country selected in the first dropdownlist by the user.. i have used the sqldatasource and wen i am inserting the following select query => "select statename from state where countryname=@countryname"... its not working for the mysql :omg: ... though its working very fine if i use the database as MSSQL :) .... Plz help to solve this problem... Thanks in Advance.... :thumbsup: Regards, Rajan Arora :-D
You can copy this code from any website for example nokri.com which having all combo of this type but if you need it originally then lot of site provide complete list of same. Code 1. Just fill all the entry into combo and Enable post back. 2. On Change of first combo fill the sate for country according to country name. 3. Then same for city Table CountryName, StateName, CityName