Solved

country, state, city and zip code

Posted on 2011-03-12
5
1,169 Views
Last Modified: 2013-12-24
Hi,

Any one know all country names with states and their cities. If possible, then zip code as well. Any database(SQL Server, MySQL) or txt or cvs file?

I have to use with c# code.

Thanks
0
Comment
Question by:sindhuxyz
5 Comments
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 35118561
States I get from USPS. Countries I get from CIA world factbook. Zips ad cities I get from us census but it's a big list.

I haven't even tried to get other countries cities states and zips, it would be huge.
0
 
LVL 33

Expert Comment

by:Todd Gerbert
ID: 35119806
The US Postal Service sells a database you might find useful...it's name escapes me at the moment, but I'm sure you could find it on their website (http://www.usps.com/).
0
 
LVL 4

Expert Comment

by:mawni
ID: 35120268
ISO-3166-Country-Codes.xls
This is all world country list in Excel file, I don't remember the site which I downloaded this file from, I think it contained all the info you needed
0
 
LVL 4

Accepted Solution

by:
mawni earned 500 total points
ID: 35120277
0
 
LVL 5

Author Closing Comment

by:sindhuxyz
ID: 35227523
thanks
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Phishing is at the top of most security top 10 efforts you should be pursuing in 2016 and beyond. If you don't have phishing incorporated into your Security Awareness Program yet, now is the time. Phishers, and the scams they use, are only going to …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now