This is my code for button Save



Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click





openConnection()

cmd.Connection = con

cmd.CommandText = "INSERT INTO Reservations Values('" & cboCustomer.SelectedValue & "','" & Route_codeTextBox.Text & "', '" & Date_ReservedDateTimePicker.Value & "','" & FlightTextBox.Text & "', '" & ClassTextBox.Text & "','" & FareTextBox.Text & "','" & txtDeparture.Text & "','" & Departure_timeTextBox.Text & "','" & txtArrivaldate.Text & "','" & cmbSource.SelectedItem & "','" & cmbDest.SelectedItem & "','" & txtArrivaldate.Text & "','" & Arrival_timeTextBox.Text & "', '" & No_of_passengersTextBox.Text & "', '" & TotalTextBox.Text & "')"

cmd.ExecuteNonQuery()

MsgBox("Data saved")

Me.ReservationsBindingSource.EndEdit()

Me.TableAdapterManager.ReservationsTableAdapter.Update(Me.OceaniaDataSet)

con.Close()











My reservation table























This my problem

















Please help urgent

wendie

The images that you have attached showing the issue are not visible within your thread, please attach them again or simply write down the problem that you are facing.