Access查詢表名和字段名

1、訪問ACCESS 數(shù)據(jù)庫我使用的是Oledb 方式來訪問的。代碼如下： sqlConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new Objectnull,null,null,Table);此代碼返回的即是該數(shù)據(jù)庫中所有的數(shù)據(jù)表清單， 返回值為DataTable，你可以以此為數(shù)據(jù)源綁定到 DataGrid 中，來查看其內(nèi)部數(shù)據(jù)結(jié)構(gòu)。來具體獲取自己所需要內(nèi)容。其中sqlConn 是一個已經(jīng)打開的OleDB 數(shù)據(jù)連接的實例。sqlConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,new Objectnu

2、ll,null,strTableName,null);此代碼返回的是指定數(shù)據(jù)表中的數(shù)據(jù)列的清單，返回值為 DataTable，你可以將此綁定到 DataGrid 中，來查看其內(nèi)部數(shù)據(jù)結(jié)構(gòu)，來獲取自己所需的具體內(nèi)容。其中 sqlConn 是一個已經(jīng)打開的 OleDB 數(shù)據(jù)連接的實例。參數(shù)strTableName 是指定的數(shù)據(jù)表名稱。獲取所有表string connnectionString = Provider=Microsoft.Jet.OleDb.4.0;DataSource= + Xtxx.db.dbwz;OleDbConnection connectionne=w OleDbConnec

3、tion(connnectionString);connection.Open();DataTable table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object null, null, null, TABLE );foreach (DataRow row in table.Rows)TreeNode treeNodene=w TreeNode(); treeNode.Tag數(shù)=據(jù)表;treeNode.Text = roTwABLE_NAME.ToString();tvSjk.SelectedNode.No

4、des.Add(treeNode);connection.Close();獲取數(shù)據(jù)表詳細(xì)信息string connnectionString = Provider=Microsoft.Jet.OleDb.4.0;DataSource= + Xtxx.db.dbwz;OleDbConnection connectionne=wOleDbConnection(connnectionString);connection.Open();DataTable table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object

5、 null, null, sjbmc, null );int i = 0;dgv.Rows.Clear();foreach (DataRow row in table.Rows)dgv.Rows.A1d)d;(dgv.Rowsi.Celldsgv_Mc.Value = rowCOLUMN_NAME.ToString();/字段名稱int lx = int.Parse(rowDATA_TYPE.ToString();/字段類型switch (lx)case 2: dgv.Rowsi.Cellsdgv_Lx.Value = int; break; case 3: dgv.Rowsi.Cellsdg

6、v_Lx.Value = int; break; case 4: dgv.Rowsi.Cellsdgv_Lx.Value = Single; break; case 5: dgv.Rowsi.Cellsdgv_Lx.Value = double; break; case 6: dgv.Rowsi.Cellsdgv_Lx.Value = decimal; break;case 7: dgv.Rowsi.Cellsdgv_Lx.Value = DateTime; break; case 11: dgv.Rowsi.Cellsdgv_Lx.Value = bool; break; case 17:

7、dgv.Rowsi.Cellsdgv_Lx.Value = byte; break; case 72: dgv.Rowsi.Cellsdgv_Lx.Value = string; break;case130:dgv.Rowsi.Cellsdgv_Lx.Value=string; break;case131:dgv.Rowsi.Cellsdgv_Lx.Value=decimal; break;case128:dgv.Rowsi.Cellsdgv_Lx.Value=string; break;default: dgv.Rowsi.Cellsdgv_Lx.Value = string; break;

8、dgv.Rowsi.Cellsdgv_Lx.Tag = dgv.Rowsi.Cellsdgv_Lx.Value.ToString();dgv.Rowsi.Celldsgv_Yxk.Value = bool.Parse(rowIS_NULLABLE.ToString();/允許空dgv.Rowsi.Celldsgv_Ms.Value =rowDESCRIPTION.ToString();/字段說明、描述dgv.Rowsi.Celldsgv_Zj.Value = false;i+;table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Primary_Keys, null);/主鍵foreach (DataRow row in table.Rows)if (sjbmc = rowTABLE_NAME.ToString()for (int j = 0; j dgv.RowCount