如何在sql中获取更新并在Grid视图中显示 [英] How to Get updates in sql and show it in Grid view

问题描述

如何从sql server数据库获取更新并将其显示在Grid视图中，

示例:

假设我有一个表叫做Contacts

联系人表包含10个字段，如..
名称，手机，电子邮件，街道，城市，国家，州，邮政编码等.

当他在任何字段中进行更新时，则应在网格视图中显示

假设他更改了手机号码和电子邮件ID
然后在网格视图中，它应该显示:

手机号码从123456更改为98568956
通过电子邮件将iD从[e-mail]发送到[e-mail]

最后，如果用户将在每个字段中进行更改，那么它还将在gridview中显示所有更新.

此示例在orkut.com和facebook.com中实现，当您的朋友更改任何信息时，您就可以在您朋友的更新选项卡中看到

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 [e-mail] to [e-mail] 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

推荐答案

如果用户更改数据库中的值，您将如何获取先前的值.我的意思是您将该表列的先前的值保存在何处.

如果要这样显示，就必须遵循其他方式，例如...

保持先前的值table.thn存储他更改的列以及该列的先前值.


希望您能理解我的意思.

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.

这篇关于如何在sql中获取更新并在Grid视图中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！