private staticstring connStr = @"Provider= Microsoft.Ace.OLEDB.12.0;Data Source = d:/login.accdb";

 privatestatic stringconnStr =@"Provider = Microsoft.Jet.OLEDB.4.0;DataSource = d:/login.mdb";          2007版本的Access數(shù)據(jù)庫鏈接字符串：privatestaticstring connStr =@"Provider= Microsoft.Ace.OLEDB.12.0;Data Source = d:/login.accdb";

OleDbConnection tempconn =new OleDbConnection(connStr);

 OleDbCommand cmd = new OleDbCommand(sql, tempconn);       tempconn.Open();      cmd.ExecuteNonQuery();

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.OleDb;using System.Windows.Forms;using System.Data;namespace test{  class AccessHelper  {    private static string connStr = @"Provider = Microsoft.Ace.OLEDB.12.0;Data Source = d:/login.accdb";    public static OleDbConnection GetConn()    {      OleDbConnection tempconn = new OleDbConnection(connStr);      MessageBox.Show(tempconn.DataSource);      tempconn.Open();      MessageBox.Show(tempconn.State.ToString());      return (tempconn);    }    /// <summary>    /// 執(zhí)行增加、刪除、修改指令    /// </summary>    /// <param name="sql">增加、刪除、修改的sql語句</param>    /// <param name="param">sql語句的參數(shù)</param>    /// <returns></returns>    public static int ExecuteNonQuery(string sql, params OleDbParameter[] param)    {      using (OleDbConnection conn = new OleDbConnection(connStr))      {        using (OleDbCommand cmd = new OleDbCommand(sql,conn))        {          if (param != null)          {            cmd.Parameters.AddRange(param);          }          conn.Open();          return(cmd.ExecuteNonQuery());        }      }    }    /// <summary>    /// 執(zhí)行查詢指令，獲取返回的首行首列的值    /// </summary>    /// <param name="sql">查詢sql語句</param>    /// <param name="param">sql語句的參數(shù)</param>    /// <returns></returns>    public static object ExecuteScalar(string sql, params OleDbParameter[] param)    {      using (OleDbConnection conn = new OleDbConnection(connStr))      {        using (OleDbCommand cmd = new OleDbCommand(sql, conn))        {          if (param != null)          {            cmd.Parameters.AddRange(param);          }          conn.Open();          return (cmd.ExecuteScalar());        }      }    }    /// <summary>    /// 執(zhí)行查詢指令，獲取返回的datareader    /// </summary>    /// <param name="sql">查詢sql語句</param>    /// <param name="param">sql語句的參數(shù)</param>    /// <returns></returns>    public static OleDbDataReader ExecuteReader(string sql, params OleDbParameter[] param)    {      OleDbConnection conn = new OleDbConnection(connStr);      OleDbCommand cmd = conn.CreateCommand();      cmd.CommandText = sql;      cmd.CommandType = CommandType.Text;      if (param != null)      {        cmd.Parameters.AddRange(param);      }      conn.Open();      return (cmd.ExecuteReader(CommandBehavior.CloseConnection));    }    /// <summary>    /// 執(zhí)行查詢指令，獲取返回datatable    /// </summary>    /// <param name="sql">查詢sql語句</param>    /// <param name="param">sql語句的參數(shù)</param>    /// <returns></returns>    public static DataTable ExecuteDatable(string sql, params OleDbParameter[] param)    {      using (OleDbConnection conn = new OleDbConnection(connStr))      {        using (OleDbCommand cmd = new OleDbCommand(sql, conn))        {          if (param != null)          {            cmd.Parameters.AddRange(param);          }          DataTable dt = new DataTable();          OleDbDataAdapter sda = new OleDbDataAdapter(cmd);          sda.Fill(dt);          return (dt);        }      }    }  }}