Obtain the names and fields of all tables in Access data.

--------------
// Obtain the Access database table name
Public void GetTableName ()
{
String connString = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source =" + @ "C: \ Information Technology Test Result. mdb ";
OleDbConnection conn = new OleDbConnection (connString );

Conn. Open ();
DataTable dt = conn. GetOleDbSchemaTable (OleDbSchemaGuid. Tables, new object [] {null, "TABLE "});

Conn. Close ();
Int n = dt. Rows. Count;
String [] tableName = new string [n];
Int m = dt. Columns. IndexOf ("TABLE_NAME ");
For (int I = 0; I <n; I ++)
{
DataRow dr = dt. Rows [I];
TableName [I] = dr. ItemArray. GetValue (m). ToString ();

This. cbxtable. Items. Add (tableName [I]. ToString ());
}
This. cbxtable. SelectedIndex = 0;

}

 

/// <Summary>
/// Return all field names of a table
/// </Summary>
Public List <string> GetTableColumn (string tableName)
{
String connString = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source =" + @ "C: \ information technology test. mdb ";
OleDbConnection conn = new OleDbConnection (connString );
List <string> list = new List <string> ();
DataTable dt = new DataTable ();
Try
{

Conn. Open ();
Dt = conn. GetOleDbSchemaTable (OleDbSchemaGuid. Columns, new object [] {null, null, tableName, null });
Int n = dt. Rows. Count;
String [] strTable = new string [n];
Int m = dt. Columns. IndexOf ("COLUMN_NAME ");
For (int I = 0; I <n; I ++)
{
DataRow dr = dt. Rows [I];
List. Add (dr. ItemArray. GetValue (m). ToString ());
}
Return list;
}
Catch (Exception ex)
{
Throw ex;
}
Finally
{
Conn. Close ();
}
}
Private void button3_Click (object sender, EventArgs e)
{

String str = this. cbxtable. SelectedItem. ToString ();
{
List <string> lst = GetTableColumn (str );
ListBox1.DataSource = lst;

}

}