using
System;
using
System.Data;
using
System.Data.OleDb;
namespace
AccessDb
{
/// <summary>
/// AccessDb 的摘要說明,以下信息請完整保留
/// 請在數(shù)據(jù)傳遞完畢后調(diào)用Close()方法,關(guān)閉數(shù)據(jù)鏈接。
/// </summary>
public
class
AccessDbClass
{
變量聲明處#region 變量聲明處
public
OleDbConnection Conn;
public
string
ConnString;
#endregion
構(gòu)造函數(shù)與連接關(guān)閉數(shù)據(jù)庫#region 構(gòu)造函數(shù)與連接關(guān)閉數(shù)據(jù)庫
/// <summary>
/// 構(gòu)造函數(shù)
/// </summary>
/// <param name="Dbpath">ACCESS數(shù)據(jù)庫路徑</param>
public
AccessDbClass(
string
Dbpath)
{
ConnString =
"Provider=Microsoft.Jet.OleDb.4.0;Data Source="
;
ConnString += Dbpath;
Conn =
new
OleDbConnection(ConnString);
Conn.Open();
}
/// <summary>
/// 打開數(shù)據(jù)源鏈接
/// </summary>
/// <returns></returns>
public
OleDbConnection DbConn()
{
Conn.Open();
return
Conn;
}
/// <summary>
/// 請在數(shù)據(jù)傳遞完畢后調(diào)用該函數(shù),關(guān)閉數(shù)據(jù)鏈接。
/// </summary>
public
void
Close()
{
Conn.Close();
}
#endregion
數(shù)據(jù)庫基本操作#region 數(shù)據(jù)庫基本操作
/// <summary>
/// 根據(jù)SQL命令返回數(shù)據(jù)DataTable數(shù)據(jù)表,
/// 可直接作為dataGridView的數(shù)據(jù)源
/// </summary>
/// <param name="SQL"></param>
/// <returns></returns>
public
DataTable SelectToDataTable(
string
SQL)
{
OleDbDataAdapter adapter =
new
OleDbDataAdapter();
OleDbCommand command =
new
OleDbCommand(SQL, Conn);
adapter.SelectCommand = command;
DataTable Dt =
new
DataTable();
adapter.Fill(Dt);
return
Dt;
}
/// <summary>
/// 根據(jù)SQL命令返回數(shù)據(jù)DataSet數(shù)據(jù)集,其中的表可直接作為dataGridView的數(shù)據(jù)源。
/// </summary>
/// <param name="SQL"></param>
/// <param name="subtableName">在返回的數(shù)據(jù)集中所添加的表的名稱</param>
/// <returns></returns>
public
DataSet SelectToDataSet(
string
SQL,
string
subtableName)
{
OleDbDataAdapter adapter =
new
OleDbDataAdapter();
OleDbCommand command =
new
OleDbCommand(SQL, Conn);
adapter.SelectCommand = command;
DataSet Ds =
new
DataSet();
Ds.Tables.Add(subtableName);
adapter.Fill(Ds, subtableName);
return
Ds;
}
/// <summary>
/// 在指定的數(shù)據(jù)集中添加帶有指定名稱的表,由于存在覆蓋已有名稱表的危險,返回操作之前的數(shù)據(jù)集。
/// </summary>
/// <param name="SQL"></param>
/// <param name="subtableName">添加的表名</param>
/// <param name="DataSetName">被添加的數(shù)據(jù)集名</param>
/// <returns></returns>
public
DataSet SelectToDataSet (
string
SQL,
string
subtableName, DataSet DataSetName)
{
OleDbDataAdapter adapter =
new
OleDbDataAdapter();
OleDbCommand command =
new
OleDbCommand(SQL, Conn);
adapter.SelectCommand = command;
DataTable Dt =
new
DataTable();
DataSet Ds =
new
DataSet();
Ds = DataSetName;
adapter.Fill(DataSetName, subtableName);
return
Ds;
}
/// <summary>
/// 根據(jù)SQL命令返回OleDbDataAdapter,
/// 使用前請在主程序中添加命名空間System.Data.OleDb
/// </summary>
/// <param name="SQL"></param>
/// <returns></returns>
public
OleDbDataAdapter SelectToOleDbDataAdapter(
string
SQL)
{
OleDbDataAdapter adapter =
new
OleDbDataAdapter();
OleDbCommand command =
new
OleDbCommand(SQL, Conn);
adapter.SelectCommand = command;
return
adapter;
}
/// <summary>
/// 執(zhí)行SQL命令,不需要返回數(shù)據(jù)的修改,刪除可以使用本函數(shù)
/// </summary>
/// <param name="SQL"></param>
/// <returns></returns>
public
bool
ExecuteSQLNonquery(
string
SQL)
{
OleDbCommand cmd =
new
OleDbCommand(SQL, Conn);
try
{
cmd.ExecuteNonQuery();
return
true
;
}
catch
{
return
false
;
}
}
#endregion
}
}
本文來自CSDN博客,轉(zhuǎn)載請標明出處:http: