我正在将记录插入数据库,但在参数“日期”上出现错误。任何想法都会很好。
myConnection.Open()
Dim sqlQry As String = "INSERT INTO MasterLabNumber (LabNumber, Location, Date)" + "VALUES(@LabNumber, @Location, @Date)"
Dim str As String
str = "SELECT * FROM MasterLabNumber WHERE (LabNumber = " & TextBox1.Text & ")"
Dim d As System.DateTime = DateTime.Now.ToString("yyyy/MM/dd")
Dim cmd As OleDbCommand = New OleDbCommand(sqlQry, myConnection)
cmd.Parameters.AddWithValue("@LabNumber", TextBox1.Text)
cmd.Parameters.AddWithValue("@Location", ComboBox1.Text)
cmd.Parameters.AddWithValue("@Date", d)
cmd.ExecuteNonQuery() <-- gets error here relating to adding the parameter date.
是的,这Date
是因为您在插入语句中使用了一个保留字。你需要像下面这样使用[]
INSERT INTO MasterLabNumber (LabNumber, Location, [Date])
你的插入语句应该变成
Dim sqlQry As String = "INSERT INTO MasterLabNumber (LabNumber, Location, [Date]) VALUES(@LabNumber, @Location, @Date)"
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句