看板 Visual_Basic 關於我們 聯絡資訊
我的程式 Dim connStr, insertCmd As String connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=asset_maintenance.mdb" insertCmd = "Insert Into records(Staff_ID, Inspection_Date, Description_reasons, Complete_Date) Values(@Staff_ID, @Inspection_Date, @Description(Reasons), @Complete_Date)" Dim conn As OleDbConnection, cmd As OleDbCommand conn = New OleDbConnection(connStr) conn.Open() cmd = New OleDbCommand(insertCmd, conn) cmd.Parameters.Add(New OleDbParameter("@Staff_ID", OleDbType.VarChar)) cmd.Parameters.Add(New OleDbParameter("@Inspection_Date", OleDbType.DBDate)) cmd.Parameters.Add(New OleDbParameter("@Description(Reasons)", OleDbType.VarChar)) cmd.Parameters.Add(New OleDbParameter("@Complete_Date", OleDbType.DBDate)) TextBox4.Text = Now cmd.Parameters("@Staff_ID").Value = TextBox1.Text cmd.Parameters("@Inspection_Date").Value = TextBox2.Text cmd.Parameters("@Description(Reasons)").Value = TextBox3.Text cmd.Parameters("@Complete_Date").Value = TextBox4.Text cmd.ExecuteNonQuery() conn.Close() 請問一下就是我要新增資料, 可是卻一直發生問題, 可以邦我找到錯誤嗎?? -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 140.138.142.212
fumizuki:錯誤訊息呢@@ 05/19 19:44
inkyy:類型 'System.Data.OleDb.OleDbException' 的未處理例外狀況 05/20 11:54
inkyy: cmd.ExecuteNonQuery()到此行會出現上述訊息 05/20 11:55
cawQQ:會不會是你資料庫的問題??執行這段SQL指令出錯了 05/20 20:36
lolota:Access檔案權限不夠,你要加入asp.net的權限 05/21 16:54