MedicRanger
Member
- Joined
- Apr 19, 2003
- Messages
- 6
Hi, need some pointers in the right direction.
I have three clients written in VB.net that retrieve data from a SQL server database. Each client watches the same table in the form of a datagrid.
I would like it if when one client modifies data in the SQL table, it will automatically update the other clients view.
I can get away with just having it refresh every 10 seconds or so, but my main goal is to have it automatically refresh instantaneously once an update is made to the database. The nature of the application depends on up-to-the second accurate information.
Are there events that I can hook onto in SQL so that my clients can listen to them and trigger a subroutine that will update my datasets automatically?
any help will be appreciated. Thanks!
I have three clients written in VB.net that retrieve data from a SQL server database. Each client watches the same table in the form of a datagrid.
I would like it if when one client modifies data in the SQL table, it will automatically update the other clients view.
I can get away with just having it refresh every 10 seconds or so, but my main goal is to have it automatically refresh instantaneously once an update is made to the database. The nature of the application depends on up-to-the second accurate information.
Are there events that I can hook onto in SQL so that my clients can listen to them and trigger a subroutine that will update my datasets automatically?
any help will be appreciated. Thanks!