what is the problem of my code...when i view it in browser and click the button insert there is an error message
saying "Syntax error in INSERT INTO Statement
Dim myConn As OleDbConnection
Dim cmd As OleDbCommand
Dim sqlString, BookingDate, CheckInDate, CheckOutDate, RoomNo As String
BookingDate = txtBDate.Text
CheckInDate = txtCIDate.Text
CheckOutDate = txtCODate.Text
RoomNo = txtRNo.Text
myConn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=H:\OHRS.accdb")
myConn.Open()
sqlString = "INSERT INTO tbl_Booking (Booking Date, Check In Date, Check Out Date, Room No) VALUES ('" + BookingDate + "','" + CheckInDate + "','" + CheckOutDate + "','" + RoomNo + "')"
cmd = New OleDbCommand(sqlString, myConn)
cmd.ExecuteNonQuery()
myConn.Close()
i hope u can help me...