ca any one correct my insert query in database
Dim hotel_book As String = "insert into hotelbooking (Userid, hotel_requirement_Types, singleroom, single_no_room,doubleroom,double_no_room) " & _"VALUES (" & userid & ", '" & ckchecked.Text & "' , & singlecheck & , & no_single_room & , & doublecheck & , &no_double_room & " )
singleroom and doubleroom are of type binary( 50)
userid , single_no_room and double_no_room are of type int
and type is nvarchar(50) of Userid, hotel_requirement_Types
please reply me