How do insert into a DB

[=?Utf-8?B?RGF2ZQ==?=]

I have a database field of type datetime. This field should store a system
time when a record is inserted. The other fields in the record are bound to a
control and I have no problems with them. I tried setting the datetime field
with a default value using getdate(), but it still does not work. How can I
use a statement similar these beow to achieve this?

My current code:

<InsertParamete rs>
<asp:ControlPar ameter Name="BillingAd dress" Type="String"
ControlID="Bill ingAddress" PropertyName="T ext" />
<asp:ControlPar ameter Name="BillingCi ty" Type="String"
ControlID="Bill ingCity" PropertyName="T ext" />

<!-- This is where my problem is !-->
<asp:ControlPar ameter Name="SignUpDat e" Type="String" .... />

--
L. A. Jones

[Alexey Smirnov]

On May 12, 4:08 pm, Dave <D...@discussio ns.microsoft.co mwrote:

I have a database field of type datetime. This field should store a system
time when a record is inserted. The other fields in the record are bound to a
control and I have no problems with them. I tried setting the datetime field
with a default value using getdate(), but it still does not work. How can I
use a statement similar these beow to achieve this?

My current code:

<InsertParamete rs>
<asp:ControlPar ameter Name="BillingAd dress" Type="String"
ControlID="Bill ingAddress" PropertyName="T ext" />
<asp:ControlPar ameter Name="BillingCi ty" Type="String"
ControlID="Bill ingCity" PropertyName="T ext" />

<!-- This is where my problem is !-->
<asp:ControlPar ameter Name="SignUpDat e" Type="String" .... />

--
L. A. Jones

SQL Server?

I think, you can specify the date in the statement:

InsertCommand=" INSERT INTO... getdate()....

You can also create a constraint for the table, it will add a date
automatically

ALTER TABLE [tablename] ADD
CONSTRAINT [somename] DEFAULT (getdate()) FOR [columnname]
GO

[GroupReader]

I agree with Alexey. Also, I wanted to add that maybe your problem is
that your are missing the quotes around the date. If you are sending
a date to SQL Server as a string (which is fine) be sure to treat it
like a string and put quotes around it.