DataSet.GetXml Preserve XML Declaration ???

[JSpicolli]

Hi,

Is there not a way to specify that a DataSet should Preserve the XML Declaration when calling DataSet.GetXml ?

I am using the DataSet only to Merge 2 XML strings.
After I merge the 2 dataSets, I then Call ds.GetXml to return the XML string with all the records merged into it.

I then pass that XML string as a param to a SQLXML sproc.

The only problem is that the proc always returns an empty node because it requires the XML Declaration, which the DataSet strips out when you call the GetXml method.

Anyone have a workaround?

Thanks.

 

[ThatRickGuy]

You could use DataSet.WriteXML, then read the file via a textstream or XML object.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[JSpicolli]

Thnx, I can write to a textstream and wrap it with a StringBuilder, then call sb.ToString to retrieve the XML and then manually insert the XML Declaration.

Now my issue is that the ds also strips out the namespace attribute of the root element.

I don't think I am going to be able to use the ds.merge method.

Anyone have another way to merge XML streams?