ADO.NET 2.0 Merge/Load XML question

[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?

 

[Sahil Malik [MVP C#]]

Css.

You probably want to modify the updatecommand text as you go. You can do
that in the RowUpdating event.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

 

[Cor Ligthert [MVP]]

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