本文介绍了如何在csharp中创建触发器并在执行触发器时执行操作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我希望 c #windows应用程序 发送短信 当任何记录成功添加到SQL Server 2008中的特殊表时 i发送短信没有任何问题。 只希望短信发送的时间。 我想要一些窗口表单,用于设置短信面板设置,联系号码和..现在我想要一些如下所示:
I want c# windows application for send sms when any record added successfully to special table in SQL Server 2008 i have not any problem with send SMS . only want the time that SMS should send . I want have a some windows form for set SMS Panel Setting , Contact Numbers and ... Now i want some thing like below :
1-What is best method for doing this 2-Can i create trigger from windows application and detect it when execute (i know that i can create trigger in clr project but clr project don’t have a form for UI ) 3-How do i detect when trigger accured ?我是新手,请使用简单给我的指示 非常感谢
I AM Novice , Please use the simple Instructions for me Thanks a lot
推荐答案我想,你可以用SQLDependency Class [ ^ ],提供当数据库中的数据发生变化时接收通知的功能。 这是一个很好的例子:使用SqlDependency进行数据更改事件 [ ^ ] I think, you can use SQLDependency Class[^], which provides functionality to receive notifications when the data in the database have changed. Here is an excellent example: Using SqlDependency for data change events[^]
更多推荐
如何在csharp中创建触发器并在执行触发器时执行操作
发布评论