current datetime need to be stored in DB each time while updating

Question

0.00/5 (No votes)

See more:

i am using datetimepicker control. if i press UPDATE button, each time while pressing system date and time need to stored in database,(if i press 3 times then 3 times it should store) it should not overwrite...\\is it possible help me out

Posted 3-Jan-13 7:02am

selva_1990

Add a Solution

2 solutions

Solution 1

Insert three rows into the database.
You don't need to update the column.

Table1
Row1 -> A,B,C,T1
Row2 -> A,B,C,T2
Row3 -> A,D,E,T3

Another neater solution might be to insert an id into a column which points to another table that stores a number of entries for each datetime update.

Table1
Row1 -> A,B,C,id1
Row2 -> A,B,C.id1
Row3 -> A,D,E,id2

Table2
Row1 -> id1, T1
Row2 -> id1, T2
Row3 -> id3, T3

Posted 3-Jan-13 7:10am

Abhinav S

Comments

selva_1990 3-Jan-13 13:16pm

these are my fields name,balance,total.... once i inserted data into database, now i need to update the balance field so each time while updating that particular time need to be stored...

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-01-03T07:13:00

Of course it is possible, but your question needs more clarification, like table structure. How to store exactly?
But let's try answering it...
You can achieve this in many ways. Here are two of them:
1) You make an other table that contains a foreign key to whatever you want to link the timestamp and the timestamp. On every Update you not only update what you want, but also insert a row in this table.
2) make an other table that contains a foreign key to whatever you want to link the timestamp and the timestamp. And you create an on update (and probably on insert too) trigger on the primary table that inserts a record in this second table.

To be sure to have the good timestamp, you should let the server give it a value. See: http://msdn.microsoft.com/en-us/library/ms188383.aspx[^]

[Update]
See following sample:

SQL

CREATE TABLE [dbo].[balance_history](
    [ref_id] [int] NOT NULL,
    [balance] [money] NOT NULL,
    [total] [money] NOT NULL,
    [timestamp] [datetime] NOT NULL
) ON [PRIMARY]

SQL

CREATE TABLE [dbo].[balances](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](50) NOT NULL,
    [balance] [money] NOT NULL,
    [total] [money] NOT NULL,
 CONSTRAINT [PK_balances] PRIMARY KEY CLUSTERED ( [id] ASC )
) ON [PRIMARY]

SQL

CREATE TRIGGER [dbo].[TR_STORE_]
   ON  [dbo].[balances] AFTER UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO BALANCE_HISTORY(ref_id, balance, total, [timestamp])
    SELECT id, balance, total, GETDATE()
    FROM DELETED;

END