There should not be any speed problem if I can use the Merge method. The thing here is, the Merge method seems to have problem when we add a new row and immediately delete it before we sent the DataSet for update.

Anyway, since nobody has an answer to this problem, I'll have to clear the dataset before merging with the updated dataset.

Thanks.