获取Access中所有表和所有表字段属性的完美解决办法!

韩冰

<>获取Access中所有表和所有表字段属性的完美解决办法!不需要引用ADOX </P>
<>//schemaTable将取到所有用户表的信息,schemaTable取到指定表名的表的所有信息
$ i' [: K: d# `* q+ A! _  sOleDbConnection conn = new OleDbConnection(strConn);
   conn.Open();
7 @+ m( \9 i' S5 M; G1 j9 O. O  i   DataTable schemaTable  = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new Object[]{null, null, null, "table"});
DataTable schemaTable2  = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new Object[]{null, null, /*tablename*/, null});
0 q, B! X' v& fconn.Close();</P>
<>