對Access檔案(*.mdb)進行增、刪、查、改功能

1.前言

利用Oledb操作Access mdb檔案

1. using System.Data;
2. using System.Data.OleDb;
4. namespace mdb資料庫存取範例
5. {
6. class Oledb_edit_Access
7. {
8. //資料庫連線
9. public static OleDbConnection OleDbOpenConn(string Database)
10. {
11. string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
12. OleDbConnection icn = new OleDbConnection();
13. icn.ConnectionString = cnstr;
14. if (icn.State == ConnectionState.Open) icn.Close();
15. icn.Open();
16. return icn;
17. }
18. //取得資料表
19. public static DataTable GetOleDbDataTable(string Database, string OleDbString)
20. {
21. DataTable myDataTable = new DataTable();
22. OleDbConnection icn = OleDbOpenConn(Database);
23. OleDbDataAdapter da = new OleDbDataAdapter(OleDbString, icn);
24. DataSet ds = new DataSet();
25. ds.Clear();
26. da.Fill(ds);
27. myDataTable = ds.Tables[0];
28. if (icn.State == ConnectionState.Open) icn.Close();
29. return myDataTable;
30. }
31. //對資料表進行新增、修改及刪除等功能
32. public static void OleDbInsertUpdateDelete(string Database, string OleDbSelectString)
33. {
34. string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
35. OleDbConnection icn = OleDbOpenConn(cnstr);
36. OleDbCommand cmd = new OleDbCommand(OleDbSelectString, icn);
37. cmd.ExecuteNonQuery();
39. if (icn.State == ConnectionState.Open) icn.Close();
40. }
43. }
44. }