Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

country, state, city and zip code

Posted on 2011-03-12
5
Medium Priority
?
1,733 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 39

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 2000 total points
ID: 35120277
0
 
LVL 5

Author Closing Comment

by:sindhuxyz
ID: 35227523
thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Cyberspace is the new townsquare.  Does the change from a physical space to a digital space spell doom and destruction or growth and prosperity.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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…
Suggested Courses

571 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