Member Avatar for shy_wani

hi..
i've created a table named :Survey

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..

  • 1 Contributor
  • 1 Reply
  • 110 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by shy_wani
Member Avatar for shy_wani

ok..ok
finally i understand..
now i've changed my column DateCreated in MSSQL to accept null values..

and inside my form at ASP.NET..i've changed my sql statement to..

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

and now it's finally work..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.