View Single Post
  #1 (permalink)  
Old Oct 14th, 2003, 16:11
macupryk macupryk is offline
New Member
Join Date: Sep 2003
Location: Canada
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
How should I populate the following table.

How should I populate the table using the following:
in ado.net

Session["webform1_txtUserName]
Session["webform1_txtPassword]
Session["webform2_txtHeadLine]
Session["webform2_lbTitle]
Session["webform2_txtFirstName] Session["webform2_txtLastName] Session["webform1_txtEmail] Session["webform2_lbSecretWordType]
Session["webform2_txtSecretWord] Session["webform2_BirthDateSelector]
Int Age = whatever;
Session["webform2_lbGender]
Session["webform2_txtCity]
Session["webform2_lbStateProvince]
Session["webform2_lbCountry]
DateTime = getdate();
Can someone make a suggestion or help me out on the coding scheme I would appreciate it


CREATE TABLE [tbl_Users] (
[UserId] [int] IDENTITY (1, 1) NOT NULL ,
[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[HeadLine] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[FirstName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[LastName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[email] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SecretWordType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SecretWord] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Age] [int] NOT NULL ,
[DOB] [datetime] NOT NULL ,
[Gender] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[StateProvince] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Country] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DateCreated] [datetime] NOT NULL ,
CONSTRAINT [PK_tbl_Users] PRIMARY KEY CLUSTERED
(
[UserId]
) ON [PRIMARY]
) ON [PRIMARY]
GO