I need to populate a table with information then in a seperate utility,
in the same application, pull that data using the same criteria that
was first used and update some values, unique to an id, then save it,
also adding any rows that did not exist before. The user may exit the
application between using these utilities, but they may also move from
one utility to the next without exiting. Im sure I would start with
populating the data in a DataTable, save the DataTable to the database,
and pull the data into a new DataTable. Assuming that is true, my
question is, how would i go about updating the correct rows? Each row
will have its identity, and there will always be thousands of rows in a
selected set of data, millions in all, so iterating through and
checking each row would be very consuming. Any ideas? (or questions)