用ADO连接对象的openschema方法就可以了 dim cnn as new adodb.connection() dim rs as adodb.recordset() dim strcnn as string strcnn="你要连接的信息" cnn.open(strcnn) rs=cnn.openschema(adSchemaTables)
我只在SQL数据库中找到了sysobjects表,可在Access中怎么办嘞?
How do I get a list of all tables of an Access database? Source: C# Corner Discussion Forms Using GetOleDbSchemaTable method of OleDbConnection class. public DataTable GetTables(OleDbConnection conn) { conn.Open(); DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"}); conn.Close(); return schemaTable; }
dim cnn as new adodb.connection()
dim rs as adodb.recordset()
dim strcnn as string
strcnn="你要连接的信息"
cnn.open(strcnn)
rs=cnn.openschema(adSchemaTables)
Using GetOleDbSchemaTable method of OleDbConnection class.
public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
conn.Close();
return schemaTable;
}