Dataset - Database Synchronisation

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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.
 
Back
Top