I can accomplish this relatively easily but inefficiently, and it seems like
a hack, but I cant think of a better workaround. Hopefully someone else here
can.
My task is to perform an update on a dataset retrieved from SQL Server 2000
using a stored procedure. This is the base dataset. Users will send an Excel
document up to a webserver and that excel document, which matches the schema
of the SQL dataset (few differences but nothing major), will be queried
using some inline SQL, and another dataset will be created from this
resultset.
The Excel dataset will contain differences that must be sent up to the SQL
dataset. Once this change is detected in the row, I need to update the
column(s), then once all updates are completed, save the SQL dataset (I dont
care about the Excel dataset; its essentially read only). I can loop through
the Excel dataset and compare column values using Datarows, but there are
upwards of 4000 rows between the 2 datasets, and this usually results in
timeouts.
I found an article that discusses how to do this (cant recall the URL right
now), but it didnt work in my scenario. What are my other options?