- using System.Data.OleDb;
- using System.Data;
- using System.Collections;
-
- //
- //Methodes de récupéraion des noms de Tables
- //
- public DataTable GetTables(OleDbConnection conn)
- {
- conn.Open();
- DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
- new object[] {null, null, null, "TABLE"});
- conn.Close();
- return schemaTable;
- }
-
- private void button1_Click(object sender, System.EventArgs e)
- {
- string source = "Provider=Microsoft.Jet.OLEDB.4.0;" +
- "Data Source = cheminde_la_base_de_donnees";
- OleDbConnection conn = new OleDbConnection(source);
- DataTable t = GetTables(conn);
- tableCheckedListBox.DataSource = t;
- tableCheckedListBox.DisplayMember = "TABLE_NAME";
- listBox1.DataSource = t;
- listBox1.DisplayMember = "TABLE_NAME";
- }
using System.Data.OleDb;
using System.Data;
using System.Collections;
//
//Methodes de récupéraion des noms de Tables
//
public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
conn.Close();
return schemaTable;
}
private void button1_Click(object sender, System.EventArgs e)
{
string source = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source = cheminde_la_base_de_donnees";
OleDbConnection conn = new OleDbConnection(source);
DataTable t = GetTables(conn);
tableCheckedListBox.DataSource = t;
tableCheckedListBox.DisplayMember = "TABLE_NAME";
listBox1.DataSource = t;
listBox1.DisplayMember = "TABLE_NAME";
}