Syntax error in INSERT INTO STATEMENT...oledbException

See more:

VB8

VB9

VB

VB10

MS-Access

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