一.前期準備
數(shù)據(jù)庫 Access 2007
開發(fā)軟件 Visual Studio 2012 或者 Visual Studio 2019
C#用到DLL是 System.Data.dll
二.連接數(shù)據(jù)庫連接串
static string exePath = System.Environment.CurrentDirectory;
public static string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + exePath + @"\數(shù)據(jù)庫文件.mdb";
其中exePath是當前程序的工作目錄
三.執(zhí)行查詢語句，返回DataSet
第一步創(chuàng)建數(shù)據(jù)庫連接
OleDbConnection connection = new OleDbConnection(ConnectionString)
connectionString 為連接數(shù)據(jù)庫連接串
第二步打開數(shù)據(jù)庫連接
connection.Open();
第三步執(zhí)行 查詢語句 返回 OleDbDataAdapte類
OleDbDataAdapter da = new OleDbDataAdapter(SQLString, connection);
第四步 OleDbDataAdapte填充DataSet
da.Fill(ds);
第五步 關閉連接
connection.Close();四.執(zhí)行修改 刪除 創(chuàng)建語句，返回是否成功
第一步創(chuàng)建數(shù)據(jù)庫連接
OleDbConnection connection = new OleDbConnection(ConnectionString)
ConnectionString 為連接數(shù)據(jù)庫連接串
第二步打開數(shù)據(jù)庫連接
connection.Open();
第三步執(zhí)行 使用OleDbCommand類 執(zhí)行數(shù)據(jù)庫執(zhí)行的 SQL 語句
OleDbCommand command = new OleDbCommand(SQLString, connection);
第四步 執(zhí)行語句獲取受影響的行數(shù)
int recordCount = command.ExecuteNonQuery();
五.完整代碼
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Text;
namespace DBUtility
{
public abstract class AsHelperSQL
{
static string exePath = System.Environment.CurrentDirectory;
public static string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + exePath + @"\nmgzlsoft.mdb";
#region 執(zhí)行簡單SQL語句
/// <summary>
/// 執(zhí)行查詢語句，返回DataSet
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataSet Query(string SQLString)
{
DataSet ds = new DataSet();
using (OleDbConnection connection = new OleDbConnection(ConnectionString))
{
try
{
connection.Open();
OleDbDataAdapter da = new OleDbDataAdapter(SQLString, connection);
da.Fill(ds);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
return ds;
}
}
/// <summary>
/// 執(zhí)行sql語句返回是否成功
/// </summary>
/// <param name="SQLString"></param>
/// <returns></returns>
public static Boolean SqlAdd(string SQLString)
{
using (OleDbConnection connection = new OleDbConnection(ConnectionString))
{
try
{
connection.Open();
OleDbCommand command = new OleDbCommand(SQLString, connection);
int recordCount = command.ExecuteNonQuery();
if (recordCount > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
}
}
#endregion
}
}
閱讀原文：原文鏈接
該文章在 2025/7/7 11:57:55 編輯過
400 186 1886
