随笔:
(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#编程实现连接ACCESS数据库实例详解
- C#使用ADO.Net部件来访问Access数据库的方法
- C#通过oledb访问access数据库的方法
- C#动态创建Access数据库及表的方法
- C#数据库操作类AccessHelper实例
- c#连接access数据库操作类分享
- C# Access数据库增删查改的简单方法
- c# 连接access数据库config配置
- 利用C#远程存取Access数据库