Hello. I am working on a page that has 4 SQLDataSource controls. These controls pull from a MSSQL Version 10.0 database server using a connection string stored in web.config. These controls populate gridviews and detail views that are for registration. 3
or 4 people *could* be adding people at the same time, so I'd like to use SQLDependency to push out when a new record is added. The tutorials I've found so far involve quite a bit of code that does not seem to relate to my particular scheme. Can anyone point
me to a good, clear example of how to do this? On the server side I've already set the Subscribe Query Notifications for the account the page uses to connect with, and created a que and a service for this action (as the tutorials said to do) but the asp.net
side is where I'm stuck.
spokey
Member
111 Points
79 Posts
SQLDataSource control and SQLDependency
Feb 16, 2011 02:13 PM|LINK
Hello. I am working on a page that has 4 SQLDataSource controls. These controls pull from a MSSQL Version 10.0 database server using a connection string stored in web.config. These controls populate gridviews and detail views that are for registration. 3 or 4 people *could* be adding people at the same time, so I'd like to use SQLDependency to push out when a new record is added. The tutorials I've found so far involve quite a bit of code that does not seem to relate to my particular scheme. Can anyone point me to a good, clear example of how to do this? On the server side I've already set the Subscribe Query Notifications for the account the page uses to connect with, and created a que and a service for this action (as the tutorials said to do) but the asp.net side is where I'm stuck.
Thanks!