This is a discussion on "How should I populate the following table." within the Databases section. This forum, and the thread "How should I populate the following table. are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
How should I populate the following table.
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
|||
|
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 |
|
|
![]() |
| Tags |
| populate, following, table |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looking for Script to sort table data (& populate database) | toasty | PHP Forum | 1 | Oct 13th, 2006 17:42 |
| Am I using table-cell and table-row too much? | idl | Web Page Design | 15 | Sep 7th, 2006 12:55 |
| Need to align width of Float table with the table below | Vertabase | Web Page Design | 4 | Mar 8th, 2006 21:21 |
| Populate Drop Down | SweetLou | Classic ASP | 5 | Jan 18th, 2006 21:31 |
| ..copy data from column A in Table A to column B in Table B? | gecastill | Databases | 10 | Jun 23rd, 2005 18:27 |