ADO.NET 2.0 Merge/Load XML question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DataTable with three columns "UniqueID", "A" and "B".

Rather than pass updates like:

<DataTable UniqueID=1 A="data.." B="data.."/>


The application gets XML from a 3rd party and they want to economically send
data packets over the network like so:


<DataTable UniqueID=1 A="data.."/>
<DataTable UniqueID=13 B="data.."/>

Where only the changes are sent. Fair enough. But, the problem is that
when I read that string into a table, if I am missing a column (line 1 is
missing column B and line 2 is missing column A) and I do a merge update, the
missing columns wipes out the current values in the merged dataset. What I
want to do is update only the values that were passed - not wipe out data
because it WASN'T passed)

Any ideas?
 
CSS,

You need the schema while you are busy with XML files. You can have that as
XSD or you can set it in (AFAIK) one of the XML files.

I hope this helps,

Cor
 
Back
Top