Inserting a dataset into a SQL dB

Hi,

I am working on some code that retrieves a dataset with one table via a
webservice, and then needs to insert the dataset into the local client dB.
Both the client (MSDE) and Server (SQL2000) dBs have the same exact tables.

I have tried inserting the dataset directly into the client dB via the
update() method, with no luck. I have also tried creating a 2nd datset, and
merging the websvc dataset into it, which works fine. However, when
updating, now rows are added.

When I look at the RowState for either of the above cases, it appears as
unmodified. I would have thought in the merge case it should show as added?


As a last step, I manually modified one of the rows, and tried the update -
I now get a concurrency exception on the update call.


Any suggestions or articles you can recommend would be appreciated.