急阿 急啊,帮忙看下这段程序OleDb连接Access数据库的问题
Dim AppString, ModiString As String
Dim strCon as String = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = D:\data.mdb;Jet OLEDB:Database Password=1234"
Dim Mycom As New OleDbCommand
Dim mycon As New OleDbConnection(strCon)
mycon.Open()
Mycom.Connection = mycon
Mycom.CommandType = CommandType.Text
AppString = "Insert into UserInfo(UserName,Password,Power,Department) values('aaa','aaa','aaa','aaa')"
Mycom.CommandText = AppString
Mycom.ExecuteNonQuery()
mycon.Close()
运行时在Mycom.ExecuteNonQuery()处发生错误:
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。