Events raised when table data changed SQL 2005, VB.NET 2005

[Guest]

My application is written in VB.NET 2005 to display a table of a SQL 2005 in
a datagrid. I want to be notified or capture events when table data changed
(inserted, deleted, updated by another user) to update the datagrid. Is there
any way to do this

Thanks
Doan Nguyen

 

[Guest]

My application is written in VB.NET 2005 to display a table of a SQL
2005 in a datagrid. I want to be notified or capture events when table
data changed (inserted, deleted, updated by another user) to update
the datagrid. Is there any way to do this

You can capture the data change events at the data table level.

However, if there are other applications changing the data... you'll need
to use something like SQL Server Notification Services or database polling.