Detecting Changes in Database Table from app

  • Thread starter Thread starter Dave.Womer
  • Start date Start date
D

Dave.Womer

All,

I'm trying to write some code that will detect changes in a database
table (like a record value modified) in SQL Server 2000.

I've tried to pull all records and place them in a dataset and merge
against existing records every few seconds but the DS Merge does not
seem to work.

Any suggestions on how to perform this operation without going cell by
cell? Are there any built in .NET funtions for this?
 
Dave,

Add triggers to the SQL Server tables to log each change. Then monitor the
log and update the Dataset intelligently.

Depending on your data needs, switching to a real-time database such was
www.polyhedra.com might also be an alternative.

Hope this helps
Ad.
 
Back
Top