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.Namespa ce = "RatesXML"
Dim xmlFilename As String = "myXmlDocument. xml"
Dim fsWriteXml As New System.IO.FileS tream(xmlFilena me,
System.IO.FileM ode.Create)
Dim xmlWriter As New
System.Xml.XmlT extWriter(fsWri teXml,System.Te xt.Encoding.Uni code)
dataset.WriteXm l(xmlWriter)
fsWriteXml.Clos e()
dataset.Dispose ()
Dim newDataSet As New DataSet("New DataSet")
Dim fsReadXml As New System.IO.FileS tream(xmlFilena me,
System.IO.FileM ode.Open)
Dim myXmlReader As New System.Xml.XmlT extReader(fsRea dXml)
newDataSet.Read Xml(myXmlReader )
myXmlReader.Clo se()

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.Namespa ce = "RatesXML"
Dim xmlFilename As String = "myXmlDocument. xml"
Dim fsWriteXml As New System.IO.FileS tream(xmlFilena me,
System.IO.FileM ode.Create)
Dim xmlWriter As New
System.Xml.XmlT extWriter(fsWri teXml,System.Te xt.Encoding.Uni code)

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.FileS tream stream = new System.IO.FileS tream
(filename, System.IO.FileM ode.Create);

// Create an XmlTextWriter with the fileStream.
System.Xml.XmlT extWriter xmlWriter =
new System.Xml.XmlT extWriter(strea m,
System.Text.Enc oding.Unicode);

// Write Declarative with 'Standalone' attribute set to 'yes'.
xmlWriter.Write StartDocument(t rue);

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

Shane Cook