الدول العربية و الجنسات

السلام عليكم

هذه قائمة تحتوي على اسماء معظم الدول بالعربي وبمقابلها الانجليزي .

اسبتدل اسم الجدول واسماء الحقول بما يناسبك

INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('افغانستان','Afghanistan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('البانيا','Albania')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الجزائر','Algeria')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اندورا','Andorra')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('انجولا','Angola')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('انتيجوا وباربودا','Antigua & Barbuda')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الارجنتين','Argentina')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ارمينيا','Armenia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('استراليا','Australia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('النمسا','Austria')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اذربيجان','Azerbaijan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر البهاما','The Bahamas')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('البحرين','Bahrain')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بنجلاديش','Bangladesh')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('باربادوس','Barbados')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بيلا روسيا','Belarus')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بلجيكا','Belgium')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بيليز','Belize')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بنين','Benin')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بوتان','Bhutan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بوليفيا','Bolivia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('البوسنة والهرسك','Bosnia & Herzegovina')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بوتسوانا','Botswana')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('البرازيل','Brazil')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بروناى','Brunei')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بلغاريا','Bulgaria')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بوركينا فاسو','Burkina Faso')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بوروندى','Burundi')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كمبوديا','Cambodia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الكاميرون','Cameroon')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كندا','Canada')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الرأس الاخضر','Cape Verde')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جمهورية افريقيا الوسطى','Central African Republic')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تشاد','Chad')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('شيلى','Chile')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الصين','China')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كولمبيا','Colombia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر الُقمـــر','Comoros')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جمهورية الكونغو','Republic of the Congo')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جمهورية الكونغو الديمقراطية','Democratic Republic of the Congo')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كوستاريكا','Costa Rica')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كوت ديفوار','Cote d''Ivoire')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كرواتيا','Croatia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كوبا','Cuba')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('قبرص','Cyprus')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جمهورية التشيك','Czech Republic')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الدنمارك','Denmark')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جيبوتى','Djibouti')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('دومينيكا','Dominica')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الدومينيكان','Dominican Republic')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تيمور الشرقية','East Timor')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الاكوادور','Ecuador')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مصر','Egypt')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('السلفادور','El Salvador')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('غينيا الاستوائية','Equatorial Guinea')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اريتريا','Eritrea')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('استونيا','Estonia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اثيوبيا','Ethiopia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر فيجى','Fiji')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('فنلندا','Finland')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('فرنسا','France')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الجابون','Gabon')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جامبيا','The Gambia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جورجيا','Georgia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('المانيا','Germany')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('غانا','Ghana')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اليونان','Greece')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جرانادا','Grenada')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جواتيمالا','Guatemala')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('غينيا','Guinea')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('غينيا بيساو','Guinea Bissau')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جويانا','Guyana')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('هايتى','Haiti')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('هندوراس','Honduras')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('المجر','Hungary')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ايسلندا','Iceland')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الهند','India')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اندونيسيا','Indonesia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ايران','Iran')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('العراق','Iraq')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ايرلندا','Ireland')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ايطاليا','Italy')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جاميكا','Jamaica')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اليابان','Japan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الاردن','Jordan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كازاخستان','Kazakhstan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كينيا','Kenya')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كيريباتى','Kiribati')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كوريا الشمالية','Korea, North')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('كوريا الجنوبية','Korea, South')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الكويت','Kuwait')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('قرغيزستان','Kyrgyzstan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('لاوس','Laos')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('لاتفيا','Latvia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ُلبنان','Lebanon')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ليسوتو','Lesotho')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ليبيريا','Liberia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ليبيا','Libya')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ليختنشتاين','Liechtenstein')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ليتوانيا','Lithuania')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('لوكسمبورج','Luxembourg')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مقدونيا','Macedonia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مدغشقر','Madagascar')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مالاوى','Malawi')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ماليزيا','Malaysia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر المالديف','Maldives')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مالى','Mali')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزيرة مالطا','Malta')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر مارشال','Marshall Islands')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('موريتانيا','Mauritania')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('موريشيوس','Mauritius')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('المكسيك','Mexico')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر مايكرونيزيا','Federated States of Micronesia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مولدوفيا','Moldova')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('امارة موناكو','Monaco')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('منغوليا','Mongolia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('مونتنيجرو','Montenegro')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('المغرب','Morocco')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('موزمبيق','Mozambique')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ميانمار (بورما)','Myanmar (Burma)')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ناميبيا','Namibia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ناورو','Nauru')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('نيبال','Nepal')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('هولندا','Netherlands')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('نيوزيلندا','New Zealand')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('نيكاراجوا','Nicaragua')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('النيجر','Niger')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('نيجيريا','Nigeria')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('النرويج','Norway')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سلطنة عًمان','Oman')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('باكستان','Pakistan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بالو','Palau')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بنما','Panama')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بابوا غينيا الجديدة','Papua New Guinea')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('باراجوى','Paraguay')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بيرو','Peru')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الفلبين','Philippines')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('بولندا','Poland')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('البرتغال','Portugal')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('قطر','Qatar')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('رومانيا','Romania')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('روسيا الاتحادية','Russia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('رواندا','Rwanda')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سان كيتس اند نيفز','Saint Kitts and Nevis')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سان لوتشيا','Saint Lucia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سان فنسن وجرينادينز','Saint Vincent and the Grenadines')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ساموا','Samoa')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سان مارينو','San Marino')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ساوتومى اند برنسيب','Sao Tome and Principe')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('السعودية','Saudi Arabia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('السنغال','Senegal')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('صربيا','Serbia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر سيشل','Seychelles')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سيراليون','Sierra Leone')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سنغافورة','Singapore')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سلوفاكيا','Slovakia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سلوفينيا','Slovenia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جزر سولومون','Solomon Islands')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الصومال','Somalia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('جنوب افريقيا','South Africa')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('إسبانيا','Spain')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سريلانكا','Sri Lanka')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('السودان','Sudan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سورينام','Suriname')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سوازيلاند','Swaziland')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('السويد','Sweden')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سويسرا','Switzerland')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('سوريا','Syria')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('طاجكستان','Tajikistan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تنزانيا','Tanzania')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تايلاند','Thailand')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('توجو','Togo')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تونجا','Tonga')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('ترينداد وتوباغو','Trinidad and Tobago')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تــــوِنس','Tunisia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تركيا','Turkey')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('تركمانستان','Turkmenistan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('توفالو','Tuvalu')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اوغندا','Uganda')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اوكرانيا','Ukraine')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الامارات العربية المتحدة','United Arab Emirates')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('المملكة المتحدة','United Kingdom')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الولايات المتحدة الامريكية','United States')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اورجواى','Uruguay')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اوزباكستان','Uzbekistan')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('فانواتو','Vanuatu')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('الفاتيكان','Vatican City (Holy Seed)')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('فنزويلا','Venezuela')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('فيتنام','Vietnam')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('اليمن','Yemen')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('زامبيا','Zambia')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('زيمبابوى','Zimbabwe')
INSERT INTO [ExpCountry] ([name],[nameEng])VALUES('فلسطين','Palestine')

شكرا اللك كتير

هدا تماما اللي بدي اياه...

بش شو مشان الجنسيات ، بالعربي الجنسية تختلف عن اسم البلد و كمان جنسية المذكر تختلف عن المؤنث ،

عندك حل ؟ اذا ما في طريقة ادخل الجنسيات بالجدول، كيف بقدر اعالج هالقصة بالكود ؟

وشكرا مرة تانية