C#连接ACCESS数据库的几条基本语句

// 连接OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C://test.mdb;");cn.Open();cn.Close();// 读取数据到DataTableOleDbConnection 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();