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

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/is...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

Nashak,

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

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



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Hello,

This is for SQl Server 2000.

What is For XML?

Thanks,

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



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> This is for SQl Server 2000.
>
> What is For XML?
>
> Thanks,
>

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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> This is for SQl Server 2000.
>
> What is For XML?
>
> Thanks,
>