Setting default value for DateTime field

D

Danny L

Hi,

I would like a datetime field in my dataset to always be set to the
current Date & time when a new row is added. I tried setting the
default value to DateTime.Now but that dosen't work since the function
is called only once (and not everytime a new row is added).
I am using a winforms application with bound controls.

Regards,

Danny
 
S

Sushil Chordia

Danny, Are you trying to update the datatable with the time you are making
the update in the backend database? If thats the case, one option (without
giving much thinking) could be to specify your own InsertCommand and append
currentTime to the insert statement. "insert into test values
(@a1,@a2,"+DateTime.Now()+")"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning a default value for DateTime in EntityFramework designer? 0
Set Default of DateTime field to "today"? 2
Merge binary serialized nullable datetime field 1
C# passes parameter but return value always -1 3
insert a null value into a datetime field 1
Saving to a DateTime field in Sql Server 2000 using ADO.Net 14
Passing DateTime to sp via OleDbDataAdapter 1
datacolumn datetime from UTC to Localtime 2

Top