using System;
using System.Data;
using db = System.Data.OleDb;
// File: DataSetFillViaDataAdapter.cs(.txt)
// (Re)written  By: Dan Garlen February 2004
//  as part of a C# ADO.NET demonstration series
//  Requires: ConsoleUtilityRoutines.cs & C:\TestData\Northwind.mdb

namespace ADOdotNET_Demos
{
   public class DataSetFillViaDataAdapter
   {
      public static string strSQL = "SELECT * FROM [Customers]";
      public static string strMDB = "C:\\TestData\\Northwind.mdb";
      public static string strDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data source =" + strMDB; 
      static void Main(string[] args)
      {
         cur.Title("DataSet Fill Via DataAdapter");
         Demo();
         cur.Footer();
      }
      public static void Demo()
      {
         try
         {
            db.OleDbConnection cn = new db.OleDbConnection(strDB); 
            cn.Open();
            db.OleDbDataAdapter da =  new db.OleDbDataAdapter(strSQL,cn) ;
            DataSet ds = new DataSet(); 
            da.Fill(ds, "MyTableName");
            cur.ShowDataSet(ds);
            cn.Close();
         }
         catch (Exception ex) {cur.WL("DB Error", ex.Message.ToString());}
      }
   }
}