关于对表的操作的一些收集

1、读取表名：

ArrayList result = new ArrayList();
    OleDbConnection myConn=new OleDbConnection(this.ConnectionString);
    myConn.Open();
    OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM Customer",myConn);
    OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
    DataSet thisDataSet=new DataSet();
    thisAdapter.Fill(thisDataSet,"Customer");
    DataTable myTable=thisDataSet.Tables["Customer"];
    foreach(DataColumn myCol in myTable.Columns)
    {
     result.Add(myCol.ColumnName.ToString());
    }
    myConn.Close(); 
    return result;

2、表的说明：

OleDbConnection oleDbConnection1=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"//First.mdb;");
   oleDbConnection1.Open();
   DataTable schemaTable = oleDbConnection1.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns,
    new object[] {null, null, "Student",null});

   System.Data.DataRowCollection drc=schemaTable.Rows;
   foreach(DataRow dr in drc)
   {
    textBox1.Text+=dr["COLUMN_NAME"]+":"+dr["DESCRIPTION"].ToString()+"/r/n";
   }

3、填充多表

using System.Data;
using System.Data.OleDb;
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"//First.mdb;");
    myConn.Open();
    //建立数据集
    DataSet thisDataSet=new DataSet();
    //建立适配器
    OleDbDataAdapter studentAdapter= new OleDbDataAdapter("SELECT * FROM Student",myConn);
    OleDbCommandBuilder studentBuilder=new OleDbCommandBuilder(studentAdapter);
    
    OleDbDataAdapter teacherAdapter= new OleDbDataAdapter("SELECT * FROM Teacher",myConn);
    OleDbCommandBuilder teacherBuilder=new OleDbCommandBuilder(teacherAdapter);
    
    OleDbDataAdapter genearchAdapter= new OleDbDataAdapter("SELECT * FROM Genearch",myConn);
    OleDbCommandBuilder genearchBuilder=new OleDbCommandBuilder(genearchAdapter);

        //填充
    studentAdapter.Fill(thisDataSet,"Student");
    teacherAdapter.Fill(thisDataSet,"Teacher");
    genearchAdapter.Fill(thisDataSet,"Genearch");
        myConn.Close();