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