inserting the current date into a table when insert 1

[thefrstgatsby]

How do I insert the current date and time into my sql datetime row, whenever someone submits a form?

 

[obislavu]

1. In the table definition, set the Default Value to :

(getdate())

When a record will be added to the table, that column will be set to the current date time set on the SQL server.
2. From your app code:

string strNow = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);

Pass strNow to INSERT or UPDATE command that you build and send to the server.
3. Pass it as parameter from your app code to a stored procedure:

string strNow = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
//...

SqlDataAdapter vSqlDataAdapter=new SqlDataAdapter();
vSqlDataAdapter.SelectCommand = new SqlCommand("sp_MyStoredProc");
vSqlDataAdapter.SelectCommand.CommandType =CommandType.StoredProcedure;
//... 
vSqlParameter= vSqlDataAdapter.SelectCommand.Parameters.Add("@ColumnToBeSetToNow", strNow);

The sp_MyStoredProc is a stored procedure which receives the value of strNow and does the job.
-obislavu-