C# 操作 access 数据库的实例代码

2020-01-24 00:19:30

字体：大中小

来源：转载

供稿：网友

随笔：

（1）命名空间

using System.Data.OleDb;

（2）连接字符串

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

注意：

a、DataSource = 数据库存放的路径（这里数据库放到了D盘目录下）
b、 2003版本的Access数据库链接字符串：

 privatestatic stringconnStr =@"Provider = Microsoft.Jet.OLEDB.4.0;DataSource = d:/login.mdb";          2007版本的Access数据库链接字符串：privatestaticstring connStr =@"Provider= Microsoft.Ace.OLEDB.12.0;Data Source = d:/login.accdb";

（3）建立连接：

OleDbConnection tempconn =new OleDbConnection(connStr);

（4）使用OleDbCommand类来执行Sql语句：

 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>    /// 执行增加、删除、修改指令    /// </summary>    /// <param name="sql">增加、删除、修改的sql语句</param>    /// <param name="param">sql语句的参数</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>    /// 执行查询指令，获取返回的首行首列的值    /// </summary>    /// <param name="sql">查询sql语句</param>    /// <param name="param">sql语句的参数</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>    /// 执行查询指令，获取返回的datareader    /// </summary>    /// <param name="sql">查询sql语句</param>    /// <param name="param">sql语句的参数</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>    /// 执行查询指令，获取返回datatable    /// </summary>    /// <param name="sql">查询sql语句</param>    /// <param name="param">sql语句的参数</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);        }      }    }  }}

总结

以上所述是小编给大家介绍的C# 操作 access 数据库的实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！

上一篇：C#图片查看器实现方法

下一篇：C# winForm实现的气泡提示窗口功能示例