其它同级分类：

c#.net连接access操作类

[ 来源:www.it55.com | 作者: | 时间:2007-07-15 | 收藏 | 推荐 ] 【大中小】

1、配置web.config文件：配置数据库连接参数

www.it55.com在线教程

www.it55.com在线教程

2
程序设计开始： 45398 www.it55.com it55学习IT知识，享受IT生活 4dfkjn

1、按要求建立Access数据库及数据表 www.it55.com

2、编写数据库访问、操作的公用类，此类可以复用到以后开发的任何系统中 http://www.it55.com/

（1）、新建一个C# 类库项目，命名为“Com.LXJ”，设置项目属性：程序集名称、默认命名空间均为“Com.LXJ”

www.it55.com在线教程

（2）、在此项目目录下创建目录Database，新建C# 类文件ConnDbForAccess.cs 在Database目录下。 sflj www.it55.com kg^&fgd

添加引用：System.Web.dll sflj www.it55.com kg^&fgd

（3）、编写ConnDbForAccess.cs 的代码 45398 www.it55.com it55学习IT知识，享受IT生活 4dfkjn

using System;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Configuration;

www.it55.com在线教程

namespace Com.LXJ.Database
{
/// <summary>
/// conn 的摘要说明。
/// </summary>
public class ConnDbForAcccess
{
/// <summary>
/// 连接数据库字符串
/// </summary>
private string connectionString;

vd;k;l www.it55.com rdfg

/// <summary>
/// 存储数据库连接（保护类，只有由它派生的类才能访问）
/// </summary>
protected OleDbConnection Connection;

sflj www.it55.com kg^&fgd

/// <summary>
/// 构造函数：数据库的默认连接
/// </summary>
public ConnDbForAcccess()
{
string connStr;
connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
// connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString(); //从web.config配置中读取
connectionString = connStr;
//connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + connStr;
// connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
//
Connection = new OleDbConnection(connectionString);
}

sflj www.it55.com kg^&fgd

/// <summary>
/// 构造函数：带有参数的数据库连接
/// </summary>
/// <param name="newConnectionString"></param>
public ConnDbForAcccess(string newConnectionString)
{
//connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + newConnectionString;
connectionString = newConnectionString;
Connection = new OleDbConnection(connectionString);
}

免费资源www.it55.com

/// <summary>
/// 获得连接字符串
/// </summary>
public string ConnectionString
{
get
{
return connectionString;
}
} IT资讯之家 www.it55.com

/// <summary>
/// 执行SQL语句没有返回结果，如：执行删除、更新、插入等操作
/// </summary>
/// <param name="strSQL"></param>
/// <returns>操作成功标志</returns>
public bool ExeSQL(string strSQL)
{
bool resultState = false;

http://www.it55.com/

Connection.Open();
OleDbTransaction myTrans = Connection.BeginTransaction();
OleDbCommand command = new OleDbCommand(strSQL, Connection, myTrans); http://www.it55.com/

try
{
command.ExecuteNonQuery();
myTrans.Commit();
resultState = true;
}
catch
{
myTrans.Rollback();
resultState = false;
}
finally
{
Connection.Close();
}
return resultState;
}

http://www.it55.com/

/// <summary>
/// 执行SQL语句返回结果到DataReader中
/// </summary>
/// <param name="strSQL"></param>
/// <returns>dataReader</returns>
private OleDbDataReader ReturnDataReader(string strSQL)
{
Connection.Open();
OleDbCommand command = new OleDbCommand(strSQL, Connection);
OleDbDataReader dataReader = command.ExecuteReader();
Connection.Close();

45398 www.it55.com it55学习IT知识，享受IT生活 4dfkjn

return dataReader;
}

IT资讯之家 www.it55.com

/// <summary>

（编辑：IT资讯之家 www.it55.com）