Member Avatar for Mits14

Hi guys..
i have a problem with my sqlupdate statement..i don't know which part is the error.. could you help me figure it out?? i even delete the codes and then type it again..but there is still this error..

open_con()
        sqlupdate = "Update tblbook set Section='" & cbosection.Text & "', Book_Name='" & txtbooktitle.Text & "', Author='" & txtauthor.Text & "', Publishing_Company='" & txtpublishingcom.Text & "', Copyright=" & txtcopyright.Text & ", No_of_Copies=" & txtnoofcopies.Text & ", Copies_Available=" & txtcopiesavailable.Text & ", Limit_of_Days=" & cbodays.text& " where ISBN=" & txtISBN.Text & ""
        cmd = New OleDbCommand(sqlupdate, con)

thank you for your help! i'll appreciate it so much.

  • 3 Contributors
  • 3 Replies
  • 101 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Naveed_786
Member Avatar for debasisdas

First look shows some problem with single quotes.

Print the variable sqlupdate before executing the same.

Try to execute the output of the print , you will know the part that is creating the problem.

Edited by debasisdas because: n/a
Member Avatar for Mits14

i have figure it out that the error is in my combobox.. could you help me find solution so that my combobox can be updated

Member Avatar for Naveed_786

where is you combobox in this coding???

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.