捕获对数据库所做的所有更改并将其邮寄给客户端 [英] catch all changes made on db and mail it to client

问题描述

我已经在asp.net中创建了软件，用户可以根据其角色登录并在表格中填写信息.保存表单后，数据库将更新.我想获取用户所做的所有更改并将其邮寄给管理员.
用户填写的表单是长格式，其中信息存储在数据库的不同表中.
有什么办法可以捕获所有信息和邮件吗?

或AnyOne有任何想法我该如何完成这项任务... ????
请帮助...

I have created software in asp.net where user logs in according to their role and fill the information in form. after saving the form the database is updated. I want to get all the changes the user has done and mail it to the administrator.
The form user fills is long form where the information is store in different tables of databse.
Is there any way I can catch all information and mail...

Or AnyOne have any idea How can I achive this task... ????
Plz Help...

推荐答案

您可以执行此操作.您可以遵循以下两个主要流:
A)如果您有DAL或BL，则可以扩展它来为您完成此操作.但是我想你没有这样的东西.
B)如果您的DBMS支持，则可以使用触发器来捕获DB端的事件.并非所有的DBMS支持触发器.您尚未指定要使用的内容.希望您使用的是MS SQL Server，因为使用程序语言甚至.net

You can do this. There are two main streams you can follow:
A) if you have a DAL, or BL, you can extend it to do this for you. But I suppose you have no such thing.
B) if your DBMS supports it, you can use triggers, to catch events on DB side. Not all DBMS support triggers. You haven''t specified what you are using. I hope for you, you are using MS SQL Server, because there is easier to program such features either in its procedural language or even it .net

这篇关于捕获对数据库所做的所有更改并将其邮寄给客户端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！