c#操作Access数据库

不带密码的连接字符串
           Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/nopassword.mdb

带密码的连接字符串
          Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/password.mdb;Persist Security Info=True;User ID=Admin;Jet OLEDB:Database Password=123

获取数据库里的所有表

         public   string [] GetTables( string  DBName)
         ... {
            OleDbConnection conn = new OleDbConnection();
            try
            ...{
                conn.ConnectionString =ConnString;
                conn.Open();
                //此处的"Table"相当于SQL语名中Where后面的值
                DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] ...{ null, null, null, "TABLE" });
                conn.Close();
                List<string> result = new List<string>();
                for (int i = 0; i < dt.Rows.Count; i++)
                ...{
                    result.Add(dt.Rows[i]["TABLE_NAME"].ToString());
                }
                return result.ToArray();
            }
            catch (Exception ex)
            ...{
                throw new Exception(ex.Message);
            }
            finally
            ...{
                if (conn.State != ConnectionState.Closed)
                ...{
                    conn.Close();
                }
            }
            
        }

 

获取数据库指定表里的所有字段

         public   string [] GetFields( string  DBName,  string  TableName)
         ... {
            OleDbConnection conn = new OleDbConnection();
            try
            ...{
                conn.ConnectionString = ConnString;
                conn.Open();
                DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns ,new object[] ...{ null, null, TableName, null });
                conn.Close();
                List<string> result = new List<string>();
                for (int i = 0; i < dt.Rows.Count; i++)
                ...{
                    result.Add(dt.Rows[i]["Column_Name"].ToString());
                }
                    return result.ToArray ();
            }
            catch (Exception ex)
            ...{
                throw new Exception(ex.Message);
            }
            finally
            ...{
                if (ConnectionState.Closed != conn.State)
                ...{
                    conn.Close();
                }
            }
        }