[.NET] 資料庫問題
我的程式
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
推
05/19 19:44, , 1F
05/19 19:44, 1F
推
05/20 11:54, , 2F
05/20 11:54, 2F
→
05/20 11:55, , 3F
05/20 11:55, 3F
推
05/20 20:36, , 4F
05/20 20:36, 4F
→
05/21 16:54, , 5F
05/21 16:54, 5F
Visual_Basic 近期熱門文章
PTT數位生活區 即時熱門文章
