DataRow to XML

[nashak]

Hello,

I am creating a datarow (new or existing) in my data-tier and passing
it to my business tier where it is filled with data and then passed
back to data-tier to be inserted into the table.

I need to keep original and updated versions of the datarow in xml
format. Just need the datarow in xml format. So basically I need two
strings - string1 containing data from initial state of datarow and
string2 containing data from updated state of datarow.

I think that xml read/write can only be done via datasets and not via
datarow. Can anyone provide any pointers?

Thanks

 

[Cor Ligthert]

Nashak,

Although I don't see the sence does this article describe in my idea what
you are looking for.
http://msdn.microsoft.com/msdnmag/issues/03/05/real-worldxml/default.aspx?fig=true#fig10

That is not Adonet by the way, when you want to write datarows than you
should use the datatable and the dataset to access those.

Cor

 

[Sahil Malik]

Nashak,

What database are you using? can you just do For XML? (Sql Server)

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[nashak]

Hello,

This is for SQl Server 2000.

What is For XML?

Thanks,

 

[Sahil Malik]

For XML is something like this ..

Select * from NashaksTable For XML Auto.

Run it .. and see the results for a nice surprise

BTW, once you do - also check out SqlXml, SqlXmlDataAdapter, and of course
SqlCommand.ExecuteXmlQuery.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Sahil Malik]

And since you do have my book handy .. check out Chapter #12

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik