How to do: timestamp?
From: Mika M (mika.mahonen_at_nospam_kolumbus.fi)
Date: 02/06/04
- Next message: Waldo Sonntag: "SqlDataReader Bug??"
- Previous message: J: "Automatic transactions...."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 6 Feb 2004 16:09:39 +0200
Hello!
I have Windows forms application made by VB 2003, with some TextBoxes for
master table data, and DataGrid for child table data. These controls are
bound to dataset datatables using ADO.NET.
I save this data of the form controls into certain target path as certain
kind of text file. Just after text file is created, I need to put timestamp
into database table to use avoiding make this text file again later. I have
bound TextField on the form to show this timestamp, but how should I make
this timestamp? Data Type in the database table field is smalldatetime.
It would be better to use as Timestamp database servers time because
workstation computers time may not be correct, but maybe 'Now' or something
like that works fine too.
Using sql to do this would be something like this ...
update MyTable set FileCreated = GETDATE() where SomeID = This_ID
... but when controls are bound to datatable I propably shouldn't use this -
or should I ?
-- Thanks! Mika
- Next message: Waldo Sonntag: "SqlDataReader Bug??"
- Previous message: J: "Automatic transactions...."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
