RSS

my is my date keep on changing???

Please support our MS SQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 887 | Replies: 1 | Solved

•

Previous Post in Thread

Next Post in Thread

•

Join Date: Mar 2007

Posts: 34

Reputation: shy_wani is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

shy_wani

Offline

Light Poster

my is my date keep on changing???

Apr 29th, 2007

hi..
i've created a table named

urvey

Help with Code Tags

(Toggle Plain Text)

CREATE TABLE [dbo].[Survey] (
    [CustomerID] [int] NOT NULL ,
    [SurveyID] [int] IDENTITY (1, 1) NOT NULL ,
    [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [DateCreated] AS (getdate()) ,
    [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

my problem is regarding my DateCreated.. when system created through my page in aspx, the survey input are correctly stored in the database except for DateCreated where the whole table Column DateCreated changes its date to date at time the last survey was created....

my code for inserting in survey.aspx

  

Dim strTitle As String = title.Text

Dim strDescription As String = description.Text   

sql2 = "INSERT INTO Survey(CustomerID,SurveyTitle,SurveyDescription) VALUES('" & Session("sCustomerID") & "','" & strTitle & "','" & strDescription & "')"

            cmd2 = New SqlCommand(sql2, MyConnection)

            cmd2.ExecuteNonQuery()

where did i go wrong? please guide me..