Click here to Skip to main content
12,246,406 members (34,357 online)
Rate this:
 
Please Sign up or sign in to vote.
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
Posted 18-Apr-13 12:41pm
Edited 18-Apr-13 13:24pm
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160426.1 | Last Updated 18 Apr 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100