ADO Net C# Tutorial

  1. Home
  2. C# Tutorial
  3. ADO Net
  4. Persist a Dataset to an XML file
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");
  }
}