Here is table ready to be insert in country table after that you can bind your control which will show the countries |
Create table Country (CountryName char(50), Nationality char(50))
// Now insert run a this insert queries
INSERT INTO Country VALUES ('Afghanistan','Afghan')
INSERT INTO Country VALUES ('Albania','Albanian')
INSERT INTO Country VALUES ('Algeria','Algerian')
INSERT INTO Country VALUES ('Andorra','Andorran')
INSERT INTO Country VALUES ('Angola','Angolan')
INSERT INTO Country VALUES ('Antigua and Barbuda','Antiguans, Barbudans')
INSERT INTO Country VALUES ('Argentina','Argentinean')
INSERT INTO Country VALUES ('Armenia','Armenian')
INSERT INTO Country VALUES ('Australia','Australian')
INSERT INTO Country VALUES ('Austria','Austrian')
INSERT INTO Country VALUES ('Azerbaijan','Azerbaijani')
INSERT INTO Country VALUES ('The Bahamas','Bahamian')
INSERT INTO Country VALUES ('Bahrain','Bahraini')
INSERT INTO Country VALUES ('Bangladesh','Bangladeshi')
INSERT INTO Country VALUES ('Barbados','Barbadian')
INSERT INTO Country VALUES ('Belarus','Belarusian')
INSERT INTO Country VALUES ('Belgium','Belgian')
INSERT INTO Country VALUES ('Belize','Belizean')
INSERT INTO Country VALUES ('Benin','Beninese')
INSERT INTO Country VALUES ('Bhutan','Bhutanese')
INSERT INTO Country VALUES ('Bolivia','Bolivian')
INSERT INTO Country VALUES ('Bosnia and Herzegovina','Bosnian, Herzegovinian')
INSERT INTO Country VALUES ('Botswana','Motswana (singular), Batswana (plural)')
INSERT INTO Country VALUES ('Brazil','Brazilian')
INSERT INTO Country VALUES ('Brunei','Bruneian')
INSERT INTO Country VALUES ('Bulgaria','Bulgarian')
INSERT INTO Country VALUES ('Burkina Faso','Burkinabe')
INSERT INTO Country VALUES ('Burundi','Burundian')
INSERT INTO Country VALUES ('Cambodia','Cambodian')
INSERT INTO Country VALUES ('Cameroon','Cameroonian')
INSERT INTO Country VALUES ('Canada','Canadian')
INSERT INTO Country VALUES ('Cape Verde','Cape Verdian')
INSERT INTO Country VALUES ('Central African Republic','Central African')
INSERT INTO Country VALUES ('Chad','Chadian')
INSERT INTO Country VALUES ('Chile','Chilean')
INSERT INTO Country VALUES ('China','Chinese')
INSERT INTO Country VALUES ('Colombia','Colombian')
INSERT INTO Country VALUES ('Comoros','Comoran')
INSERT INTO Country VALUES ('Congo, Republic of the','Congolese')
INSERT INTO Country VALUES ('Congo, Democratic Republic of the','Congolese')
INSERT INTO Country VALUES ('Costa Rica','Costa Rican')
INSERT INTO Country VALUES ('Cote d''Ivoire','Ivorian')
INSERT INTO Country VALUES ('Croatia','Croatian')
INSERT INTO Country VALUES ('Cuba','Cuban')
INSERT INTO Country VALUES ('Cyprus','Cypriot')
INSERT INTO Country VALUES ('Czech Republic','Czech')
INSERT INTO Country VALUES ('Denmark','Danish')
INSERT INTO Country VALUES ('Djibouti','Djibouti')
INSERT INTO Country VALUES ('Dominica','Dominican')
INSERT INTO Country VALUES ('Dominican Republic','Dominican')
INSERT INTO Country VALUES ('East Timor','East Timorese')
INSERT INTO Country VALUES ('Ecuador','Ecuadorean')
INSERT INTO Country VALUES ('Egypt','Egyptian')
INSERT INTO Country VALUES ('El Salvador','Salvadoran')
INSERT INTO Country VALUES ('Equatorial Guinea','Equatorial Guinean')
INSERT INTO Country VALUES ('Eritrea','Eritrean')
INSERT INTO Country VALUES ('Estonia','Estonian')
INSERT INTO Country VALUES ('Ethiopia','Ethiopian')
INSERT INTO Country VALUES ('Fiji','Fijian')
INSERT INTO Country VALUES ('Finland','Finnish')
INSERT INTO Country VALUES ('France','French')
INSERT INTO Country VALUES ('Gabon','Gabonese')
INSERT INTO Country VALUES ('The Gambia','Gambian')
INSERT INTO Country VALUES ('Georgia','Georgian')
INSERT INTO Country VALUES ('Germany','German')
INSERT INTO Country VALUES ('Ghana','Ghanaian')
INSERT INTO Country VALUES ('Greece','Greek')
INSERT INTO Country VALUES ('Grenada','Grenadian')
INSERT INTO Country VALUES ('Guatemala','Guatemalan')
INSERT INTO Country VALUES ('Guinea','Guinean')
INSERT INTO Country VALUES ('Guinea-Bissau','Guinea-Bissauan')
INSERT INTO Country VALUES ('Guyana','Guyanese')
INSERT INTO Country VALUES ('Haiti','Haitian')
INSERT INTO Country VALUES ('Honduras','Honduran')
INSERT INTO Country VALUES ('Hungary','Hungarian')
INSERT INTO Country VALUES ('Iceland','Icelander')
INSERT INTO Country VALUES ('India','Indian')
INSERT INTO Country VALUES ('Indonesia','Indonesian')
INSERT INTO Country VALUES ('Iran','Iranian')
INSERT INTO Country VALUES ('Iraq','Iraqi')
INSERT INTO Country VALUES ('Ireland','Irish')
INSERT INTO Country VALUES ('Israel','Israeli')
INSERT INTO Country VALUES ('Italy','Italian')
INSERT INTO Country VALUES ('Jamaica','Jamaican')
INSERT INTO Country VALUES ('Japan','Japanese')
INSERT INTO Country VALUES ('Jordan','Jordanian')
INSERT INTO Country VALUES ('Kazakhstan','Kazakhstani')
INSERT INTO Country VALUES ('Kenya','Kenyan')
INSERT INTO Country VALUES ('Kiribati','I-Kiribati')
INSERT INTO Country VALUES ('Korea, North','North Korean')
INSERT INTO Country VALUES ('Korea, South','South Korean')
INSERT INTO Country VALUES ('Kuwait','Kuwaiti')
INSERT INTO Country VALUES ('Kyrgyz Republic','Kirghiz')
INSERT INTO Country VALUES ('Laos','Laotian')
INSERT INTO Country VALUES ('Latvia','Latvian')
INSERT INTO Country VALUES ('Lebanon','Lebanese')
INSERT INTO Country VALUES ('Lesotho','Mosotho')
INSERT INTO Country VALUES ('Liberia','Liberian')
INSERT INTO Country VALUES ('Libya','Libyan')
INSERT INTO Country VALUES ('Liechtenstein','Liechtensteiner')
INSERT INTO Country VALUES ('Lithuania','Lithuanian')
INSERT INTO Country VALUES ('Luxembourg','Luxembourger')
INSERT INTO Country VALUES ('Macedonia','Macedonian')
INSERT INTO Country VALUES ('Madagascar','Malagasy')
INSERT INTO Country VALUES ('Malawi','Malawian')
INSERT INTO Country VALUES ('Malaysia','Malaysian')
INSERT INTO Country VALUES ('Maldives','Maldivan')
INSERT INTO Country VALUES ('Mali','Malian')
INSERT INTO Country VALUES ('Malta','Maltese')
INSERT INTO Country VALUES ('Marshall Islands','Marshallese')
INSERT INTO Country VALUES ('Mauritania','Mauritanian')
INSERT INTO Country VALUES ('Mauritius','Mauritian')
INSERT INTO Country VALUES ('Mexico','Mexican')
INSERT INTO Country VALUES ('Federated States of Micronesia','Micronesian')
INSERT INTO Country VALUES ('Moldova','Moldovan')
INSERT INTO Country VALUES ('Monaco','Monegasque')
INSERT INTO Country VALUES ('Mongolia','Mongolian')
INSERT INTO Country VALUES ('Morocco','Moroccan')
INSERT INTO Country VALUES ('Mozambique','Mozambican')
INSERT INTO Country VALUES ('Myanmar (Burma)','Burmese')
INSERT INTO Country VALUES ('Namibia','Namibian')
INSERT INTO Country VALUES ('Nauru','Nauruan')
INSERT INTO Country VALUES ('Nepal','Nepalese')
INSERT INTO Country VALUES ('Netherlands','Dutch')
INSERT INTO Country VALUES ('New Zealand','New Zealander')
INSERT INTO Country VALUES ('Nicaragua','Nicaraguan')
INSERT INTO Country VALUES ('Niger','Nigerien')
INSERT INTO Country VALUES ('Nigeria','Nigerian')
INSERT INTO Country VALUES ('Norway','Norwegian')
INSERT INTO Country VALUES ('Oman','Omani')
INSERT INTO Country VALUES ('Pakistan','Pakistani')
INSERT INTO Country VALUES ('Palau','Palauan')
INSERT INTO Country VALUES ('Panama','Panamanian')
INSERT INTO Country VALUES ('Papua New Guinea','Papua New Guinean')
INSERT INTO Country VALUES ('Paraguay','Paraguayan')
INSERT INTO Country VALUES ('Peru','Peruvian')
INSERT INTO Country VALUES ('Philippines','Filipino')
INSERT INTO Country VALUES ('Poland','Polish')
INSERT INTO Country VALUES ('Portugal','Portuguese')
INSERT INTO Country VALUES ('Qatar','Qatari')
INSERT INTO Country VALUES ('Romania','Romanian')
INSERT INTO Country VALUES ('Russia','Russian')
INSERT INTO Country VALUES ('Rwanda','Rwandan')
INSERT INTO Country VALUES ('Saint Kitts and Nevis','Kittian and Nevisian')
INSERT INTO Country VALUES ('Saint Lucia','Saint Lucian')
INSERT INTO Country VALUES ('Samoa','Samoan')
INSERT INTO Country VALUES ('San Marino','Sammarinese')
INSERT INTO Country VALUES ('Sao Tome and Principe','Sao Tomean')
INSERT INTO Country VALUES ('Saudi Arabia','Saudi Arabian')
INSERT INTO Country VALUES ('Senegal','Senegalese')
INSERT INTO Country VALUES ('Serbia and Montenegro','Serbian')
INSERT INTO Country VALUES ('Seychelles','Seychellois')
INSERT INTO Country VALUES ('Sierra Leone','Sierra Leonean')
INSERT INTO Country VALUES ('Singapore','Singaporean')
INSERT INTO Country VALUES ('Slovakia','Slovak')
INSERT INTO Country VALUES ('Slovenia','Slovene')
INSERT INTO Country VALUES ('Solomon Islands','Solomon Islander')
INSERT INTO Country VALUES ('Somalia','Somali')
INSERT INTO Country VALUES ('South Africa','South African')
INSERT INTO Country VALUES ('Spain','Spanish')
INSERT INTO Country VALUES ('Sri Lanka','Sri Lankan')
INSERT INTO Country VALUES ('Sudan','Sudanese')
INSERT INTO Country VALUES ('Suriname','Surinamer')
INSERT INTO Country VALUES ('Swaziland','Swazi')
INSERT INTO Country VALUES ('Sweden','Swedish')
INSERT INTO Country VALUES ('Switzerland','Swiss')
INSERT INTO Country VALUES ('Syria','Syrian')
INSERT INTO Country VALUES ('Taiwan','Taiwanese')
INSERT INTO Country VALUES ('Tajikistan','Tadzhik')
INSERT INTO Country VALUES ('Tanzania','Tanzanian')
INSERT INTO Country VALUES ('Thailand','Thai')
INSERT INTO Country VALUES ('Togo','Togolese')
INSERT INTO Country VALUES ('Tonga','Tongan')
INSERT INTO Country VALUES ('Trinidad and Tobago','Trinidadian')
INSERT INTO Country VALUES ('Tunisia','Tunisian')
INSERT INTO Country VALUES ('Turkey','Turkish')
INSERT INTO Country VALUES ('Turkmenistan','Turkmen')
INSERT INTO Country VALUES ('Tuvalu','Tuvaluan')
INSERT INTO Country VALUES ('Uganda','Ugandan')
INSERT INTO Country VALUES ('Ukraine','Ukrainian')
INSERT INTO Country VALUES ('United Arab Emirates','Emirian')
INSERT INTO Country VALUES ('United Kingdom','British')
INSERT INTO Country VALUES ('United States','American')
INSERT INTO Country VALUES ('Uruguay','Uruguayan')
INSERT INTO Country VALUES ('Uzbekistan','Uzbekistani')
INSERT INTO Country VALUES ('Vanuatu','Ni-Vanuatu')
INSERT INTO Country VALUES ('Vatican City (Holy See)','none')
INSERT INTO Country VALUES ('Venezuela','Venezuelan')
INSERT INTO Country VALUES ('Vietnam','Vietnamese')
INSERT INTO Country VALUES ('Yemen','Yemeni')
INSERT INTO Country VALUES ('Zambia','Zambian')
INSERT INTO Country VALUES ('Zimbabwe','Zimbabwean')
Thanks !!!
|