本文講解了C#連接數據庫、操作數據庫的方法。

// 連接

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C://test.mdb;");

cn.Open();

cn.Close();

// 讀取數據到DataTable

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C://test.mdb;");

DataTable userTbl = new DataTable();

OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [User]", cn);

da.Fill(userTbl);

// 插入一條記錄

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C://test.mdb;");

OleDbCommand cmd = new OleDbCommand("INSERT INTO [User] ([ID], [UserName], [UserPassword]) VALUES (1, 'user_ab', '123')", cn);

cn.Open();

cmd.ExecuteNonQuery();

cn.Close();

// 更新

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C://test.mdb;");

OleDbCommand cmd = new OleDbCommand("UPDATE [User] SET [UserPassword]='newpwd' WHERE [UserName]='user_ab'", cn);

cn.Open();

cmd.ExecuteNonQuery();

cn.Close();