如何把代码针对SQLSERVER的代码改成针对ACCESS的？

Question

下面这段代码是针对SQLSERVER的，怎么改成针对ACCESS的？public static DataSet GetDataSet(string sql) 
                 { 
                   SqlConnection conn=new SqlConnection(); 
                   DataSet ds=new DataSet(); 
                   try 
                       { 
                        conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=MJKQ"); 
                        SqlDataAdapter sda=new SqlDataAdapter(sql,conn); 
                        sda.Fill(ds); 
                        return ds; 
                       } 
                   catch(Exception ex) 
                       {
                        throw(ex); 
                       }
                   finally 
                       {
                        conn.Close(); 
                       }
                 } 
         public bool ExecuteSQL(string sql) 
             {
              SqlConnection conn=new SqlConnection(); 
              try
                  {
                   conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=MJKQ"); 
                   SqlCommand sqlCmd =new SqlCommand(sql,conn); 
                   conn.Open(); 
                   sqlCmd.ExecuteNonQuery();
                   return true;
                  } 
              catch(Exception ex) 
                  {
                   return false;
                   throw ex;
                   
                  }
              finally 
                  {
                   conn.Close(); 
                  } 
              }
       public static SqlConnection getConnection()
       {
           SqlConnection conn = new SqlConnection();
           try
           {
               {
                   conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=MJKQ");
                   conn.Open();
               }
               return conn;
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.ToString());
               return null;
           }
       }

Answer 1

using System.Data.OleDb;public static DataSet GetDataSet(string sql)
        {
            OleDbConnection conn = new OleDbConnection();
            DataSet ds = new DataSet();
            try
            {
                conn = new OleDbConnection("连接字符串");
                OleDbDataAdapter sda = new OleDbDataAdapter(sql, conn);
                sda.Fill(ds);
                return ds;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                conn.Close();
            }
        }
        public bool ExecuteSQL(string sql)
        {
            OleDbConnection conn = new OleDbConnection();
            try
            {
                conn = new OleDbConnection("连接字符串");
                OleDbCommand sqlCmd = new OleDbCommand(sql, conn);
                conn.Open();
                sqlCmd.ExecuteNonQuery();
                return true;
            }
            catch (Exception ex)
            {
                return false;
                throw ex;            }
            finally
            {
                conn.Close();
            }
        }
        public static OleDbConnection getConnection()
        {
            OleDbConnection conn = new OleDbConnection();
            try
            {
                {
                    conn = new OleDbConnection("连接字符串");
                    conn.Open();
                }
                return conn;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return null;
            }
        }

Answer 2

结贴了，不过连接字符串要怎么写？
我写：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Persist Security Info=True;Jet OLEDB:Database Password=7772
插入的数据只在程序运行时有效，关掉程序数据就没人。也就是没有存入数据库文件中……