Hi,

I'll insert a row in a dataset, then to merging this with database,
after this, i sync my sqlservermobile database with the server,
all is ok, but if I'll fill the dataset (after syncing) this row
is duplicated with different guid (which is the key)

code:

datatable.Rows.Add(row)
DataSet changes = datatable.GetChanges()
datatable.Merge(changes)
datatable.AcceptChanges()

Syncing...

tableadapter.fill(datatable)
--> after this, the inserted row is duplicated but with a different
key (guid)

Any ideas?

THANK YOU!

Why are you mergning the changes back into the same dataset? This is creating your dup in the dataset and the db is assigning the new PK....Get your changes and then update the db

datatable.Update(Changes)

and if no error then call accept changes...

HTH

I solved the problem.

The insert statement didn't have the guid - column within. So the
database was updated with a new guid. On this update dataset
got the new row from database with new guid. Old row with own
generated guid still exists in dataset.

>> Why are you mergning the changes back into the same dataset? This is creating your dup in the dataset and the db is assigning the new PK....Get your changes and then update the db

--> if database calculates some values, i won't get the changes back if i don't merge
the inserted changes.

grepe