How should I populate the following table.

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.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Closed Thread
 
LinkBack Thread Tools
  #1 (permalink)  
Old Oct 14th, 2003, 16:11
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

  #2 (permalink)  
Old Oct 15th, 2003, 23:34
Most Reputable Member
Join Date: Jul 2003
Posts: 1,856
Thanks: 0
Thanked 0 Times in 0 Posts
What are you using PHP, ASP, etc?
Closed Thread

Tags
populate, following, table

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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


All times are GMT. The time now is 12:54.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43