C# 操作 access 数据库的实例代码
作者:房上的猫 时间:2024-01-28 15:05:11
随笔:
(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 数据库的实例代码网站的支持!
来源:https://www.cnblogs.com/lsy131479/archive/2018/03/26/8650515.html
标签:c#,access,数据库
0
投稿
猜你喜欢
pycharm无法安装第三方库的问题及解决方法以scrapy为例(图解)
2022-11-01 20:53:28
解决VUE自定义拖拽指令时 onmouseup 与 click事件冲突问题
2024-05-10 14:15:54
pytorch forward两个参数实例
2022-09-05 09:54:34
Hibernate Oracle sequence的使用技巧
2009-06-19 17:25:00
MySQL Cluster集群的初级部署教程
2024-01-22 01:50:16
Python3获取cookie常用三种方案
2022-10-20 02:56:19
利用python如何处理nc数据详解
2021-12-07 02:20:13
python利用tkinter实现屏保
2022-01-26 05:39:51
python使用pyodbc连接sqlserver
2021-12-24 06:06:17
2022年最新Typora的破解方法
2023-08-29 04:36:03
anaconda安装后打不开解决方式(亲测有效)
2023-01-21 09:40:15
Python如何爬取b站热门视频并导入Excel
2023-06-20 23:27:44
Dreamweaver快捷键大全
2007-11-05 14:08:00
Python爬虫爬取商品失败处理方法
2021-04-11 11:26:31
PHP中round()函数对浮点数进行四舍五入的方法
2023-11-23 21:35:24
什么是DOM(Document Object Model)文档对象模型
2024-05-13 09:37:04
vue中渐进过渡效果实现
2024-04-10 10:32:54
MySQL中InnoDB存储引擎的锁的基本使用教程
2024-01-21 09:27:01
python openvc 裁剪、剪切图片 提取图片的行和列
2022-07-03 15:29:40
python selenium登录豆瓣网过程解析
2021-12-15 09:52:49