need to populate dataset with countryCode, countryName

Question

0.00/5 (No votes)

See more:

CSS

public class LookupService{

public static String[] countryCode = {
        "--","AP","EU","AD","AE","AF","AG","AI","AL","AM","AN","AO","AQ","AR",
        "AS","AT","AU","AW","AZ","BA","BB","BD","BE","BF","BG","BH","BI","BJ",
        "BM","BN","BO","BR","BS","BT","BV","BW","BY","BZ","CA","CC","CD","CF",
        "CG","CH","CI","CK","CL","CM","CN","CO","CR","CU","CV","CX","CY","CZ",
        "DE","DJ","DK","DM","DO","DZ","EC","EE","EG","EH","ER","ES","ET","FI",
        "FJ","FK","FM","FO","FR","FX","GA","GB","GD","GE","GF","GH","GI","GL",
        "GM","GN","GP","GQ","GR","GS","GT","GU","GW","GY","HK","HM","HN","HR",
        "HT","HU","ID","IE","IL","IN","IO","IQ","IR","IS","IT","JM","JO","JP",
        "KE","KG","KH","KI","KM","KN","KP","KR","KW","KY","KZ","LA","LB","LC",
        "LI","LK","LR","LS","LT","LU","LV","LY","MA","MC","MD","MG","MH","MK",
        "ML","MM","MN","MO","MP","MQ","MR","MS","MT","MU","MV","MW","MX","MY",
        "MZ","NA","NC","NE","NF","NG","NI","NL","NO","NP","NR","NU","NZ","OM",
        "PA","PE","PF","PG","PH","PK","PL","PM","PN","PR","PS","PT","PW","PY",
        "QA","RE","RO","RU","RW","SA","SB","SC","SD","SE","SG","SH","SI","SJ",
        "SK","SL","SM","SN","SO","SR","ST","SV","SY","SZ","TC","TD","TF","TG",
        "TH","TJ","TK","TM","TN","TO","TL","TR","TT","TV","TW","TZ","UA","UG",
        "UM","US","UY","UZ","VA","VC","VE","VG","VI","VN","VU","WF","WS","YE",
        "YT","RS","ZA","ZM","ME","ZW","A1","A2","O1","AX","GG","IM","JE","BL",
    "MF"};

    public static String[] countryName = {
            "N/A","Asia/Pacific Region","Europe","Andorra","United Arab Emirates",
            "Afghanistan","Antigua and Barbuda","Anguilla","Albania","Armenia",
            "Netherlands Antilles","Angola","Antarctica","Argentina","American Samoa",
            "Austria","Australia","Aruba","Azerbaijan","Bosnia and Herzegovina",
            "Barbados","Bangladesh","Belgium","Burkina Faso","Bulgaria","Bahrain",
            "Burundi","Benin","Bermuda","Brunei Darussalam","Bolivia","Brazil","Bahamas",
            "Bhutan","Bouvet Island","Botswana","Belarus","Belize","Canada",
            "Cocos (Keeling) Islands","Congo, The Democratic Republic of the",
            "Central African Republic","Congo","Switzerland","Cote D'Ivoire",
            "Cook Islands","Chile","Cameroon","China","Colombia","Costa Rica","Cuba",
            "Cape Verde","Christmas Island","Cyprus","Czech Republic","Germany",
            "Djibouti","Denmark","Dominica","Dominican Republic","Algeria","Ecuador",
            "Estonia","Egypt","Western Sahara","Eritrea","Spain","Ethiopia","Finland",
            "Fiji","Falkland Islands (Malvinas)","Micronesia, Federated States of",
            "Faroe Islands","France","France, Metropolitan","Gabon","United Kingdom",
            "Grenada","Georgia","French Guiana","Ghana","Gibraltar","Greenland","Gambia",
            "Guinea","Guadeloupe","Equatorial Guinea","Greece",
            "South Georgia and the South Sandwich Islands","Guatemala","Guam",
            "Guinea-Bissau","Guyana","Hong Kong","Heard Island and McDonald Islands",
            "Honduras","Croatia","Haiti","Hungary","Indonesia","Ireland","Israel","India",
            "British Indian Ocean Territory","Iraq","Iran, Islamic Republic of",
            "Iceland","Italy","Jamaica","Jordan","Japan","Kenya","Kyrgyzstan","Cambodia",
            "Kiribati","Comoros","Saint Kitts and Nevis",
            "Korea, Democratic People's Republic of","Korea, Republic of","Kuwait",
            "Cayman Islands","Kazakhstan","Lao People's Democratic Republic","Lebanon",
            "Saint Lucia","Liechtenstein","Sri Lanka","Liberia","Lesotho","Lithuania",
            "Luxembourg","Latvia","Libyan Arab Jamahiriya","Morocco","Monaco",
            "Moldova, Republic of","Madagascar","Marshall Islands",
            "Macedonia, the Former Yugoslav Republic of","Mali","Myanmar","Mongolia",
            "Macau","Northern Mariana Islands","Martinique","Mauritania","Montserrat",
            "Malta","Mauritius","Maldives","Malawi","Mexico","Malaysia","Mozambique",
            "Namibia","New Caledonia","Niger","Norfolk Island","Nigeria","Nicaragua",
            "Netherlands","Norway","Nepal","Nauru","Niue","New Zealand","Oman","Panama",
            "Peru","French Polynesia","Papua New Guinea","Philippines","Pakistan",
            "Poland","Saint Pierre and Miquelon","Pitcairn","Puerto Rico","" +
            "Palestinian Territory, Occupied","Portugal","Palau","Paraguay","Qatar",
            "Reunion","Romania","Russian Federation","Rwanda","Saudi Arabia",
            "Solomon Islands","Seychelles","Sudan","Sweden","Singapore","Saint Helena",
            "Slovenia","Svalbard and Jan Mayen","Slovakia","Sierra Leone","San Marino",
            "Senegal","Somalia","Suriname","Sao Tome and Principe","El Salvador",
            "Syrian Arab Republic","Swaziland","Turks and Caicos Islands","Chad",
            "French Southern Territories","Togo","Thailand","Tajikistan","Tokelau",
            "Turkmenistan","Tunisia","Tonga","Timor-Leste","Turkey","Trinidad and Tobago",
            "Tuvalu","Taiwan","Tanzania, United Republic of","Ukraine","Uganda",
            "United States Minor Outlying Islands","United States","Uruguay","Uzbekistan",
            "Holy See (Vatican City State)","Saint Vincent and the Grenadines",
            "Venezuela","Virgin Islands, British","Virgin Islands, U.S.","Vietnam",
            "Vanuatu","Wallis and Futuna","Samoa","Yemen","Mayotte","Serbia",
            "South Africa","Zambia","Montenegro","Zimbabwe","Anonymous Proxy",
            "Satellite Provider","Other",
        "Aland Islands","Guernsey","Isle of Man","Jersey","Saint Barthelemy",
        "Saint Martin"};

}

I would like to put this in a dataset
countryCode countryName

Posted 12-Feb-11 13:41pm

macupryk

Add a Solution

Comments

Albin Abel 12-Feb-11 23:28pm

First this I would like to ask how to match country code to country name, just by index? That may error prone when you modify the arrays. How @ modifying this to a dictionary. So that it will be easy to handle with a dataset or whatever

Abhinav S 13-Feb-11 2:18am

I agree with you totally.

macupryk 12-Feb-11 23:58pm

any help to start me off would be great.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-02-12T20:03:00

It looks like the country code and country names are already in order.

To start of, you can call both of them and loop though the count and insert the code and name into a dataset. Something like:

C#

DataTable dt = new DataTable();
dt.Columns.Add("CCode");
dt.Columns.Add("CName");

for(int i=0; i< cCode.Count ; ++i)
{
   // cCode is code string array 
   // cName is name string array
   dt.Rows.Add(cCode[i],cName[i]);  
}

Abhinav S · Answer 2 · 2011-02-12T20:19:00

Solution 3

Storing country code / name in an array may not be the best approach to do this.

If you are using a database, try creating for location code and name.
This will give you tons of flexibility besides making it more stable code to use.

Posted 12-Feb-11 20:19pm

Abhinav S