Question

求告知如何用C# 在Microsoft Visual Studio 2010 编写一段代码连接Access数据库，和如何更改数据库内容？

求附上代码和解析。。。。。。。。。。。。。求速回啊。。。。。。很急。。。。
求高手提供视频。。。。

Answer 1

在你的项目中创建一个类，名称为CMyAccessLib，然后把下面的代码填进去，就可以用了，主要可以看看getDataTable,getDataSet,executeCmd等函数的用法就行了，希望对你有用。

using System;
using System.Data;
using System.Data.OleDb;

/// <summary>
/// Access数据库访问类，By：王宏伟，2012-10-9
/// Email:whw19860424@163.com
/// </summary>
class
{
private bool m_bStatus;
private OleDbConnection m_conn;
private void init()
{
m_bStatus = false;
if (m_conn != null && m_conn.GetType() == typeof(OleDbConnection) && m_conn.State == ConnectionState.Open)
{
m_conn.Close();
}
m_conn = null;
}
/// <summary>
/// 数据操作类状态
/// </summary>
public bool isOK
{
get { return m_bStatus; }
}
/// <summary>
/// 默认构造函数
/// </summary>
public CMyAccessLib()
{
init();
}
/// <summary>
/// 根据Access文件地址及访问密码实例化对象
/// </summary>
/// <param name="_mdbPath">Access文件地址</param>
/// <param name="_mdbPass">Access数据库密码</param>
public CMyAccessLib(string _mdbPath, string _mdbPass)
{
init();
if (!openConnection(_mdbPath, _mdbPass))
{
return;
}
m_bStatus = true;
}
/// <summary>
/// 打开数据库连接
/// </summary>
/// <param name="_mdbPath">Access文件地址</param>
/// <param name="_mdbpass">Access数据库密码</param>
/// <returns></returns>
public bool openConnection(string _mdbPath, string _mdbpass)
{
if (_mdbPath.Trim().Equals(string.Empty))
{
return false;
}
if (!System.IO.File.Exists(_mdbPath))
{
return false;
}
m_conn = new OleDbConnection();
m_conn.ConnectionString = m_conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _mdbPath + ";Jet OLEDB:Database Password=" + _mdbpass;
try
{
m_conn.Open();
m_bStatus = true;
}
catch (Exception e)
{
e = null;
m_bStatus = false;
m_conn = null;
}
return m_bStatus;
}
/// <summary>
/// 根据SQL语句查询数据库，以out方式传出结果集合DataSet
/// </summary>
/// <param name="_sqlCommand">SQL查询语句</param>
/// <param name="_result">传出参数，DataSet型查询结果</param>
/// <returns>函数是否执行成功</returns>
public bool getDataSet(string _sqlCommand, out DataSet _result)
{
_result = null;
if (!m_bStatus || _sqlCommand.Trim().Equals(string.Empty))
{
return false;
}
try
{
OleDbDataAdapter da = new OleDbDataAdapter(new OleDbCommand(_sqlCommand, m_conn));
_result = new DataSet();
da.Fill(_result);
da.Dispose();
return true;
}
catch (Exception e)
{
e = null;
return false;
}
}
/// <summary>
/// 根据SQL语句查询数据库，以out形式传出结果表DataTable
/// </summary>
/// <param name="_sqlCommand">SQL查询语句</param>
/// <param name="_result">传出参数，DataTable型查询结果</param>
/// <returns>函数是否执行成功</returns>
public bool getDataTable(string _sqlCommand, out DataTable _result)
{
_result = null;
if (!m_bStatus || _sqlCommand.Trim().Equals(string.Empty))
{
return false;
}
try
{
OleDbDataAdapter da = new OleDbDataAdapter(new OleDbCommand(_sqlCommand, m_conn));
_result = new DataTable();
da.Fill(_result);
da.Dispose();
return true;
}
catch (Exception e)
{
e = null;
return false;
}
}
/// <summary>
/// 执行SQL命令语句用，不返回查询结果
/// </summary>
/// <param name="_sqlCommand">SQL查询语句</param>
/// <returns>函数是否执行成功</returns>
public bool executeSQLCmd(string _sqlCommand)
{
if (!m_bStatus || _sqlCommand.Trim().Equals(string.Empty))
{
return false;
}
try
{
OleDbCommand cmd = new OleDbCommand(_sqlCommand, m_conn);
cmd.ExecuteNonQuery();
return true;
}
catch (Exception e)
{
e = null;
return false;
}
}
/// <summary>
/// 清除对象
/// </summary>
public void Dispose()
{
if (m_conn.State == ConnectionState.Connecting)
{
m_conn.Close();
m_conn.Dispose();
}
init();
}
~CMyAccessLib() { }
}