Record Date of a Registration form in Asp.net C#

[developerquery]

When a user fills all the required information in a registration form then how do I record the date of submitting the form using Sql Server 2005?

My insert query is :

con.Open();
SqlCommand command = new SqlCommand("insert into data (UserID,Name,Email,Country,Date,Multiselect,Gender,Pincode)values('" + txtuserid.Text + "','" + txtname.Text + "','" + txtemail.Text + "','" + ddlcountry.SelectedItem.Text + "','" + s1 + "','" + lbmultiselect.Text + "','" + rblgender.Text + "','" + txtpincode.Text + "')", con);
command.ExecuteNonQuery();

[Rabbit]

Please use code tags when posting code.

In SQL Server, you can use the GETDATE() function to return the current date and time.

[PsychoCoder]

To expand on what Rabbit suggested you can set the columns default value to GETDATE() and any time a record is inserted into that table that column will always be set to the current date/time of the insert.

EDIT:

To alter your column to add the default value setting do this

ALTER TABLE [dbo].[YourTableName] ADD  DEFAULT (getdate()) FOR [YourColumnName]