INSERT INTO STATEMENT中的语法错误... oledbException [英] Syntax error in INSERT INTO STATEMENT...oledbException

问题描述

我错在哪里

一切都很好





Private Sub Button1_Click（ByVal sender As System.Object，ByVal e As System.EventArgs）处理Button1.Click





con.Open（）

Str =插入PassengerDetails（BusID，PName，RouteName，年龄，性别，日期，时间）值（''+ Label7.Text +''，''+ TextBox2.Text +''，' '+ Label8.Text +''，''+ TextBox1.Text +''，''+ ComboBox2.SelectedValue +''，''+ Label12.Text +''，''+ Label14.Text +''）



cmdInsert =新OleDbCommand（Str，con）

cmdInsert.ExecuteNonQuery（）''获取 - >>>> INSERT INTO语句中的语法错误







MsgBox（预订门票）





con.Close（）

Me.Hide（）

TicketBooking.Sho w（）





End Sub



Private Sub PassengerDetails_Load（ByVal sender As System.Object，ByVal e As System.EventArgs）Handles MyBase.Load

Label7.Text = TicketBooking.BusId

Label8.Text = TicketBooking.routename

Label11.Text = TicketBooking.cost

Label12.Text = TicketBooking.datee

Label14.Text = TicketBooking.timee

Label16.Text = TicketBooking.seat



End Sub

End Class

解决方案

< blockquote>性别变量设置不正确...它出错了，这发生在我之前......

尝试定义它：

 sex = ComboBox2.Text 

Where am i going wrong
everything looks fine


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


con.Open()
Str = "insert into PassengerDetails(BusID,PName,RouteName,Age,Sex,Date,Time)values(''" + Label7.Text + "'',''" + TextBox2.Text + "'',''" + Label8.Text + "'',''" + TextBox1.Text + "'',''" + ComboBox2.SelectedValue+ "'',''" + Label12.Text + "'',''" + Label14.Text + "'')"

cmdInsert = New OleDbCommand(Str, con)
cmdInsert.ExecuteNonQuery()''Getting->>>>Syntax error in INSERT INTO STATEMENT



MsgBox("Ticket Booked")


con.Close()
Me.Hide()
TicketBooking.Show()


End Sub

Private Sub PassengerDetails_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label7.Text = TicketBooking.BusId
Label8.Text = TicketBooking.routename
Label11.Text = TicketBooking.cost
Label12.Text = TicketBooking.datee
Label14.Text = TicketBooking.timee
Label16.Text = TicketBooking.seat

End Sub
End Class

解决方案

the sex variable is set incorrectly... it makes a error, this happen to me before...
try to define it :

sex = ComboBox2.Text

这篇关于INSERT INTO STATEMENT中的语法错误... oledbException的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！