Comparing data in a dataset with data in a database.

[mike55]

Hi all,

 

Have a dataset with the following structure:

ID, Name, mobile_numb, email_add, message

 

I also have a members table, with the following structure:

ID, Name, mobile_numb, email_add, addr1, addr2, addr3, town, county, country, dob, active.

 

The dataset contains some of the records that are stored in the database table. The dataset is loaded from another dataset that is stored in a session that was created and filled when the application was started.

 

What I need to do is to take the records in the above mentioned dataset and compare it with the data stored in the database table to verify that it is upto date and valide. I know that I can do this one record at a time, however is there anyway by which I can do a join compare, and if i find any differences I either return a boolean, or alternatively, I update my dataset using the data from the database.

 

Mike55.

[jmcilhinney]

If you would refresh the data if it was different then it might be just as easy to do that anyway. I'm guessing that a comparison would probably take just as long.