转载C# Tutorials，ADO\adosample.cs-.NET教程,C#语言

using system;
using system.data;
using system.data.ado;

public class mainclass
{
   public static void main ()
   {
      // set access connection and select strings
      string straccessconn = "provider=microsoft.jet.oledb.4.0;data source=bugtypes.mdb";
      string straccessselect = "select * from categories";

      //create the dataset and add the categories table to it
      dataset mydataset = new dataset();
      mydataset.tables.add("categories");
      
      // 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,"categories");
      }
      finally
      {
         myaccessconn.close();
      }

      try
      {
         /* a dataset can contain multiple tables,
           so lets get them all into an array */
         datatable[] dta = mydataset.tables.all;
         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.length);
         /* 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);
         datacolumn[] drc = mydataset.tables["categories"].columns.all;
         int i = 0;
         foreach (datacolumn dc in drc)
         {
            /* print the column subscript, then the
               columns name and its data type */
            console.writeline("column name[{0}] is {1}, of type {2}",i++ , dc.columnname, dc.datatype);
         }
         datarow[] dra = mydataset.tables["categories"].rows.all;
         foreach (datarow dr in dra)
         {
            /* print the categoryid as a subscript,
               then the categoryname */
            console.writeline("categoryname[{0}] is {1}", dr[0], dr[1]);
         }
      }
      catch (exception e)
      {
         console.writeline("oooops.  caught an exception:\n{0}", e.message);
      }
   }
}