ch10_02.cs

来自「《c#技术内幕代码》」· CS 代码 · 共 49 行

using System; 
using System.Data; 
using System.Data.ADO; 

public class CH10_2
{ 
    
    public static void Main (String[] args)
    {
       // set Access connection and select strings
       string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+args[0];
       string strAccessSelect = "SELECT * FROM " + args[1];
 
       //Create the dataset and add the Categories table to it
       DataSet myDataSet = new DataSet();
       myDataSet.Tables.Add(args[1]);
       
       // create my Access objects
       ADOConnection myAccessConn = new ADOConnection(strAccessConn);
       ADODataSetCommand myAccessDataSetCmd = new ADODataSetCommand();
       myAccessDataSetCmd.SelectCommand = new ADOCommand(strAccessSelect,myAccessConn);
 
       myAccessConn.Open();
       try
       {
          myAccessDataSetCmd.FillDataSet(myDataSet,args[1]);
       }
       finally
       {
          myAccessConn.Close();
       }
 
       try
       {
          DataColumn[] drc = myDataSet.Tables[args[1]].Columns.All;
          int i = 0;
          foreach (DataColumn dc in drc)
          {
             Console.WriteLine("Column name[{0}] is {1}, of type {2}",i++ , dc.ColumnName, dc.DataType);
          }
       }
       catch (Exception e)
       {
          Console.WriteLine("Caught an exception:\n{0}", e.Message);
       }
    }
}