Old Value and new Value to be saved in DB

Question

0.00/5 (No votes)

See more:

hi friends,
i have an Web Form named PO.aspx,User makes entry in it and save the records for that particular data.
my requirement is, whenever the Records which was saved previously comes for Update in PO.aspx Web Form and user changes some value in it.
example:
(PO date) Previously old value was '20-07-2012' and after modifying it to '24-07-2012' new value.
then a new record (log) should be maintained in Database table with values like
Username,Oldvalue,Newvalue,UpdatedDate,Comments(Reason for Change).

This should be done for each control in Web Form whose value has been changed by user every time.
how it can be achieved!!!

Regards,
Aamir

Posted 24-Jul-12 19:34pm

aamir07

Add a Solution

Comments

Sergey Alexandrovich Kryukov 25-Jul-12 1:40am

And what's the problem? What did you try?
--SA

aamir07 25-Jul-12 1:53am

i am not getting the proper method by which i can achieve this coz der are different controls in Web Form(textbox,dropdownlist,grdiview)....so i have to check for each control what was it old value and see the new value and if any change then ask the user to fill the reason for it.....on which event should it be perform on Save Click or any controls event

WoodenLegNamedSmith 30-Jul-12 16:51pm

You're going to need to start out by mapping the controls into the database and assign them an ID. Then you create another table that handles the values of the controls, you would need to time-stamp the value that way when you recall it you just take the value with the most recent date.

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)