January 17, 2004 at 7:32 am
Can someone check my logic here my main table I creared is at the buttom.
How can I implement this in C# or VB.NET or ADO.NET. Thanks. Also does any one have any t-sql scripts. That is large examples. Thank you.
-- signup.aspx Create Tables for dropdownlist
----------------------------------------------- 1
CREATE TABLE
Lookup_User_Title (
[TitleID]
varchar(10) primary key,
[TitleText]
varchar (10) not null
)
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Mr.','Mr.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Ms.','Ms.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Miss.','Miss.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Mrs.','Mrs.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Dr.','Dr.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('M.','M.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Mme.','Mme.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Mlle.','Mlle.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Prof.','Prof.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Rev.','Rev.')
GO
INSERT INTO
Lookup_User_Title(TitleID,TitleText) VALUES('Other','Other')
GO
----------------------------------------------- 2
CREATE TABLE
[Lookup_User_Gender] (
[GenderID]
integer identity primary key,
[GenderText]
varchar (50)
)
GO
INSERT
Lookup_User_Gender(GenderText) VALUES('Male')
INSERT
Lookup_User_Gender(GenderText) VALUES('Female')
GO
----------------------------------------------- 3
CREATE TABLE
Lookup_User_SecretWordType (
[SecretWordTypeID]
varchar(50) primary key,
[SecretWordTypeText]
varchar (50) not null
)
GO
INSERT INTO
Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What street did I grow up on?','What street did I grow up on?')
GO
INSERT INTO
Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What is the name of the high school I attended?','What is the name of the high school I attended?')
GO
INSERT INTO
Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What is my favorite type of music?','What is my favorite type of music?')
GO
INSERT INTO
Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What is my pet''s name?','What is my pet''s name?')
GO
----------------------------------------------- 4
CREATE TABLE
Lookup_User_StateProvince (
[StateProvinceID]
integer identity primary key,
[StateProvinceText]
varchar (50)
)
GO
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Not Applicable')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Alabama')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Alaska')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Army Post Office')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Arizona')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Arkansas')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('California')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('District of Columbia')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Delaware')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Florida')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Fleet Post Office')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Georgia')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Guam')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Hawaii')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Idaho')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Illinois')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Indiana')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Iowa')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Kansas')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Kentucky')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Louisiana')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Maine')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Maryland')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Massachusetts')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Michigan')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Minnesota')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Mississippi')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Missouri')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Montana')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Nebraska')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Nevada')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('New Hampshire')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('New Jersey')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('New Mexico')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('New York')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('North Carolina')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('North Dakota')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Ohio')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Oklahoma')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Oregon')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Pennsylvania')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Puerto Rico')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Rhode Island')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('South Carolina')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('South Dakota')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Tennessee')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Texas')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Utah')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Vermont')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('West Virginia')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Wisconsin')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Wyoming')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('British Columbia')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Manitoba')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('New Brunswick')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Newfoundland')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Northwest Territories')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Nova Scotia')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Nunavut')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Ontario')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Prince Edward Island')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Quebec')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Saskatchewan')
INSERT
Lookup_User_StateProvince(StateProvinceText) VALUES('Yukon')
GO
----------------------------------------------- 5
CREATE TABLE
Lookup_User_Country (
[CountryID]
integer identity primary key,
[CountryText]
varchar (50)
)
GO
INSERT
Lookup_User_Country(CountryText) VALUES('Not Applicable')
INSERT
Lookup_User_Country(CountryText) VALUES('Canada')
INSERT
Lookup_User_Country(CountryText) VALUES('Afghanistan')
INSERT
Lookup_User_Country(CountryText) VALUES('Albania')
INSERT
Lookup_User_Country(CountryText) VALUES('Algeria')
INSERT
Lookup_User_Country(CountryText) VALUES('American Samoa')
INSERT
Lookup_User_Country(CountryText) VALUES('Andorra')
INSERT
Lookup_User_Country(CountryText) VALUES('Angola')
INSERT
Lookup_User_Country(CountryText) VALUES('Angola')
INSERT
Lookup_User_Country(CountryText) VALUES('Anguilla')
INSERT
Lookup_User_Country(CountryText) VALUES('Antarctica')
INSERT
Lookup_User_Country(CountryText) VALUES('Antigua and Barbuda')
INSERT
Lookup_User_Country(CountryText) VALUES('Argentina')
INSERT
Lookup_User_Country(CountryText) VALUES('Armenia')
INSERT
Lookup_User_Country(CountryText) VALUES('Aruba')
INSERT
Lookup_User_Country(CountryText) VALUES('Australia')
INSERT
Lookup_User_Country(CountryText) VALUES('Austria')
INSERT
Lookup_User_Country(CountryText) VALUES('Azerbaijan')
INSERT
Lookup_User_Country(CountryText) VALUES('Bahrain')
INSERT
Lookup_User_Country(CountryText) VALUES('Bangladesh')
INSERT
Lookup_User_Country(CountryText) VALUES('Barbados')
INSERT
Lookup_User_Country(CountryText) VALUES('Belarus')
INSERT
Lookup_User_Country(CountryText) VALUES('Belgium')
INSERT
Lookup_User_Country(CountryText) VALUES('Belize')
INSERT
Lookup_User_Country(CountryText) VALUES('Benin')
INSERT
Lookup_User_Country(CountryText) VALUES('Bermuda')
INSERT
Lookup_User_Country(CountryText) VALUES('Bhutan')
INSERT
Lookup_User_Country(CountryText) VALUES('Bolivia')
INSERT
Lookup_User_Country(CountryText) VALUES('Bosnia and Herzegovina')
INSERT
Lookup_User_Country(CountryText) VALUES('Botswana')
INSERT
Lookup_User_Country(CountryText) VALUES('Bouvet Island')
INSERT
Lookup_User_Country(CountryText) VALUES('Brazil')
INSERT
Lookup_User_Country(CountryText) VALUES('British Indian Ocean Territory')
INSERT
Lookup_User_Country(CountryText) VALUES('Brunei Darussalam')
INSERT
Lookup_User_Country(CountryText) VALUES('Burkina Faso')
INSERT
Lookup_User_Country(CountryText) VALUES('Burundi')
INSERT
Lookup_User_Country(CountryText) VALUES('Cambodia')
INSERT
Lookup_User_Country(CountryText) VALUES('Cameroon')
INSERT
Lookup_User_Country(CountryText) VALUES('Cape Verde')
INSERT
Lookup_User_Country(CountryText) VALUES('Cayman Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Central African Republic')
INSERT
Lookup_User_Country(CountryText) VALUES('Chad')
INSERT
Lookup_User_Country(CountryText) VALUES('China')
INSERT
Lookup_User_Country(CountryText) VALUES('Christmas Island')
INSERT
Lookup_User_Country(CountryText) VALUES('Cocos (Keeling Islands)')
INSERT
Lookup_User_Country(CountryText) VALUES('Colombia')
INSERT
Lookup_User_Country(CountryText) VALUES('Comoros')
INSERT
Lookup_User_Country(CountryText) VALUES('Congo')
INSERT
Lookup_User_Country(CountryText) VALUES('Cook Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Costa Rica')
INSERT
Lookup_User_Country(CountryText) VALUES('Cote D''Ivoire (Ivory Coast)')
INSERT
Lookup_User_Country(CountryText) VALUES('Croatia (Hrvatska)')
INSERT
Lookup_User_Country(CountryText) VALUES('Cuba')
INSERT
Lookup_User_Country(CountryText) VALUES('Cyprus')
INSERT
Lookup_User_Country(CountryText) VALUES('Czech Republic')
INSERT
Lookup_User_Country(CountryText) VALUES('Denmark')
INSERT
Lookup_User_Country(CountryText) VALUES('Djibouti')
INSERT
Lookup_User_Country(CountryText) VALUES('Dominican Republic')
INSERT
Lookup_User_Country(CountryText) VALUES('Dominica')
INSERT
Lookup_User_Country(CountryText) VALUES('East Timor')
INSERT
Lookup_User_Country(CountryText) VALUES('Ecuador')
INSERT
Lookup_User_Country(CountryText) VALUES('Egypt')
INSERT
Lookup_User_Country(CountryText) VALUES('El Salvador')
INSERT
Lookup_User_Country(CountryText) VALUES('Equatorial Guinea')
INSERT
Lookup_User_Country(CountryText) VALUES('Eritrea')
INSERT
Lookup_User_Country(CountryText) VALUES('Estonia')
INSERT
Lookup_User_Country(CountryText) VALUES('Ethiopia')
INSERT
Lookup_User_Country(CountryText) VALUES('Falkland Islands (Malvinas)')
INSERT
Lookup_User_Country(CountryText) VALUES('Faroe Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Fiji')
INSERT
Lookup_User_Country(CountryText) VALUES('Finland')
INSERT
Lookup_User_Country(CountryText) VALUES('France, Metropolitan')
INSERT
Lookup_User_Country(CountryText) VALUES('France')
INSERT
Lookup_User_Country(CountryText) VALUES('French Guiana')
INSERT
Lookup_User_Country(CountryText) VALUES('French Polynesia')
INSERT
Lookup_User_Country(CountryText) VALUES('French Southern Territories')
INSERT
Lookup_User_Country(CountryText) VALUES('Gabon')
INSERT
Lookup_User_Country(CountryText) VALUES('Gambia')
INSERT
Lookup_User_Country(CountryText) VALUES('Georgia')
INSERT
Lookup_User_Country(CountryText) VALUES('Germany')
INSERT
Lookup_User_Country(CountryText) VALUES('Ghana')
INSERT
Lookup_User_Country(CountryText) VALUES('Gibraltar')
INSERT
Lookup_User_Country(CountryText) VALUES('Greece')
INSERT
Lookup_User_Country(CountryText) VALUES('Greenland')
INSERT
Lookup_User_Country(CountryText) VALUES('Grenada')
INSERT
Lookup_User_Country(CountryText) VALUES('Guadeloupe')
INSERT
Lookup_User_Country(CountryText) VALUES('Guam')
INSERT
Lookup_User_Country(CountryText) VALUES('Guatemala')
INSERT
Lookup_User_Country(CountryText) VALUES('Guinea-Bissau')
INSERT
Lookup_User_Country(CountryText) VALUES('Guinea')
INSERT
Lookup_User_Country(CountryText) VALUES('Guyana')
INSERT
Lookup_User_Country(CountryText) VALUES('Haiti')
INSERT
Lookup_User_Country(CountryText) VALUES('Heard and McDonald Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Honduras')
INSERT
Lookup_User_Country(CountryText) VALUES('Hong Kong')
INSERT
Lookup_User_Country(CountryText) VALUES('Hungary')
INSERT
Lookup_User_Country(CountryText) VALUES('Iceland')
INSERT
Lookup_User_Country(CountryText) VALUES('India')
INSERT
Lookup_User_Country(CountryText) VALUES('Indonesia')
INSERT
Lookup_User_Country(CountryText) VALUES('Iran')
INSERT
Lookup_User_Country(CountryText) VALUES('Iraq')
INSERT
Lookup_User_Country(CountryText) VALUES('Ireland')
INSERT
Lookup_User_Country(CountryText) VALUES('Israel')
INSERT
Lookup_User_Country(CountryText) VALUES('Italy')
INSERT
Lookup_User_Country(CountryText) VALUES('Jamaica')
INSERT
Lookup_User_Country(CountryText) VALUES('Japan')
INSERT
Lookup_User_Country(CountryText) VALUES('Jordan')
INSERT
Lookup_User_Country(CountryText) VALUES('Kazakhstan')
INSERT
Lookup_User_Country(CountryText) VALUES('Kenya')
INSERT
Lookup_User_Country(CountryText) VALUES('Kiribati')
INSERT
Lookup_User_Country(CountryText) VALUES('Korea (North)')
INSERT
Lookup_User_Country(CountryText) VALUES('Korea (South)')
INSERT
Lookup_User_Country(CountryText) VALUES('Kuwait')
INSERT
Lookup_User_Country(CountryText) VALUES('Kyrgyzstan')
INSERT
Lookup_User_Country(CountryText) VALUES('Laos')
INSERT
Lookup_User_Country(CountryText) VALUES('Latvia')
INSERT
Lookup_User_Country(CountryText) VALUES('Lebanon')
INSERT
Lookup_User_Country(CountryText) VALUES('Lesotho')
INSERT
Lookup_User_Country(CountryText) VALUES('Liberia')
INSERT
Lookup_User_Country(CountryText) VALUES('Libya')
INSERT
Lookup_User_Country(CountryText) VALUES('Liechtenstein')
INSERT
Lookup_User_Country(CountryText) VALUES('Lithuania')
INSERT
Lookup_User_Country(CountryText) VALUES('Luxembourg')
INSERT
Lookup_User_Country(CountryText) VALUES('Macau')
INSERT
Lookup_User_Country(CountryText) VALUES('Macedonia')
INSERT
Lookup_User_Country(CountryText) VALUES('Madagascar')
INSERT
Lookup_User_Country(CountryText) VALUES('Malawi')
INSERT
Lookup_User_Country(CountryText) VALUES('Malaysia')
INSERT
Lookup_User_Country(CountryText) VALUES('Maldives')
INSERT
Lookup_User_Country(CountryText) VALUES('Mali')
INSERT
Lookup_User_Country(CountryText) VALUES('Malta')
INSERT
Lookup_User_Country(CountryText) VALUES('Marshall Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Martinique')
INSERT
Lookup_User_Country(CountryText) VALUES('Mauritania')
INSERT
Lookup_User_Country(CountryText) VALUES('Mauritius')
INSERT
Lookup_User_Country(CountryText) VALUES('Mayotte')
INSERT
Lookup_User_Country(CountryText) VALUES('Mexico')
INSERT
Lookup_User_Country(CountryText) VALUES('Micronesia')
INSERT
Lookup_User_Country(CountryText) VALUES('Moldova')
INSERT
Lookup_User_Country(CountryText) VALUES('Monaco')
INSERT
Lookup_User_Country(CountryText) VALUES('Mongolia')
INSERT
Lookup_User_Country(CountryText) VALUES('Montserrat')
INSERT
Lookup_User_Country(CountryText) VALUES('Morocco')
INSERT
Lookup_User_Country(CountryText) VALUES('Mozambique')
INSERT
Lookup_User_Country(CountryText) VALUES('Myanmar')
INSERT
Lookup_User_Country(CountryText) VALUES('Namibia')
INSERT
Lookup_User_Country(CountryText) VALUES('Nauru')
INSERT
Lookup_User_Country(CountryText) VALUES('Nepal')
INSERT
Lookup_User_Country(CountryText) VALUES('Netherlands Antilles')
INSERT
Lookup_User_Country(CountryText) VALUES('Netherlands')
INSERT
Lookup_User_Country(CountryText) VALUES('New Caledonia')
INSERT
Lookup_User_Country(CountryText) VALUES('New Zealand')
INSERT
Lookup_User_Country(CountryText) VALUES('Nicaragua')
INSERT
Lookup_User_Country(CountryText) VALUES('Nigeria')
INSERT
Lookup_User_Country(CountryText) VALUES('Niger')
INSERT
Lookup_User_Country(CountryText) VALUES('Niue')
INSERT
Lookup_User_Country(CountryText) VALUES('Norfolk Island')
INSERT
Lookup_User_Country(CountryText) VALUES('Northern Mariana Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Norway')
INSERT
Lookup_User_Country(CountryText) VALUES('Oman')
INSERT
Lookup_User_Country(CountryText) VALUES('Pakistan')
INSERT
Lookup_User_Country(CountryText) VALUES('Palau')
INSERT
Lookup_User_Country(CountryText) VALUES('Panama')
INSERT
Lookup_User_Country(CountryText) VALUES('Papua New Guinea')
INSERT
Lookup_User_Country(CountryText) VALUES('Paraguay')
INSERT
Lookup_User_Country(CountryText) VALUES('Peru')
INSERT
Lookup_User_Country(CountryText) VALUES('Philippines')
INSERT
Lookup_User_Country(CountryText) VALUES('Pitcairn')
INSERT
Lookup_User_Country(CountryText) VALUES('Poland')
INSERT
Lookup_User_Country(CountryText) VALUES('Portugal')
INSERT
Lookup_User_Country(CountryText) VALUES('Puerto Rico')
INSERT
Lookup_User_Country(CountryText) VALUES('Qatar')
INSERT
Lookup_User_Country(CountryText) VALUES('Reunion')
INSERT
Lookup_User_Country(CountryText) VALUES('Russian Federation')
INSERT
Lookup_User_Country(CountryText) VALUES('Rwanda')
INSERT
Lookup_User_Country(CountryText) VALUES('S. Georgia and S. Sandwich Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Saint Kitts and Nevis')
INSERT
Lookup_User_Country(CountryText) VALUES('Saint Lucia')
INSERT
Lookup_User_Country(CountryText) VALUES('Saint Vincent and The Grenadines')
INSERT
Lookup_User_Country(CountryText) VALUES('Samoa')
INSERT
Lookup_User_Country(CountryText) VALUES('San Marino')
INSERT
Lookup_User_Country(CountryText) VALUES('Sao Tome and Principe')
INSERT
Lookup_User_Country(CountryText) VALUES('Saudi Arabia')
INSERT
Lookup_User_Country(CountryText) VALUES('Senegal')
INSERT
Lookup_User_Country(CountryText) VALUES('Seychelles')
INSERT
Lookup_User_Country(CountryText) VALUES('Sierra Leone')
INSERT
Lookup_User_Country(CountryText) VALUES('Singapore')
INSERT
Lookup_User_Country(CountryText) VALUES('Slovak Republic')
INSERT
Lookup_User_Country(CountryText) VALUES('Slovenia')
INSERT
Lookup_User_Country(CountryText) VALUES('Solomon Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Somalia')
INSERT
Lookup_User_Country(CountryText) VALUES('South Africa')
INSERT
Lookup_User_Country(CountryText) VALUES('Spain')
INSERT
Lookup_User_Country(CountryText) VALUES('Sri Lanka')
INSERT
Lookup_User_Country(CountryText) VALUES('St. Helena')
INSERT
Lookup_User_Country(CountryText) VALUES('St. Pierre and Miquelon')
INSERT
Lookup_User_Country(CountryText) VALUES('Sudan')
INSERT
Lookup_User_Country(CountryText) VALUES('Suriname')
INSERT
Lookup_User_Country(CountryText) VALUES('Svalbard and Jan Mayen Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Swaziland')
INSERT
Lookup_User_Country(CountryText) VALUES('Sweden')
INSERT
Lookup_User_Country(CountryText) VALUES('Switzerland')
INSERT
Lookup_User_Country(CountryText) VALUES('Syria')
INSERT
Lookup_User_Country(CountryText) VALUES('Taiwan')
INSERT
Lookup_User_Country(CountryText) VALUES('Tajikistan')
INSERT
Lookup_User_Country(CountryText) VALUES('Tanzania')
INSERT
Lookup_User_Country(CountryText) VALUES('Thailand')
INSERT
Lookup_User_Country(CountryText) VALUES('Togo')
INSERT
Lookup_User_Country(CountryText) VALUES('Tokelau')
INSERT
Lookup_User_Country(CountryText) VALUES('Tonga')
INSERT
Lookup_User_Country(CountryText) VALUES('Trinidad and Tobago')
INSERT
Lookup_User_Country(CountryText) VALUES('Tunisia')
INSERT
Lookup_User_Country(CountryText) VALUES('Turkey')
INSERT
Lookup_User_Country(CountryText) VALUES('Turkmenistan')
INSERT
Lookup_User_Country(CountryText) VALUES('Turks and Caicos Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Tuvalu')
INSERT
Lookup_User_Country(CountryText) VALUES('US Minor Outlying Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Uganda')
INSERT
Lookup_User_Country(CountryText) VALUES('Ukraine')
INSERT
Lookup_User_Country(CountryText) VALUES('United Arab Emirates')
INSERT
Lookup_User_Country(CountryText) VALUES('United Kingdom')
INSERT
Lookup_User_Country(CountryText) VALUES('United States of America')
INSERT
Lookup_User_Country(CountryText) VALUES('Uruguay')
INSERT
Lookup_User_Country(CountryText) VALUES('Uzbekistan')
INSERT
Lookup_User_Country(CountryText) VALUES('Vanuatu')
INSERT
Lookup_User_Country(CountryText) VALUES('Vatican City State')
INSERT
Lookup_User_Country(CountryText) VALUES('Venezuela')
INSERT
Lookup_User_Country(CountryText) VALUES('Viet Nam')
INSERT
Lookup_User_Country(CountryText) VALUES('Virgin Islands (British)')
INSERT
Lookup_User_Country(CountryText) VALUES('Virgin Islands (US)')
INSERT
Lookup_User_Country(CountryText) VALUES('Wallis and Futuna Islands')
INSERT
Lookup_User_Country(CountryText) VALUES('Western Sahara')
INSERT
Lookup_User_Country(CountryText) VALUES('Yemen')
INSERT
Lookup_User_Country(CountryText) VALUES('Yugoslavia')
INSERT
Lookup_User_Country(CountryText) VALUES('Zaire')
INSERT
Lookup_User_Country(CountryText) VALUES('Zambia')
INSERT
Lookup_User_Country(CountryText) VALUES('Zimbabwe')
GO
------------------------------------------------------------------------------------------
January 20, 2004 at 8:00 am
This was removed by the editor as SPAM
January 20, 2004 at 2:29 pm
You missed:
INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Alberta')
Also
INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Newfoundland')
should be
INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Newfoundland and Labrador')
The table Lookup_User_SecretWordType has 2 varchar(50) columns you are setting to be the same. I am guessing the first column should be an Integer. This code gets executed in Query analyser to create and populate the tables. I doubt you want to do this in VB or C# since this only needs to be done once.
Francis
January 20, 2004 at 2:56 pm
I agree whith fhanlon, i couldn't see the reasons for implement this in vb or c# even with ado.net. May be you need to know how to show this data on a web page.
:.::.:.::
January 20, 2004 at 3:04 pm
I can illustrate this using
Utility.buildListBox
?
January 20, 2004 at 3:10 pm
I assume Utility.Buildlistbox just gets the data from SQL Server and populates the listbox. Is this method already written and you are trying to use it?
Francis
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply