DDL Country State Code

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 ... though its working very fine if i use the database as MSSQL ....and i need it in MYSQL.....

Plz help to solve this problem...


Thanks in Advance....

Regards,
Rajan Arora

re: DDL Country State Code

Well, MySql is a different database management system than MS SQL Server. They require slightly different SQL queries to work....they also require different .NET controls to connect to them.

Please post your .NET code you're using to connect to/query the database so that we can see what you're doing.

-Frinny