Issue passing DataSet as XML from WebService

[Andy]

Hello,
I have a WebService that sends a client a DataSet as XML (I use a
DataSet.GetXml to get the XML). The DataSet is filled by a DataAdapter
in the WebService. The client coverts the XML Back to a DataSet (using
StringReader sr = new StringReader(xml); DataSet ds = new DataSet();
ds.ReadXml(sr)).
The client then makes changes to this DataSet, and sends the dirty dataset
back to the WebService using another GetXml on 'ds'.

The WebService re-converts the xml into a DataSet (using a DataSet ds = new
DataSet(); ds.ReadXml; )and executes a DataAdapter.Update(ds).

The problem is, all the rows in the dirty dataset passed back from the
client get appended to the DataBase with new primary keys (the primary key
field is autogenerated in the database) (instead of only the dirty rows
getting updated.) Am I doing something wrong?

Please help.

Best,
Andy

[Chris Lovett]

Do something like this:
DataSet ds = new DataSet();
ds.ReadXml("datafromserver.xml");
ds.AcceptChanges(); // accept all this data

// then make your edits, and write out just the new stufff:

DataSet diff = ds.GetChanges();
diff.WriteXml(@"..\..\diff.xml", XmlWriteMode.DiffGram);

// and send that back to the server

On the server you can merge the changes in using the Merge method.
"Andy" <av*****@e-470.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hello,
I have a WebService that sends a client a DataSet as XML (I use a
DataSet.GetXml to get the XML). The DataSet is filled by a DataAdapter
in the WebService. The client coverts the XML Back to a DataSet (using
StringReader sr = new StringReader(xml); DataSet ds = new DataSet();
ds.ReadXml(sr)).
The client then makes changes to this DataSet, and sends the dirty dataset
back to the WebService using another GetXml on 'ds'.

The WebService re-converts the xml into a DataSet (using a DataSet ds = new DataSet(); ds.ReadXml; )and executes a DataAdapter.Update(ds).

The problem is, all the rows in the dirty dataset passed back from the
client get appended to the DataBase with new primary keys (the primary key
field is autogenerated in the database) (instead of only the dirty rows
getting updated.) Am I doing something wrong?

Please help.

Best,
Andy