所有存在都是独创。
/// <summary> /// 取所有表名 /// </summary> /// <returns></returns> public List<string> GetTableNameList() { List<string> list = new List<string>(); OleDbConnection Conn = new OleDbConnection(ConnStr); try { if (Conn.State == ConnectionState.Closed) Conn.Open(); DataTable dt = Conn.GetSchema("Tables"); foreach (DataRow row in dt.Rows) { if (row[3].ToString() == "TABLE") list.Add(row[2].ToString()); } return list; } catch (Exception e) { throw e; } finally { if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); } } /// <summary> /// 取指定表所有字段名称 /// </summary> /// <returns></returns> public List<string> GetTableFieldNameList(string TableName) { List<string> list = new List<string>(); OleDbConnection Conn = new OleDbConnection(ConnStr); try { if (Conn.State == ConnectionState.Closed) Conn.Open(); using (OleDbCommand cmd = new OleDbCommand()) { cmd.CommandText = "SELECT TOP 1 * FROM [" + TableName + "]"; cmd.Connection = Conn; OleDbDataReader dr = cmd.ExecuteReader(); for (int i = 0; i < dr.FieldCount; i++) { list.Add(dr.GetName(i)); } } return list; } catch (Exception e) { throw e; } finally { if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); } }
