获取access所有表和字段
阅读(6) 评论(0) 发表时间:2008年07月30日 17:52
本文地址:http://www.cnblogs.com/huangxb/admin/javascript
1
private
static
void
getExcelFileInfo(
string
Path)
2 {
3 string strConn = " Provider=Microsoft.Jet.OLEDB.4.0; " + " Data Source= " + Path;
4 System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConn);
5 if (conn.State == ConnectionState.Closed)conn.Open();
6 System.Data.DataTable table = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null );
7 foreach (System.Data.DataRow drow in table.Rows)
8 {
9 string TableName = drow[ " Table_Name " ].ToString();
10 Console.WriteLine(TableName + " : " );
11 System.Data.DataTable tableColumns = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, new object [] { null , null , TableName, null });
12 foreach (System.Data.DataRow drowColumns in tableColumns.Rows)
13 {
14 string ColumnName = drowColumns[ " Column_Name " ].ToString();
15 Console.WriteLine( " " + ColumnName);
16 }
17 }
18 Console.ReadKey( true );
19 }
20
2 {
3 string strConn = " Provider=Microsoft.Jet.OLEDB.4.0; " + " Data Source= " + Path;
4 System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConn);
5 if (conn.State == ConnectionState.Closed)conn.Open();
6 System.Data.DataTable table = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null );
7 foreach (System.Data.DataRow drow in table.Rows)
8 {
9 string TableName = drow[ " Table_Name " ].ToString();
10 Console.WriteLine(TableName + " : " );
11 System.Data.DataTable tableColumns = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, new object [] { null , null , TableName, null });
12 foreach (System.Data.DataRow drowColumns in tableColumns.Rows)
13 {
14 string ColumnName = drowColumns[ " Column_Name " ].ToString();
15 Console.WriteLine( " " + ColumnName);
16 }
17 }
18 Console.ReadKey( true );
19 }
20