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

1. C# / CSharp Tutorial
2. ADO.Net
3. DataSet Xml

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");
  }
}