how to create Country and state in ASP?

[NinjaTurtle]

how to create Country and state in ASP?
like Hotmail.com what they do in their sign up form, when user choose a country, the page will refresh and get the state records from database. any simple way to do this??

[Morgoth]

That will be in Javascript, you might want to try that forum. :)

[NinjaTurtle]

but all Javascrpt regarding this code is more or less is hardcoded or they will load all the record to Javascript array, i think that is quit hard , so that i think any one know how to combine using ASP + SQL Server + Javascript then is the best!!

[allida77]

Have a Country select box and onChange submit the form and pass the CountryID to a RS and fill the other select box if any states are found with that CountryID(This could be done with a couple of If statements). I would not write everything out clientside because that would be to much information. I know I didnt give a great explanation but hopefully it is a start.