Hello

I have a table that has 9 columns, this table has about 5000 rows, but sometimes the user need to update the data in the table. The new data is in another table, with different columns names and only with 8 columns, the ninth column it's the date of the update (i know that this columns shouldn't be here...).

So for now i'm filing one datatable (the data come form a webservice that returns a dataset with this table), and after that i clean the original table and then for each row in the new datatable i call the insert command.

Is there other way, better way, to do this?

My head it's kind of messed up this morning... and i can think right.

Thanks