对MDB文件的操作

//Copyright (C) Microsoft Corporation.  All rights reserved.

// OleDbSample.cs
// To build this sample from the command line, use the command:
// csc oledbsample.cs

using System;
using System.Data;
using System.Data.OleDb;
//using System.Xml.Serialization;

public class MainClass
{
 public static void Main ()
 {
  // Set Access connection and select strings.
  // The path to BugTypes.MDB must be changed if you build the sample
  // from the command line:
#if USINGPROJECTSYSTEM
  string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BugTypes.MDB";
#else
        //MDB文件的连接字符串，这里特别注意的地方“.//.//BugTypes.MDB”表示当前工程的目录，不是/bin/Debug下面的目录
        string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.//.//BugTypes.MDB";
#endif
  string strAccessSelect = "SELECT * FROM Categories";
        System.Console.WriteLine(AppDomain.CurrentDomain.BaseDirectory.ToString() ); 
  // Create the dataset and add the Categories table to it:
  DataSet myDataSet = new DataSet();
  OleDbConnection myAccessConn = null;
  try
  {
   myAccessConn = new OleDbConnection(strAccessConn);
  }
  catch(Exception ex)
  {
   Console.WriteLine("Error: Failed to create a database connection. /n{0}", ex.Message);
   return;
  }

  try
  {
   OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect,myAccessConn);
   OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);

   myAccessConn.Open();
   myDataAdapter.Fill(myDataSet,"Categories");

  }
  catch (Exception ex)
  {
   Console.WriteLine("Error: Failed to retrieve the required data from the DataBase./n{0}", ex.Message);
   return;
  }
  finally
  {
   myAccessConn.Close();
  }

  // A dataset can contain multiple tables, so let's get them all
  // into an array:
  DataTableCollection dta = myDataSet.Tables;
  foreach (DataTable dt in dta)
  {
   Console.WriteLine("Found data table {0}", dt.TableName);
  }
    
  // The next two lines show two different ways you can get the
  // count of tables in a dataset:
  Console.WriteLine("{0} tables in data set", myDataSet.Tables.Count);
  Console.WriteLine("{0} tables in data set", dta.Count);
  // The next several lines show how to get information on a
  // specific table by name from the dataset:
  Console.WriteLine("{0} rows in Categories table", myDataSet.Tables["Categories"].Rows.Count);
  // The column info is automatically fetched from the database, so
  // we can read it here:
  Console.WriteLine("{0} columns in Categories table", myDataSet.Tables["Categories"].Columns.Count);
  DataColumnCollection drc = myDataSet.Tables["Categories"].Columns;
  int i = 0;
  foreach (DataColumn dc in drc)
  {
   // Print the column subscript, then the column's name and its
   // data type:
   Console.WriteLine("Column name[{0}] is {1}, of type {2}",i++ , dc.ColumnName, dc.DataType);
  }
  DataRowCollection dra = myDataSet.Tables["Categories"].Rows;
  foreach (DataRow dr in dra)
  {
   // Print the CategoryID as a subscript, then the CategoryName:
   Console.WriteLine("CategoryName[{0}] is {1}", dr[0].ToString() , dr[1].ToString());
  }
        System.Console.ReadLine();
 }
}