how do you assign a fieldname current system date?

[Ken011]

Greetings experts.
In classic asp, you would assign a field name system date like this:

sql="insert into tableName (dateField) Values (#" & date()&"#)

I am using MS Access database.

How do you do the same us asp.net (vb)?

The following isn't working for me:

        cmdcommand = New OleDbCommand( _
         "INSERT INTO Results (fDate) " & _
         "VALUES (@fDate)",conn)        
 
cmdcommand.Parameters("@fdate").Value = DateTime.Now.ToString("dd-MMM-yyyy")

Thanks in advance

 

[jmeckley]

it will look something like this, but double check the overload I used:
cmdcommand.Parameters("fdate", SqlDataType.DateTime).Value = DateTime.Now.

Jason Meckley
Programmer
Specialty Bakers, Inc.