I am using asp and vb and back end is SQL .
I am getting syntax error in update command. Error is Incorrect Syntax near keyword "desc".
Can anyone debug this.
R can you tell me an alternative way to update record in database.
I have to check 3conditions in order to update a record.
This is the statement i have given.
com = New SqlCommand("Update prod_details Set price ='" & price.Text & "',qty='" & qty.Text & "',desc='" & desc.Text & "' where cname='" & cname.Text & "' and pname= '" & pname.Text & "' and mno= '" & mno.Text & "'", con)