要知道何时输入新的sql记录 [英] To know when, new sql record is entered

问题描述

我是programmig的新手。我想在新记录插入sql database.i时发送消息我正在使用ASP.net 2008 C＃。

i new in programmig. i want to send a message as soon as the new record inserted in to the sql database.i am using ASP.net 2008 C#.

这是数据库表

姓名  phoneno

Name   phoneno

michal  xxxxxx1

michal  xxxxxx1

kathy  xxxxxx2     新输入 记录

kathy   xxxxxx2      newly entered record

我想发送短信，包括姓名'kathy' 到相关的phoneno。

i want to send sms including name 'kathy'  to related phoneno.

sms部分没问题。

sms part is ok.

但我想知道如何注意到输入了新记录，然后使用C＃中的计时器自动发送短信。

but i want to know how to noticed a new record is entered and then send sms automatically using a timer in C#.

EX： -   if（sql table.new Recod Entered）      //这仅供参考说明

EX:-  if(sql table.new Recod Entered)      //this is for explanation only

{

发送短信

}

 

我是否使用触发器或视图。

do i use Triggers or views.

 

 

推荐答案

您好apra123，

Hi apra123,

我认为您的论坛错误对于这个问题。尽管您可能希望在智能设备上使用它，但问题看起来更具体针对SQL Server通知。

I think you are in the wrong forum for this question. Even though it might be that you want to use it on a smart device, the question looks more specific for SQL Server notifications.

请查看此论坛

http://social.msdn.microsoft.com/Forums/en-US/sqlnotificationservices/

http://social.msdn.microsoft.com/Forums/en-US/sqlnotificationservices/

您可以在多个地方找到更多信息

More information you can find in several places

http://www.codeproject.com/KB/dotnet/sqlns.aspx

http://www.codeproject.com/KB/dotnet/sqlns.aspx

http://www.techrepublic.com/article/e-mail-notifications -made-easy-with-sql-server-notification-services / 1050007

http://www.techrepublic.com/article/e-mail-notifications-made-easy-with-sql-server-notification-services/1050007

http://msdn.microsoft.com/en-us/library/Aa226871

http://msdn.microsoft.com/en-us/library/Aa226871

希望你能在那里找到你的信息。

Hope you can find your information there.

这篇关于要知道何时输入新的sql记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！