SQL problem - simple?

Question

kn2790 0 Light Poster

15 Years Ago

so im trying 2 add data to my table in the database, done all the connection (OLEDB one)

so this code adds to my database:

SQL = "Insert into Bookings(StaffID) values('" & stafid.Text & "')"
        DC1 = New OleDbCommand(SQL, cN)
        DC1.ExecuteNonQuery()
        MsgBox("Record Saved, Thank you!", MsgBoxStyle.OkOnly, "")

this is one column, im trying to add more to the table StaffID

whats wrong with this SQL statement to add all the fields to the database?

SQL = "Insert into Bookings(StaffID,RoomID,Date required,Time required,Additional requirements) values('" _
            & "'" & stafid.Text & "', " _
            & "'" & rooid.Text & "', " _
            & "'" & date1.Text & "', " _
            & "'" & time1.Text & "', " _
            & "'" & areq.Text & "')"

visual-basic

4 Contributors
4 Replies
107 Views
6 Days Discussion Span
Latest Post 15 Years Ago Latest Post by QVeen72

debasisdas 580 Posting Genius

15 Years Ago

what exactly is the error message .

print the SQL string or display in A message box before executing the same. SO that yo can check if the SQL is being framed properly or not.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Zermoth 0 Newbie Poster · Answer 1 · 2009-05-01T20:13:40+00:00

& "'" & stafid.Text & "', " _
            & "'" & rooid.Text & "', " _
            & "'" & date1.Text & "', " _
            & "'" & time1.Text & "', " _
            & "'" & areq.Text & "')"

rename rooid.Text to roomid.Text

also

stafid.Text to staffid.Text

if thats not the correct names

kn2790 0 Light Poster · Answer 2 · 2009-05-01T20:59:58+00:00

lol no they are the correct names of the textboxes, any other ideas?

QVeen72 104 Posting Shark · Answer 3 · 2009-05-07T15:54:28+00:00

Hi,

Field Names which have SpecialCharacters/Spaces, need to be enclosed in a Square Bracket..
Try This :

SQL = "Insert into Bookings(StaffID,RoomID,[Date required]," _
& " [Time required],[Additional requirements]) values('" _
& "'" & stafid.Text & "', " _
& "'" & rooid.Text & "', " _
& " #" & date1.Text & "#, " _
& " #" & time1.Text & "#, " _
& "'" & areq.Text & "')"

Also, Date/Time Fields need to to be wrapped in with #, instead of single quote.

Regards
Veena