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

Re: recurring notifications

Subject: Re: recurring notifications
From: "skg"
Date: Sat, 11 Mar 2006 09:55:16 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thanks!!! Joe
"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> 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>