Ming Man Chan's Blog

I found the easiest way to write a table or even tables from database to XML file is in.NET languages. To do this in Java you might probably need to include not only one but few proprietary library or open source jar file.

To do this in C#, one of the .NET languages, there is no additional reference need to be added to the project. Only using System.Data is needed because of the Dataset.

The code segment that writes dataset to XML file as follow (the code segment is from MSDN library):

    static 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);

      // Write to the file with the WriteXml method.

      thisDataSet.WriteXml(stream);

}

The complete code to extract the data from employee table of HR schema to XML from is in http://skydrive.live.com. The sample file name is ConsoleDatasettoXML .zip. My MSN ID is chanmmn@hotmail.com.