Get from a DataView to an XPathDocument

[Chris]

I want to get from a dataview to an XPathDocument.

I have tried the following:

System.IO.MemoryStream memstream = new System.IO.MemoryStream() ;
DataView.ToTable().WriteXml(memstream);

XPathDocument oXPathDocument = new XPathDocument(memstream);

My xPathDocument line crashes with the error "Root element is missing"

If I do my WriteXml to a file on disk it appears complete.

Anyone know what I need to do to get from a DataView to and xPathDocument? I
want to avoid writing anything to disk.

TIA,

Chris

[WenYuan Wang]

Hi Chris,

The position of stream should be set to "0", otherwise the stream will be
read from the ending.
memstream.Position = 0;

System.IO.MemoryStream memstream = new System.IO.MemoryStream() ;
DataView.ToTable().WriteXml(memstream);
memstream.Position = 0;
XPathDocument oXPathDocument = new XPathDocument(memstream);

Please test the above and let me whether or not this is what you need.

Hope this will help.
Wen Yuan

[Chris]

That did it.
This was a major help to me.
Thanks a lot.

Chris

""WenYuan Wang"" <v-******@online.microsoft.comwrote in message
news:aU**************@TK2MSFTNGHUB02.phx.gbl...

Hi Chris,

The position of stream should be set to "0", otherwise the stream will be
read from the ending.
memstream.Position = 0;

System.IO.MemoryStream memstream = new System.IO.MemoryStream() ;
DataView.ToTable().WriteXml(memstream);
memstream.Position = 0;
XPathDocument oXPathDocument = new XPathDocument(memstream);

Please test the above and let me whether or not this is what you need.

Hope this will help.
Wen Yuan

[WenYuan Wang]

You are welcome, Chris.

Have a great day!
Wen Yuan