Checking for changes on DB side?

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

Is there alway to check the data set agains a database to see if there have
been and changes made in the database since the last fill on the dataset
then get the changes? thanks.. I don't want to have to fill thousands of
rows each time... seems a waste...
 
First you try to load as few rows as possible.
Else you could use a method similar to optimistic locking i.e. selecting
those rows that have their timestamp changed (assuming this is quicker than
just selecting the whole set).

Describing the whole scenario may also help...

Patrice
 
already loading as few as possible.. I'm working with data that requires up
to 1,000 or more records to perserve referential integirty to be pulled into
a data set of multiple tables... was hopeing there was something that would
be able to find changes between the database and the dataset kinda like the
getchanges method of the data set can pull out the changed data...
 
Back
Top