Persist a Dataset to an XML file : DataSet Xml « ADO.Net « C# / CSharp Tutorial






using System;
using System.Data;
using System.Data.OleDb;

class MainClass
{
  static void Main(string[] args)
  {                                                       
    OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = c:\\Northwind.mdb");
    OleDbDataAdapter MyAdapter = new OleDbDataAdapter("SELECT * FROM orders", MyConnection);
    DataSet MyDataSet = new DataSet();

    MyAdapter.Fill(MyDataSet, "orders");
    MyDataSet.WriteXml(@"c:\Sample.xml");
  }
}








32.34.DataSet Xml
32.34.1.Read an xml file into a dataset
32.34.2.Persist a Dataset to an XML file
32.34.3.Adding to DataSet and output to Xml
32.34.4.Output the XSD schema for the DataSet
32.34.5.Write Xml
32.34.6.Save DataSet to disk with schema
32.34.7.Pop DataSet
32.34.8.Transform Data
32.34.9.Create DataSet and DataTable