0

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
4
Views
6 Years
Discussion Span
Last Post by Naveed_786
0

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: n/a

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.