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();