how to show all cities of a country when selected in dropdownlist

Please refer this article

Implement AJAX CascadingDropdown without Web Service in ASP.Net

AJAX cascading dropdownlist sample with database using ASP.Net

Dear Azim , my aim is not to cascade the dropdowns ... that i know already how to do, i want to know that how can i put all the cities of australia and newzeland in my database ... i know how to fetch the data from db, but from where and how can i get all the city names of australia and newzeland ... later on i will be needing pakistan's all cities ...

actually i found these links :

http://www.dyngeometry.com/web/Home.aspx

http://www.dotnetfunda.com/forums/show/10470/city-country-state-api

http://dev.maxmind.com/geoip/geoip2/geolite2/

http://www.worldcitiesdatabase.com/

http://www.worldcitiesdatabase.com/world-cities.aspx

but im unable to decide from where and how to get started ..

External links are blocked in my office. They might have given you the backup file of SQL database. You need to restore it. In your SQL server and use it.

Refer:

1. How to get a free Country State City database for SQL Server 2008
2. Download free Country State City SQL Server Database
3. Get SQL Server Database with list of Country State City