.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> SQL Query >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Countries List for asp.net control

Posted By:Nikhil Kumar       Posted Date: February 04, 2010    Points: 10    Category: SQL Query    URL: http://www.dotnetspark.com  

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 !!!


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend