I am trying to figure out the best way to read data and upload changes in C#. I currently read in the data and update each and every field on each and every line whether or not there are any changes. Of course, this takes forever. I am wanting to know if anyone here has used the DataTable object enough to tell me whether or not it is reliable enough to do updates. What I mean by that is this... can you design a dataset that mocks the database, takes it offline, and does comparisions of certain fields and then tells you the set of rows that need to be updated in what table. I'm looking for something that will allow me to take the data from the database and compare it to the data that i get from a data dump.

Data Layout:




if more info would be useful in determining the best way to do this, please let me know what would help. I think that i'm on the right track with using dataset / datatable but i wanted to make sure before i make a large investment in using it.

Thanks

Hi

There is something about the process that seems to be the hard way to do this job.

A good quality RDBMS would manage this without ever needing to be taken off line. If you really need to have a comaprison between offline and online, the best technique is like this: