How to Get updates in sql and show it in Grid view

Question

0.00/5 (No votes)

See more:

How to Get updates from sql server Database and show it Grid view,

Example:

Suppose i have table is called Contacts

Contacts table contains 10 fields like..
name, mobile, email, street, city, country, state, zip code, etc..

when he updates in any field, then that should show in grid view

suppose he changes mobile number and email id
then in grid view, it should show :

Mobile number from 123456 to 98568956 has changed
Email iD from xyz@gmail.com to abc@gmail.com is changes

Finaly if a user will change in each field then also it will display all updates in gridview.

this example is Implemented in orkut.com and facebook.com, when your friend is changed any information then u can see in your friend's upate tab

Posted 18-Sep-11 23:49pm

Surendra Tarai

Add a Solution

Comments

rkthiyagarajan 19-Sep-11 5:51am

What you trying to say?

1 solution

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)

Muralikrishna8811 · Answer 1 · 2011-09-18T23:55:00

Solution 1

Hi,

If user change the values in database how you get previous value .I mean where you save previous values of that table column.

If you want to show like that you've to follow some other way like...

maintaining previous values table.thn store what column he changed and what is the previous value of that column.

I hope you understood what i said.

Posted 18-Sep-11 23:55pm

Muralikrishna8811

Comments

Surendra Tarai 19-Sep-11 5:59am

Ya I know that, i have to maintain Prevois data, and then compare it with new data then i can show it after compare with new and old values. but i want, is there any shortcut way or any sql features, using that one we can do it

Muralikrishna8811 19-Sep-11 6:07am

No way,but there is a feature in sql like latest updation to database.But i'm not sure on this because there no record by used ones.