GetDate in Dataset

[Stefano Meier]

I have a dataset with a DateTime field, each time i make an update i have to
update also that field with the actual date time, but with the DB date and
time,
somthing like:

UPDATE mytable SET datechanged=GETDATE() WHERE id=....

It's possible by setting something in the dataset or i have to change the
updatecommand of the dataadapter?

 

[Stephany Young]

If you do it in DataSet then the value will be the system date of the client
machine at the point the record is updated in the dataset.

If you do it in the UpdateCommand of the DataAdapter then the value will be
the system date of the machine where the database resides at the point the
record is updated to the database.

It really boils down to choice.

The example you have shown would definitely required modification of the
UpdateCommand of the DataAdapter.

 

[Stefano Meier]

Thank's, it was what i thought.

If you do it in DataSet then the value will be the system date of the client
machine at the point the record is updated in the dataset.

If you do it in the UpdateCommand of the DataAdapter then the value will be
the system date of the machine where the database resides at the point the
record is updated to the database.

It really boils down to choice.

The example you have shown would definitely required modification of the
UpdateCommand of the DataAdapter.

have