XML Declaration is missing when I convert a dataset to xml

[Todd]

This is my first time trying to take the results of a query that
reside in a Dataset and convert the dataset into an xml file.
Everything works great, except that my resulting XML file is missing
the xml declaration (the first line): <?xml version="1.0"
encoding="iso-8859-1"?>

Below is an example of the code I am using:
dataset.Namespace = "RatesXML"
Dim xmlFilename As String = "myXmlDocument.xml"
Dim fsWriteXml As New System.IO.FileStream(xmlFilename,
System.IO.FileMode.Create)
Dim xmlWriter As New
System.Xml.XmlTextWriter(fsWriteXml,System.Text.En coding.Unicode)
dataset.WriteXml(xmlWriter)
fsWriteXml.Close()
dataset.Dispose()
Dim newDataSet As New DataSet("New DataSet")
Dim fsReadXml As New System.IO.FileStream(xmlFilename,
System.IO.FileMode.Open)
Dim myXmlReader As New System.Xml.XmlTextReader(fsReadXml)
newDataSet.ReadXml(myXmlReader)
myXmlReader.Close()

I get back my xml file with all the children and elements as expected,
except the declaration is not present. How can I get the xml
declaration to appear in the new xml file? I assume it is an option
that I can add. Thank you.

[Oleg Tkachenko [MVP]]

Todd wrote:

This is my first time trying to take the results of a query that
reside in a Dataset and convert the dataset into an xml file.
Everything works great, except that my resulting XML file is missing
the xml declaration (the first line): <?xml version="1.0"
encoding="iso-8859-1"?>

Below is an example of the code I am using:
dataset.Namespace = "RatesXML"
Dim xmlFilename As String = "myXmlDocument.xml"
Dim fsWriteXml As New System.IO.FileStream(xmlFilename,
System.IO.FileMode.Create)
Dim xmlWriter As New
System.Xml.XmlTextWriter(fsWriteXml,System.Text.En coding.Unicode)

So if you want iso encoding, why do you write it as Unicode? Write it in
ISO-8859-1 encoding.

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

[Shane Cook]

private void WriteXmlToFile(DataSet thisDataSet)
{
if (thisDataSet == null) { return; }

// Create a file name to write to.
string filename = "XmlDoc.xml";

// Create the FileStream to write with.
System.IO.FileStream stream = new System.IO.FileStream
(filename, System.IO.FileMode.Create);

// Create an XmlTextWriter with the fileStream.
System.Xml.XmlTextWriter xmlWriter =
new System.Xml.XmlTextWriter(stream,
System.Text.Encoding.Unicode);

// Write Declarative with 'Standalone' attribute set to 'yes'.
xmlWriter.WriteStartDocument(true);

// Write to the file with the WriteXml method.
thisDataSet.WriteXml(xmlWriter);
xmlWriter.Close();
}

Shane Cook