Dataset - Database Synchronisation

[Steve]

is there a way of getting a dataset to automatically update the database
when there are changes ???

i.e. dont want to have to call update via a button click or something like
that


cheers guys



Steve

 

[Nicholas Paldino [.NET/C# MVP]]

Steve,

No, there is not. I mean, you could go about polling the database, and
updating the dataset if you know there are changes.

In SQL Server 2005, you can use SQL Notification services to be notified
when something changes in the database you are watching. If you are using
another DB technology, then you will need to implement a polling mechanism
(a timer that performs a select every time it fires) to determine when
changes occur (but the downfalls of this mechanism should be obvious).

Hope this helps.