SYNTAX error with Update statement VB.NET

Question

I have a SYNTAX error in the UPDATE statement. Plz Help.

cmd.CommandText = "UPDATE tbl_User SET ([Score], [Level])VALUES(@User_Score, @User_Level) WHERE User=@User"
cmd.Parameters.AddWithValue("@User_Score", lblScore.Text)
cmd.Parameters.AddWithValue("@User_Level", lblLevel.Text)
cmd.Parameters.AddWithValue("@User", txtUser.Text)

Thanks

Does it compile? Have you checked the value of CommandText at runtime (and ran it in SQL Management?). This will narrow down your problem. — m.edmondson
– m.edmondson, Commented Jul 22, 2014 at 8:01
Yes i have fixed the problem. Thanks for suggestion for SQL Management — a147
– a147, Commented Jul 22, 2014 at 8:09

Damien_The_Unbeliever · Accepted Answer · 2014-07-22 08:04:08Z

1

You're using the INSERT syntax style, not the UPDATE syntax:

UPDATE tbl_User SET [Score] = @User_Score, [Level]= @User_Level WHERE User=@User

answered Jul 22, 2014 at 8:04

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

a147 Over a year ago

Thanks it worked. I also just figured out how to do it another correct way.

a147 · Accepted Answer · 2014-07-22 08:06:45Z

0

cmd.CommandText = "UPDATE tbl_User " & vbCrLf & "SET User_Score=@User_Score," & vbCrLf & "User_Level=@User_Level" & vbCrLf & "WHERE User=@User"

answered Jul 22, 2014 at 8:06

a147

191 silver badge6 bronze badges

Collectives™ on Stack Overflow

SYNTAX error with Update statement VB.NET

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related