I am trying to merge 2 datasets, then commit one back to the database to save all updated/added records. Problem is, when I merge the two datsets, all the records in my target dataset come away with a rowstate of unchanged, even though they have indeed changed. Then none of the changes gets committed back to the db because they don't show up as Added or Modified.

dsOne(new/changed records)
dsTwo(basically a copy of the db table)

I want to merge dsOne --> into --> dsTwo, then
commit dsTwo(with new/modified records from dsOne) --> into --> db

How do I get around the rowstate issue?

Thanks