Comparing two datasets (looking for row updates rather than adding new row)

mike55

mike55

Well-known member
Joined
Mar 26, 2004
Messages
726
Location
Ireland
Hi,

Have two datasets with the same structures, the first dataset would have been filled when the user entered the particular page, while the second will have been filled when the user clicks on an action button.

What I need to do is to compare the two datasets to determine if there has been changes made to the data during the interval between when the first and second datasets were loaded. I have been able to merge the two datasets and determine if there have been any new rows added, however if am unable to determine if any of the existing rows have been modified.

Any suggestions?? I know that I could do a comparison row by row, however i dont believe that is feasible in my situation.

Mike55
 
mike55 said:
Hi,

Have two datasets with the same structures, the first dataset would have been filled when the user entered the particular page, while the second will have been filled when the user clicks on an action button.

What I need to do is to compare the two datasets to determine if there has been changes made to the data during the interval between when the first and second datasets were loaded. I have been able to merge the two datasets and determine if there have been any new rows added, however if am unable to determine if any of the existing rows have been modified.

Any suggestions?? I know that I could do a comparison row by row, however i dont believe that is feasible in my situation.

Mike55
Click to expand...

When the user is clicking on the action button, is there a write to the db you could trap with the new data and determine what is being changed at this point, rather than trying to compare the two datasets after the write, or is this just a new pull from the db with some other alterations happening via a different process in the elapsed time from page-load to button push?
 
Back
Top