microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: recurring notifications

Subject: Re: recurring notifications
From: Joe Webb
Date: Sat, 11 Mar 2006 07:34:10 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Since your question is about SqlDependency and Query Notifications,
you'll probably have more luck in another newsgroup - may
microsoft.public.sqlserver.programming. This one is for SQL Server
Notification Services.



-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On Fri, 10 Mar 2006 17:13:06 -0600, "skg" <[email protected]> wrote:

>Looks like i have to use threading!
>http://msdn2.microsoft.com/en-us/library/3ht3391b(VS.80).aspx
>
>"skg" <[email protected]> wrote in message 
>news:%[email protected]
>>i am finding the notification is triggered only once when the field changes 
>>first time. Its not triggered second time. How can i have it trigger 
>>everytime there is a change in the field.
>>
>> Here is code snippet. thx
>>
>> ...
>>
>> ..static void Main()
>>
>> {
>>
>> SqlCommand cmd = new SqlCommand("SELECT au_id, au_lname FROM dbo.authors", 
>> conn))
>>
>> SqlDependency depend = new SqlDependency(cmd, null,0);
>>
>> depend.OnChange += new OnChangeEventHandler(MyOnChanged);
>>
>> conn.Open();
>>
>> SqlDataReader rdr = cmd.ExecuteReader();
>>
>> ...
>>
>> ...
>>
>> }
>>
>> MyOnChanged(object caller, SqlNotificationEventArgs e)
>>
>> {
>>
>> Console.WriteLine("result has changed");
>>
>> Console.WriteLine("Source " + e.Source);
>>
>> Console.WriteLine("Type " + e.Type);
>>
>> Console.WriteLine("Info " + e.Info);
>>
>> }
>>
>>
>> 
>

<Prev in Thread] Current Thread [Next in Thread>