Query Notifications not working properly

Hi all, 

I'm setting up a small presentation for a local .net user
group and one
of the things I'm demoing is the Query Notifications with
Service
Broker.

I have the following directive on my Default.aspx page:

 

<OutputCache
SqlDependency="CommandNotification"
Duration="100000"
VaryByParam="False" %>

 

I'm using a GridView with a SqlDataSource  that makes an ad
hoc query
into a table in the AdventureWorks database (the
selectcommand property
is an adhoc query).

 

I start the SQLDependency when my application starts and
Service Broker
is enabled in the AdventureWorks database.

 

Perhaps this is a very easy thing to solve, but my grid
never refreshes
the data. I run update command on that table and nothing
happens in the
UI.

I have the EnableCaching property set to false on the
SqldataSource.

 

Any comment is more than welcome, thanks in advance,

 

 

Lizet

 


===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com