OleDbConnection conn = new OleDbConnection( "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\database.mdb;Persist Security Info=False;");// retrieving schema for a single tableOleDbCommand cmd = new OleDbCommand("tablename", conn);cmd.CommandType = CommandType.TableDirect;conn.Open();OleDbDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);DataTable schemaTable = reader.GetSchemaTable();reader.Close();conn.Close();LogFile.WriteLine(" ");foreach (DataRow r in schemaTable.Rows){ LogFile.WriteLine(" "); foreach (DataColumn c in schemaTable.Columns) { LogFile.WriteLine(c.ColumnName + ": " + r[c.ColumnName]); }}MessageBox.Show("done");
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend