西夏普的部落格

1.前言
利用Oledb操作Access mdb檔案

2.說明
加入命名空間:

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

資料庫連線:

public static OleDbConnection OleDbOpenConn(string Database)
{
	string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
	OleDbConnection icn = new OleDbConnection();
	icn.ConnectionString = cnstr;
	if (icn.State == ConnectionState.Open) icn.Close();
	icn.Open();
	return icn;
}

取得資料表:

public static DataTable GetOleDbDataTable(string Database, string OleDbString)
{
	DataTable myDataTable = new DataTable();
	OleDbConnection icn = OleDbOpenConn(Database);
	OleDbDataAdapter da = new OleDbDataAdapter(OleDbString, icn);
	DataSet ds = new DataSet();
	ds.Clear();
	da.Fill(ds);
	myDataTable = ds.Tables[0];
	if (icn.State == ConnectionState.Open) icn.Close();
	return myDataTable;
}

對資料表進行新增、修改及刪除等功能:

public static void OleDbInsertUpdateDelete(string Database, string OleDbSelectString)
{
	string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
	OleDbConnection icn = OleDbOpenConn(cnstr);
	OleDbCommand cmd = new OleDbCommand(OleDbSelectString, icn);
	cmd.ExecuteNonQuery();
	if (icn.State == ConnectionState.Open) icn.Close();
}

3.應用

string sql = "select * from Employee";
DataTable dt = GetOleDbDataTable("NorthWind.mdb", sql);