List of Countries

RECIPE SOLUTION

(1) List of Countries in plain html

<select id="toCountry" style="margin:3px;" >

<option selected="selected" value="">Select Destination</option>

<option value="AF">Afghanistan</option>

<option value="AX">Aland islands</option>

<option value="AL">Albania</option>

<option value="DZ">Algeria</option>

<option value="USAS">American Samoa</option>

<option value="AD">Andorra</option>

<option value="AO">Angola</option>

<option value="AI">Anguilla</option>

<option value="AQ">Antarctica</option>

<option value="AG">Antigua/Barbuda</option>

<option value="AR">Argentina</option>

<option value="AM">Armenia</option>

<option value="AW">Aruba</option>

<option value="AC">Ascension</option>

<option value="AU">Australia</option>

<option value="AT">Austria</option>

<option value="AZ">Azerbaijan</option>

<option value="PT_ALIAS1">Azores</option>

<option value="BS">Bahamas</option>

<option value="BH">Bahrain</option>

<option value="ES_ALIAS1">Balearic Islands</option>

<option value="BD">Bangladesh</option>

<option value="BB">Barbados</option>

<option value="BY">Belarus</option>

<option value="BE">Belgium</option>

<option value="BZ">Belize</option>

<option value="BJ">Benin</option>

<option value="BM">Bermuda</option>

<option value="BQ_ALIAS3">BES Islands</option>

<option value="BT">Bhutan</option>

<option value="BO">Bolivia</option>

<option value="BQ_ALIAS4">Bonaire</option>

<option value="BA">Bosnia-Herz</option>

<option value="BW">Botswana</option>

<option value="BV">Bouvet Island</option>

<option value="VG">Br. Virgin Isl</option>

<option value="BR">Brazil</option>

<option value="IO">Br Ind Ocean Tr</option>

<option value="BN">Brunei</option>

<option value="BG">Bulgaria</option>

<option value="BF">Burkina Faso</option>

<option value="MM_ALIAS1">Burma</option>

<option value="BI">Burundi</option>

<option value="KH">Cambodia</option>

<option value="CM">Cameroon</option>

<option value="CM">Canada</option>

<option value="ES_ALIAS2">Canary Islands</option>

<option value="CV">Cape Verde</option>

<option value="KY">Cayman Islands</option>

<option value="CF">Central African Republic</option>

<option value="TD">Chad</option>

<option value="GB_ALIAS1">Channel Islands</option>

<option value="CL">Chile</option>

<option value="CN">China</option>

<option value="CX">Christmas Island</option>

<option value="CC">Cocos Islands</option>

<option value="CO">Colombia</option>

<option value="KM">Comoros</option>

<option value="CG">Congo</option>

<option value="CD">Congo Democratic Republic</option>

<option value="CK">Cook Islands</option>

<option value="FR_ALIAS1">Corsica</option>

<option value="CR">Costa Rica</option>

<option value="CI">Côte d'Ivoire</option>

<option value="HR">Croatia</option>

<option value="CU">Cuba</option>

<option value="CW">Curaçao</option>

<option value="CY">Cyprus</option>

<option value="CZ">Czech Republic</option>

<option value="DK">Denmark</option>

<option value="DJ">Djibouti</option>

<option value="DM">Dominica</option>

<option value="DO">Dominican Republic</option>

<option value="BQ">Dutch Caribbean</option>

<option value="TL_ALIAS1">East Timor</option>

<option value="EC">Ecuador</option>

<option value="EG">Egypt</option>

<option value="SV">El Salvador</option>

<option value="GB_ALIAS2">England</option>

<option value="GQ">Equatorial Guinea</option>

<option value="ER">Eritrea</option>

<option value="EE">Estonia</option>

<option value="ET">Ethiopia</option>

<option value="FK">Falkland Islands</option>

<option value="FO">Faroe Islands</option>

<option value="FJ">Fiji</option>

<option value="FI">Finland</option>

<option value="FR">France</option>

<option value="GF">French Guiana</option>

<option value="PF">French Polynesia</option>

<option value="TF">Fr S.Territory</option>

<option value="GA">Gabon</option>

<option value="GM">Gambia</option>

<option value="IL_ALIAS1">Gaza</option>

<option value="GE">Georgia</option>

<option value="GS">Georgia/Sandwich</option>

<option value="DE">Germany</option>

<option value="GH">Ghana</option>

<option value="GI">Gibraltar</option>

<option value="GB">Great Britain</option>

<option value="GR">Greece</option>

<option value="GL">Greenland</option>

<option value="GD">Grenada</option>

<option value="GP">Guadeloupe</option>

<option value="USGU">Guam</option>

<option value="GT">Guatemala</option>

<option value="GG">Guernsey</option>

<option value="GN">Guinea</option>

<option value="GW">Guinea-Bissau</option>

<option value="GY">Guyana</option>

<option value="HT">Haiti</option>

<option value="HM">Heard/McDonald</option>

<option value="NL_ALIAS1">Holland</option>

<option value="VA">Holy See</option>

<option value="HN">Honduras</option>

<option value="HK">Hong Kong</option>

<option value="HU">Hungary</option>

<option value="IS">Iceland</option>

<option value="IN">India</option>

<option value="ID">Indonesia</option>

<option value="IR">Iran</option>

<option value="IQ">Iraq</option>

<option value="IE">Ireland</option>

<option value="IM">Isle of Man</option>

<option value="IL">Israel</option>

<option value="IT">Italy</option>

<option value="JM">Jamaica</option>

<option value="JP">Japan</option>

<option value="JE">Jersey</option>

<option value="JO">Jordan</option>

<option value="KZ">Kazakhstan</option>

<option value="CC_ALIAS1">Keeling Islands</option>

<option value="KE">Kenya</option>

<option value="KI">Kiribati</option>

<option value="KR">Korea</option>

<option value="KP">Korea Dem Rep</option>

<option value="XZ_ALIAS1">Kosova</option>

<option value="XZ">Kosovo</option>

<option value="KW">Kuwait</option>

<option value="KG">Kyrgyzstan</option>

<option value="LA">Laos</option>

<option value="LV">Latvia</option>

<option value="LB">Lebanon</option>

<option value="LS">Lesotho</option>

<option value="LR">Liberia</option>

<option value="LY">Libya</option>

<option value="LI">Liechtenstein</option>

<option value="LT">Lithuania</option>

<option value="LU">Luxembourg</option>

<option value="MO">Macau</option>

<option value="MK">Macedonia</option>

<option value="MG">Madagascar</option>

<option value="PT_ALIAS2">Madiera</option>

<option value="MW">Malawi</option>

<option value="MY">Malaysia</option>

<option value="MV">Maldives</option>

<option value="ML">Mali</option>

<option value="MT">Malta</option>

<option value="FK_ALIAS1">Malvinas</option>

<option value="USMH">Marshall Islnds</option>

<option value="MQ">Martinique</option>

<option value="MR">Mauritania</option>

<option value="MU">Mauritius</option>

<option value="YT">Mayotte</option>

<option value="MX">Mexico</option>

<option value="USFM">Micronesia</option>

<option value="MD">Moldova</option>

<option value="MC">Monaco</option>

<option value="MN">Mongolia</option>

<option value="ME">Montenegro</option>

<option value="MS">Montserrat</option>

<option value="MA">Morocco</option>

<option value="MZ">Mozambique</option>

<option value="MM">Myanmar</option>

<option value="USMP">N.Mariana Island</option>

<option value="NA">Namibia</option>

<option value="NR">Nauru</option>

<option value="NP">Nepal</option>

<option value="NL">Netherlands</option>

<option value="NC">New Caledonia</option>

<option value="NZ">New Zealand</option>

<option value="NI">Nicaragua</option>

<option value="NE">Niger</option>

<option value="NG">Nigeria</option>

<option value="NU">Niue</option>

<option value="NF">Norfolk Island</option>

<option value="GB_ALIAS3">Northern Ireland</option>

<option value="KP_ALIAS1">North Korea</option>

<option value="NO">Norway</option>

<option value="OM">Oman</option>

<option value="PK">Pakistan</option>

<option value="USPW">Palau</option>

<option value="PS">Palestine</option>

<option value="PA">Panama</option>

<option value="PG">Papua N Guinea</option>

<option value="PY">Paraguay</option>

<option value="PE">Peru</option>

<option value="PH">Philippines</option>

<option value="PN">Pitcairn</option>

<option value="PL">Poland</option>

<option value="PT">Portugal</option>

<option value="ST_ALIAS1">Principe</option>

<option value="USPR">Puerto Rico</option>

<option value="QA">Qatar</option>

<option value="RE">Reunion</option>

<option value="RO">Romania</option>

<option value="RU">Russia</option>

<option value="RW">Rwanda</option>

<option value="ST">S.Tome/Principe</option>

<option value="BQ_ALIAS1">Saba</option>

<option value="SH">Saint Helena</option>

<option value="LC">Saint Lucia</option>

<option value="MF">Saint Martin</option>

<option value="WS">Samoa</option>

<option value="SM">San Marino</option>

<option value="SA">Saudi Arabia</option>

<option value="GB_ALIAS4">Scotland</option>

<option value="SN">Senegal</option>

<option value="RS">Serbia</option>

<option value="SC">Seychelles</option>

<option value="IT_ALIAS1">Sicily</option>

<option value="SL">Sierra Leone</option>

<option value="SG">Singapore</option>

<option value="BQ_ALIAS2">Sint Eustatius</option>

<option value="SX">Sint Maarten</option>

<option value="SK">Slovakia</option>

<option value="SI">Slovenia</option>

<option value="SB">Solomon Islands</option>

<option value="SO">Somalia</option>

<option value="ZA">South Africa</option>

<option value="KR_ALIAS1">South Korea</option>

<option value="SS">South Sudan</option>

<option value="ES">Spain</option>

<option value="ES_ALIAS3">Spanish North African Terr</option>

<option value="LK">Sri Lanka</option>

<option value="BL">St Barthelemy</option>

<option value="VI_ALIAS1">St Croix</option>

<option value="KN">St Kitts/Nevis</option>

<option value="PM">St Pierre &amp; Miq</option>

<option value="VI_ALIAS2">St Thomas</option>

<option value="VC">St Vincent/Gren</option>

<option value="SD">Sudan</option>

<option value="SR">Suriname</option>

<option value="SJ">Svalbard</option>

<option value="SZ">Swaziland</option>

<option value="SE">Sweden</option>

<option value="CH">Switzerland</option>

<option value="SY">Syria</option>

<option value="TW">Taiwan</option>

<option value="TJ">Tajikstan</option>

<option value="TZ">Tanzania</option>

<option value="TH">Thailand</option>

<option value="CN_ALIAS1">Tibet</option>

<option value="TL">Timor-Leste</option>

<option value="TG">Togo</option>

<option value="TK">Tokelau</option>

<option value="TO">Tonga</option>

<option value="VG_ALIAS1">Tortola</option>

<option value="TT">Trinidad/Tobago</option>

<option value="TA">Tristan da Cunh</option>

<option value="TN">Tunisia</option>

<option value="TR">Turkey</option>

<option value="TM">Turkmenistan</option>

<option value="TC">Turks &amp; Caicos</option>

<option value="TV">Tuvalu</option>

<option value="UG">Uganda</option>

<option value="UA">Ukraine</option>

<option value="AE">United Arab Emr</option>

<option value="GB_ALIAS5">United Kingdom</option>
 <option value="USA">United States</option>

<option value="UY">Uruguay</option>

<option value="USUM">US Minor Islnds</option>

<option value="USVI">US Virgin Isl</option>

<option value="UZ">Uzbekistan</option>

<option value="VU">Vanuatu</option>

<option value="VA_ALIAS1">Vatican</option>

<option value="VE">Venezuela</option>

<option value="VN">Vietnam</option>

<option value="GB_ALIAS6">Wales</option>

<option value="WF">Wallis &amp; Futuna</option>

<option value="EH">Western Sahara</option>

<option value="WS_ALIAS1">Western Samoa</option>

<option value="YE">Yemen</option>

<option value="CD_ALIAS1">Zaire</option>

<option value="ZM">Zambia</option>

<option value="ZW">Zimbabwe</option>

</select>

(2) List of countries in vb.net

 ddlCountry.Items.Add("Afghanistan")

        ddlCountry.Items.Add("Aland islands")

        ddlCountry.Items.Add("Albania")

        ddlCountry.Items.Add("Algeria")

        ddlCountry.Items.Add("American Samoa")

        ddlCountry.Items.Add("Andorra")

        ddlCountry.Items.Add("Angola")

        ddlCountry.Items.Add("Anguilla")

        ddlCountry.Items.Add("Antarctica")

        ddlCountry.Items.Add("Antigua/Barbuda")

        ddlCountry.Items.Add("Argentina")

        ddlCountry.Items.Add("Armenia")

        ddlCountry.Items.Add("Aruba")

        ddlCountry.Items.Add("Ascension")

        ddlCountry.Items.Add("Australia")

        ddlCountry.Items.Add("Austria")

        ddlCountry.Items.Add("Azerbaijan")

        ddlCountry.Items.Add("Azores")

        ddlCountry.Items.Add("Bahamas")

        ddlCountry.Items.Add("Bahrain")

        ddlCountry.Items.Add("Balearic Islands")

        ddlCountry.Items.Add("Bangladesh")

        ddlCountry.Items.Add("Barbados")

        ddlCountry.Items.Add("Belarus")

        ddlCountry.Items.Add("Belgium")

        ddlCountry.Items.Add("Belize")

        ddlCountry.Items.Add("Benin")

        ddlCountry.Items.Add("Bermuda")

        ddlCountry.Items.Add("BES Islands")

        ddlCountry.Items.Add("Bhutan")

        ddlCountry.Items.Add("Bolivia")

        ddlCountry.Items.Add("Bonaire")

        ddlCountry.Items.Add("Bosnia-Herz")

        ddlCountry.Items.Add("Botswana")

        ddlCountry.Items.Add("Bouvet Island")

        ddlCountry.Items.Add("Br. Virgin Isl")

        ddlCountry.Items.Add("Brazil")

        ddlCountry.Items.Add("Br Ind Ocean Tr")

        ddlCountry.Items.Add("Brunei")

        ddlCountry.Items.Add("Bulgaria")

        ddlCountry.Items.Add("Burkina Faso")

        ddlCountry.Items.Add("Burma")

        ddlCountry.Items.Add("Burundi")

        ddlCountry.Items.Add("Cambodia")

        ddlCountry.Items.Add("Cameroon")

        ddlCountry.Items.Add("Canada")

        ddlCountry.Items.Add("Canary Islands")

        ddlCountry.Items.Add("Cape Verde")

        ddlCountry.Items.Add("Cayman Islands")

        ddlCountry.Items.Add("Central African Republic")

        ddlCountry.Items.Add("Chad")

        ddlCountry.Items.Add("Channel Islands")

        ddlCountry.Items.Add("Chile")

        ddlCountry.Items.Add("China")

        ddlCountry.Items.Add("Christmas Island")

        ddlCountry.Items.Add("Cocos Islands")

        ddlCountry.Items.Add("Colombia")

        ddlCountry.Items.Add("Comoros")

        ddlCountry.Items.Add("Congo")

        ddlCountry.Items.Add("Congo Democratic Republic")

        ddlCountry.Items.Add("Cook Islands")

        ddlCountry.Items.Add("Corsica")

        ddlCountry.Items.Add("Costa Rica")

        ddlCountry.Items.Add("Côte d'Ivoire")

        ddlCountry.Items.Add("Croatia")

        ddlCountry.Items.Add("Cuba")

        ddlCountry.Items.Add("Curaçao")

        ddlCountry.Items.Add("Cyprus")

        ddlCountry.Items.Add("Czech Republic")

        ddlCountry.Items.Add("Denmark")

        ddlCountry.Items.Add("Djibouti")

        ddlCountry.Items.Add("Dominica")

        ddlCountry.Items.Add("Dominican Republic")

        ddlCountry.Items.Add("Dutch Caribbean")

        ddlCountry.Items.Add("East Timor")

        ddlCountry.Items.Add("Ecuador")

        ddlCountry.Items.Add("Egypt")

        ddlCountry.Items.Add("El Salvador")

        ddlCountry.Items.Add("England")

        ddlCountry.Items.Add("Equatorial Guinea")

        ddlCountry.Items.Add("Eritrea")

        ddlCountry.Items.Add("Estonia")

        ddlCountry.Items.Add("Ethiopia")

        ddlCountry.Items.Add("Falkland Islands")

        ddlCountry.Items.Add("Faroe Islands")

        ddlCountry.Items.Add("Fiji")

        ddlCountry.Items.Add("Finland")

        ddlCountry.Items.Add("France")

        ddlCountry.Items.Add("French Guiana")

        ddlCountry.Items.Add("French Polynesia")

        ddlCountry.Items.Add("Fr S.Territory")

        ddlCountry.Items.Add("Gabon")

        ddlCountry.Items.Add("Gambia")

        ddlCountry.Items.Add("Gaza")

        ddlCountry.Items.Add("Georgia")

        ddlCountry.Items.Add("Georgia/Sandwich")

        ddlCountry.Items.Add("Germany")

        ddlCountry.Items.Add("Ghana")

        ddlCountry.Items.Add("Gibraltar")

        ddlCountry.Items.Add("Great Britain")

        ddlCountry.Items.Add("Greece")

        ddlCountry.Items.Add("Greenland")

        ddlCountry.Items.Add("Grenada")

        ddlCountry.Items.Add("Guadeloupe")

        ddlCountry.Items.Add("Guam")

        ddlCountry.Items.Add("Guatemala")

        ddlCountry.Items.Add("Guernsey")

        ddlCountry.Items.Add("Guinea")

        ddlCountry.Items.Add("Guinea-Bissau")

        ddlCountry.Items.Add("Guyana")

        ddlCountry.Items.Add("Haiti")

        ddlCountry.Items.Add("Heard/McDonald")

        ddlCountry.Items.Add("Holland")

        ddlCountry.Items.Add("Holy See")

        ddlCountry.Items.Add("Honduras")

        ddlCountry.Items.Add("Hong Kong")

        ddlCountry.Items.Add("Hungary")

        ddlCountry.Items.Add("Iceland")

        ddlCountry.Items.Add("India")

        ddlCountry.Items.Add("Indonesia")

        ddlCountry.Items.Add("Iran")

        ddlCountry.Items.Add("Iraq")

        ddlCountry.Items.Add("Ireland")

        ddlCountry.Items.Add("Isle of Man")

        ddlCountry.Items.Add("Israel")

        ddlCountry.Items.Add("Italy")

        ddlCountry.Items.Add("Jamaica")

        ddlCountry.Items.Add("Japan")

        ddlCountry.Items.Add("Jersey")

        ddlCountry.Items.Add("Jordan")

        ddlCountry.Items.Add("Kazakhstan")

        ddlCountry.Items.Add("Keeling Islands")

        ddlCountry.Items.Add("Kenya")

        ddlCountry.Items.Add("Kiribati")

        ddlCountry.Items.Add("Korea")

        ddlCountry.Items.Add("Korea Dem Rep")

        ddlCountry.Items.Add("Kosova")

        ddlCountry.Items.Add("Kosovo")

        ddlCountry.Items.Add("Kuwait")

        ddlCountry.Items.Add("Kyrgyzstan")

        ddlCountry.Items.Add("Laos")

        ddlCountry.Items.Add("Latvia")

        ddlCountry.Items.Add("Lebanon")

        ddlCountry.Items.Add("Lesotho")

        ddlCountry.Items.Add("Liberia")

        ddlCountry.Items.Add("Libya")

        ddlCountry.Items.Add("Liechtenstein")

        ddlCountry.Items.Add("Lithuania")

        ddlCountry.Items.Add("Luxembourg")

        ddlCountry.Items.Add("Macau")

        ddlCountry.Items.Add("Macedonia")

        ddlCountry.Items.Add("Madagascar")

        ddlCountry.Items.Add("Madiera")

        ddlCountry.Items.Add("Malawi")

        ddlCountry.Items.Add("Malaysia")

        ddlCountry.Items.Add("Maldives")

        ddlCountry.Items.Add("Mali")

        ddlCountry.Items.Add("Malta")

        ddlCountry.Items.Add("Malvinas")

        ddlCountry.Items.Add("Marshall Islnds")

        ddlCountry.Items.Add("Martinique")

        ddlCountry.Items.Add("Mauritania")

        ddlCountry.Items.Add("Mauritius")

        ddlCountry.Items.Add("Mayotte")

        ddlCountry.Items.Add("Mexico")

        ddlCountry.Items.Add("Micronesia")

        ddlCountry.Items.Add("Moldova")

        ddlCountry.Items.Add("Monaco")

        ddlCountry.Items.Add("Mongolia")

        ddlCountry.Items.Add("Montenegro")

        ddlCountry.Items.Add("Montserrat")

        ddlCountry.Items.Add("Morocco")

        ddlCountry.Items.Add("Mozambique")

        ddlCountry.Items.Add("Myanmar")

        ddlCountry.Items.Add("N.Mariana Island")

        ddlCountry.Items.Add("Namibia")

        ddlCountry.Items.Add("Nauru")

        ddlCountry.Items.Add("Nepal")

        ddlCountry.Items.Add("Netherlands")

        ddlCountry.Items.Add("New Caledonia")

        ddlCountry.Items.Add("New Zealand")

        ddlCountry.Items.Add("Nicaragua")

        ddlCountry.Items.Add("Niger")

        ddlCountry.Items.Add("Nigeria")

        ddlCountry.Items.Add("Niue")

        ddlCountry.Items.Add("Norfolk Island")

        ddlCountry.Items.Add("Northern Ireland")

        ddlCountry.Items.Add("North Korea")

        ddlCountry.Items.Add("Norway")

        ddlCountry.Items.Add("Oman")

        ddlCountry.Items.Add("Pakistan")

        ddlCountry.Items.Add("Palau")

        ddlCountry.Items.Add("Palestine")

        ddlCountry.Items.Add("Panama")

        ddlCountry.Items.Add("Papua N Guinea")

        ddlCountry.Items.Add("Paraguay")

        ddlCountry.Items.Add("Peru")

        ddlCountry.Items.Add("Philippines")

        ddlCountry.Items.Add("Pitcairn")

        ddlCountry.Items.Add("Poland")

        ddlCountry.Items.Add("Portugal")

        ddlCountry.Items.Add("Principe")

        ddlCountry.Items.Add("Puerto Rico")

        ddlCountry.Items.Add("Qatar")

        ddlCountry.Items.Add("Reunion")

        ddlCountry.Items.Add("Romania")

        ddlCountry.Items.Add("Russia")

        ddlCountry.Items.Add("Rwanda")

        ddlCountry.Items.Add("S.Tome/Principe")

        ddlCountry.Items.Add("Saba")

        ddlCountry.Items.Add("Saint Helena")

        ddlCountry.Items.Add("Saint Lucia")

        ddlCountry.Items.Add("Saint Martin")

        ddlCountry.Items.Add("Samoa")

        ddlCountry.Items.Add("San Marino")

        ddlCountry.Items.Add("Saudi Arabia")

        ddlCountry.Items.Add("Scotland")

        ddlCountry.Items.Add("Senegal")

        ddlCountry.Items.Add("Serbia")

        ddlCountry.Items.Add("Seychelles")

        ddlCountry.Items.Add("Sicily")

        ddlCountry.Items.Add("Sierra Leone")

        ddlCountry.Items.Add("Singapore")

        ddlCountry.Items.Add("Sint Eustatius")

        ddlCountry.Items.Add("Sint Maarten")

        ddlCountry.Items.Add("Slovakia")

        ddlCountry.Items.Add("Slovenia")

        ddlCountry.Items.Add("Solomon Islands")

        ddlCountry.Items.Add("Somalia")

        ddlCountry.Items.Add("South Africa")

        ddlCountry.Items.Add("South Korea")

        ddlCountry.Items.Add("South Sudan")

        ddlCountry.Items.Add("Spain")

        ddlCountry.Items.Add("Spanish North African Terr")

        ddlCountry.Items.Add("Sri Lanka")

        ddlCountry.Items.Add("St Barthelemy")

        ddlCountry.Items.Add("St Croix")

        ddlCountry.Items.Add("St Kitts/Nevis")

        ddlCountry.Items.Add("St Pierre &amp; Miq")

        ddlCountry.Items.Add("St Thomas")

        ddlCountry.Items.Add("St Vincent/Gren")

        ddlCountry.Items.Add("Sudan")

        ddlCountry.Items.Add("Suriname")

        ddlCountry.Items.Add("Svalbard")

        ddlCountry.Items.Add("Swaziland")

        ddlCountry.Items.Add("Sweden")

        ddlCountry.Items.Add("Switzerland")

        ddlCountry.Items.Add("Syria")

        ddlCountry.Items.Add("Taiwan")

        ddlCountry.Items.Add("Tajikstan")

        ddlCountry.Items.Add("Tanzania")

        ddlCountry.Items.Add("Thailand")

        ddlCountry.Items.Add("Tibet")

        ddlCountry.Items.Add("Timor-Leste")

        ddlCountry.Items.Add("Togo")

        ddlCountry.Items.Add("Tokelau")

        ddlCountry.Items.Add("Tonga")

        ddlCountry.Items.Add("Tortola")

        ddlCountry.Items.Add("Trinidad/Tobago")

        ddlCountry.Items.Add("Tristan da Cunh")

        ddlCountry.Items.Add("Tunisia")

        ddlCountry.Items.Add("Turkey")

        ddlCountry.Items.Add("Turkmenistan")

        ddlCountry.Items.Add("Turks &amp; Caicos")

        ddlCountry.Items.Add("Tuvalu")

        ddlCountry.Items.Add("Uganda")

        ddlCountry.Items.Add("Ukraine")

        ddlCountry.Items.Add("United Arab Emr")

        ddlCountry.Items.Add("United Kingdom")
        ddlCountry.Items.Add("United States")

        ddlCountry.Items.Add("Uruguay")

        ddlCountry.Items.Add("US Minor Islnds")

        ddlCountry.Items.Add("US Virgin Isl")

        ddlCountry.Items.Add("Uzbekistan")

        ddlCountry.Items.Add("Vanuatu")

        ddlCountry.Items.Add("Vatican")

        ddlCountry.Items.Add("Venezuela")

        ddlCountry.Items.Add("Vietnam")

        ddlCountry.Items.Add("Wales")

        ddlCountry.Items.Add("Wallis &amp; Futuna")

        ddlCountry.Items.Add("Western Sahara")

        ddlCountry.Items.Add("Western Samoa")

        ddlCountry.Items.Add("Yemen")

        ddlCountry.Items.Add("Zaire")

        ddlCountry.Items.Add("Zambia")

        ddlCountry.Items.Add("Zimbabwe")

(3) LIST OF COUNTRIES using ListItem

   Public Sub FillCountries()

        Dim listOfCountries As String() = {

            "Afghanistan",

        "Aland islands",

        "Albania",

        "Algeria",

        "American Samoa",

        "Andorra",

        "Angola",

        "Anguilla",

        "Antarctica",

        "Antigua/Barbuda",

        "Argentina",

        "Armenia",

        "Aruba",

        "Ascension",

        "Australia",

        "Austria",

        "Azerbaijan",

        "Azores",

        "Bahamas",

        "Bahrain",

        "Balearic Islands",

        "Bangladesh",

        "Barbados",

        "Belarus",

        "Belgium",

        "Belize",

        "Benin",

        "Bermuda",

        "BES Islands",

        "Bhutan",

        "Bolivia",

        "Bonaire",

        "Bosnia-Herz",

        "Botswana",

        "Bouvet Island",

        "Br. Virgin Isl",

        "Brazil",

        "Br Ind Ocean Tr",

        "Brunei",

        "Bulgaria",

        "Burkina Faso",

        "Burma",

        "Burundi",

        "Cambodia",

        "Cameroon",

        "Canada",

        "Canary Islands",

        "Cape Verde",

        "Cayman Islands",

        "Central African Republic",

        "Chad",

        "Channel Islands",

        "Chile",

        "China",

        "Christmas Island",

        "Cocos Islands",

        "Colombia",

        "Comoros",

        "Congo",

        "Congo Democratic Republic",

        "Cook Islands",

        "Corsica",

        "Costa Rica",

        "Côte d'Ivoire",

        "Croatia",

        "Cuba",

        "Curaçao",

        "Cyprus",

        "Czech Republic",

        "Denmark",

        "Djibouti",

        "Dominica",

        "Dominican Republic",

        "Dutch Caribbean",

        "East Timor",

        "Ecuador",

        "Egypt",

        "El Salvador",

        "England",

        "Equatorial Guinea",

        "Eritrea",

        "Estonia",

        "Ethiopia",

        "Falkland Islands",

        "Faroe Islands",

        "Fiji",

        "Finland",

        "France",

        "French Guiana",

        "French Polynesia",

        "Fr S.Territory",

        "Gabon",

        "Gambia",

        "Gaza",

        "Georgia",

        "Georgia/Sandwich",

        "Germany",

        "Ghana",

        "Gibraltar",

        "Great Britain",

        "Greece",

        "Greenland",

        "Grenada",

        "Guadeloupe",

        "Guam",

        "Guatemala",

        "Guernsey",

        "Guinea",

        "Guinea-Bissau",

        "Guyana",

        "Haiti",

        "Heard/McDonald",

        "Holland",

        "Holy See",

        "Honduras",

        "Hong Kong",

        "Hungary",

        "Iceland",

        "India",

        "Indonesia",

        "Iran",

        "Iraq",

        "Ireland",

        "Isle of Man",

        "Israel",

        "Italy",

        "Jamaica",

        "Japan",

        "Jersey",

        "Jordan",

        "Kazakhstan",

        "Keeling Islands",

        "Kenya",

        "Kiribati",

        "Korea",

        "Korea Dem Rep",

        "Kosova",

        "Kosovo",

        "Kuwait",

        "Kyrgyzstan",

        "Laos",

        "Latvia",

        "Lebanon",

        "Lesotho",

        "Liberia",

        "Libya",

        "Liechtenstein",

        "Lithuania",

        "Luxembourg",

        "Macau",

        "Macedonia",

        "Madagascar",

        "Madiera",

        "Malawi",

        "Malaysia",

        "Maldives",

        "Mali",

        "Malta",

        "Malvinas",

        "Marshall Islnds",

        "Martinique",

        "Mauritania",

        "Mauritius",

        "Mayotte",

        "Mexico",

        "Micronesia",

        "Moldova",

        "Monaco",

        "Mongolia",

        "Montenegro",

        "Montserrat",

        "Morocco",

        "Mozambique",

        "Myanmar",

        "N.Mariana Island",

        "Namibia",

        "Nauru",

        "Nepal",

        "Netherlands",

        "New Caledonia",

        "New Zealand",

        "Nicaragua",

        "Niger",

        "Nigeria",

        "Niue",

        "Norfolk Island",

        "Northern Ireland",

        "North Korea",

        "Norway",

        "Oman",

        "Pakistan",

        "Palau",

        "Palestine",

        "Panama",

        "Papua N Guinea",

        "Paraguay",

        "Peru",

        "Philippines",

        "Pitcairn",

        "Poland",

        "Portugal",

        "Principe",

        "Puerto Rico",

        "Qatar",

        "Reunion",

        "Romania",

        "Russia",

        "Rwanda",

        "S.Tome/Principe",

        "Saba",

        "Saint Helena",

        "Saint Lucia",

        "Saint Martin",

        "Samoa",

        "San Marino",

        "Saudi Arabia",

        "Scotland",

        "Senegal",

        "Serbia",

        "Seychelles",

        "Sicily",

        "Sierra Leone",

        "Singapore",

        "Sint Eustatius",

        "Sint Maarten",

        "Slovakia",

        "Slovenia",

        "Solomon Islands",

        "Somalia",

        "South Africa",

        "South Korea",

        "South Sudan",

        "Spain",

        "Spanish North African Terr",

        "Sri Lanka",

        "St Barthelemy",

        "St Croix",

        "St Kitts/Nevis",

        "St Pierre &amp; Miq",

        "St Thomas",

        "St Vincent/Gren",

        "Sudan",

        "Suriname",

        "Svalbard",

        "Swaziland",

        "Sweden",

        "Switzerland",

        "Syria",

        "Taiwan",

        "Tajikstan",

        "Tanzania",

        "Thailand",

        "Tibet",

        "Timor-Leste",

        "Togo",

        "Tokelau",

        "Tonga",

        "Tortola",

        "Trinidad/Tobago",

        "Tristan da Cunh",

        "Tunisia",

        "Turkey",

        "Turkmenistan",

        "Turks &amp; Caicos",

        "Tuvalu",

        "Uganda",

        "Ukraine",

        "United Arab Emr",

        "United Kingdom",
        "United States",

        "Uruguay",

        "US Minor Islnds",

        "US Virgin Isl",

        "Uzbekistan",

        "Vanuatu",

        "Vatican",

        "Venezuela",

        "Vietnam",

        "Wales",

        "Wallis &amp; Futuna",

        "Western Sahara",

        "Western Samoa",

        "Yemen",

        "Zaire",

        "Zambia",

        "Zimbabwe"}

        For Each s As String In listOfCountries

            Dim li As New ListItem

            li.Value = s

            li.Text = s

            If s.Equals("Canada") Then

                li.Selected = True

            End If

            ddlCountry.Items.Add(li)

            ddlEmployerCountry.Items.Add(li)

        Next

    End Sub

Prevent Page from "jumping" on submit

One Solution:

<script type="text/javascript">

          window.scrollTo = function (x, y) {

              return true;

          }

</script>

Logout when using ASP.NET memberships

What are we cooking today?

Logout when using ASP.NET memberships

RECIPE

  Protected Sub lnkLogout_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkLogout.Click

        FormsAuthentication.SignOut()

        Response.Redirect(FormsAuthentication.LoginUrl)

    

  End Sub

Export from generic list of Objects to Excel (skipping provided column names)

What are we cooking today?

Export from generic list to Excel (skipping provided column names)

RECIPE

 Public Sub ExportToExcelFromList(fileName As String, listAID As List(Of AppInfoDay), Optional strArrListToSkip As String() = Nothing)

        'The Clear method erases any buffered HTML output.

        HttpContext.Current.Response.Clear()

        'The AddHeader method adds a new HTML header and value to the response sent to the client.

        HttpContext.Current.Response.AddHeader("content-disposition", String.Format("attachment; filename={0}", fileName & ".xls"))

        'The ContentType property specifies the HTTP content type for the response.

        HttpContext.Current.Response.ContentType = "application/ms-excel"

        'Implements a TextWriter for writing information to a string. The information is stored in an underlying StringBuilder.

        Using sw As New StringWriter()

            'Writes markup characters and text to an ASP.NET server control output stream. This class provides formatting capabilities that ASP.NET server controls use when rendering markup to clients.

            Using htw As New HtmlTextWriter(sw)

                '  Create a form to contain the List

                Dim table As New Table()

                Dim row As New TableRow()

                '---ADD COLS HEADER BASED ON OBJECT PROPERTIES

                For Each proinfo As PropertyInfo In New AppInfoDay().[GetType]().GetProperties()

                    '---SKIP UNDESIRED COLUMNS

                    If strArrListToSkip.Contains(proinfo.Name) Then

                        Continue For

                    Else

                        Dim hcell As New TableHeaderCell()

                        hcell.Text = proinfo.Name

                        row.Cells.Add(hcell)

                    End If

                Next

                table.Rows.Add(row)

                '---ADD ROWS WITH DATA

                For Each aid As AppInfoDay In listAID

                    Dim newRow As New TableRow()

                    For Each proinfo As PropertyInfo In aid.[GetType].GetProperties()

                        If strArrListToSkip.Contains(proinfo.Name) Then

                            Continue For

                        Else

                            Dim NewCell As New TableCell()

                            NewCell.Text = proinfo.GetValue(aid, Nothing).ToString()

                            newRow.Cells.Add(NewCell)

                        End If

                    Next

                    table.Rows.Add(newRow)

                Next

                '  render the table into the htmlwriter

                table.RenderControl(htw)

                '  render the htmlwriter into the response

                HttpContext.Current.Response.Write(sw.ToString())

                HttpContext.Current.Response.[End]()

            End Using

        End Using

    End Sub

 Sample code obtained from this link

Padding an string with a character (n times) in SQL Server

What are we cooking today?

Padding an string with a character (n times) in SQL Server

RECIPE

Declare @myString as varchar(10)

set @myString = '1234567'

select  RIGHT(REPLICATE('0', 10)

+ CAST(@mystring AS VARCHAR(10)), 10) PaddedResult

RESULT:

0001234567

Loading a dropdownlist from an XML file

What are we cooking today?

One Way of loading a dropdownlist from an XML file (sample: reading dates from an XML file)

RECIPE

The XML looks like:

<?xml version="1.0" encoding="utf-8" ?> <dates> <LocationA> <date>February 17, 2012</date> <date>March 29, 2012</date> <date>April 26, 2012</date> </LocationA> <LocationB> <date>March 29, 2012</date> <date>April 26, 2012</date> </LocationB> </dates>

The procedure:

Public Sub LoadDatesFromXMLFile(ByVal strOption As String) Try Dim doc As XDocument = XDocument.Load(MapPath("MyFile.xml")) If strOption = " LocationA " Then For Each element As XElement In doc.Descendants(" LocationA ") For Each XmlNode In element.Descendants("date") ddlAvailableDates.Items.Add(XmlNode.Value) Next Next Else For Each element As XElement In doc.Descendants("LocationB") For Each XmlNode In element.Descendants("date") ddlAvailableDates.Items.Add(XmlNode.Value) Next Next End If Catch ex As Exception lblError.Text = ex.Message End Try End Sub

Sorting a dropdownlist in VB.net

What are we cooking today?

One Way of Sorting a dropdownlist in VB.net

RECIPE

The Procedure

    Private Sub SortDropDown(ByVal ddl As DropDownList)

        '---Get listItems from dropDownList

        Dim ddlList As New ArrayList

        For Each li As ListItem In ddl.Items

            ddlList.Add(li)

        Next

        '---Sort arraylist

        ddlList.Sort(New ListItemComparer)

        '---Copy sorted list back into the dropDownList

        ddl.Items.Clear()

        For Each li As ListItem In ddlList

            ddl.Items.Add(li)

        Next

    End Sub

    

The Icomparer: I am using this because a listitem has text and value, and we just want to order by the text, which could be a person's name or a product( the criteria could be also the value like price, personId, year...)

 Public Class ListItemComparer : Implements IComparer

    Public Function Compare(ByVal x As Object, _

          ByVal y As Object) As Integer _

          Implements IComparer.Compare

        Dim a As ListItem = x

        Dim b As ListItem = y

        Dim c As New CaseInsensitiveComparer

        Return c.Compare(a.Text, b.Text)

    End Function

End Class