System.Data.OleDb.OleDbException:'INSERT INTO语句中的语法错误。' [英] System.Data.OleDb.OleDbException: 'Syntax error in INSERT INTO statement.'
问题描述
我正在尝试创建一个数据库程序来跟踪住在公寓的客人,我收到了System.Data.OleDb.OleDbException:'INSERT INTO语句中的语法错误。'错误。以下是代码中的部分内容
I am trying to create a database program to keep track of guests staying in residents apartments and I get the System.Data.OleDb.OleDbException: 'Syntax error in INSERT INTO statement.' error. Here is the part of the code it is stuck at
cmd.CommandText =" INSERT INTO访客注册(姓名,居民,关系,电话号码,Apt号码,汽车)信息,最大天数)" &
          "VALUES(& Me.txtName.Text&","& Me.txtResident.Text&"','"&
; Me.cboRelationship.Text&"','"& Me.txtPhone.Text&"','"&
  ; Me.txtAptNumber.Text&"','"& Me.txtCarInfo.Text&"','"& Me.txtnumberofdays.Text& "')"
      cmd.ExecuteNonQuery()
cmd.CommandText = "INSERT INTO Guest Registration (Name, Resident, Relationship, , Phone Number, , Apt Number, Car Info, Max Number of Days) " &
"VALUES(" & Me.txtName.Text & ",' " & Me.txtResident.Text & "','" &
Me.cboRelationship.Text & "','" & Me.txtPhone.Text & "','" &
Me.txtAptNumber.Text & "','" & Me.txtCarInfo.Text & "','" & Me.txtnumberofdays.Text & "')"
cmd.ExecuteNonQuery()
我可以得到一些建议吗?
May I get some advice?
推荐答案
删除不需要的逗号,输入"[]"以避免出现空格问题,并检查撇号的使用情况:
cmd.CommandText =" INSERT INTO [访客注册]([姓名],[居民],[关系] ,[电话号码],[公寓号码],[汽车信息],[最大天数])值('& Me.txtName.Text&"','& Me.txtResident.Text
&"','"& Me.cboRelationship.Text&"','"& Me.txtPhone.Text&"','"& Me.txtAptNumber .Text&"','"& Me.txtCarInfo.Text&"','"& Me.txtnumberofdays.Text&"')"
并使用参数化查询下次。同时,不要在所有这些文本框和组合框中键入撇号。
这篇关于System.Data.OleDb.OleDbException:'INSERT INTO语句中的语法错误。'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!