Syntax error (missing operator) in query expression

hassanasp

updatecom.CommandText="update test2 set name='" + textBox1.Text + "' job= '" + textBox2.Text +"' title='" + textBox3.Text + "'where id=" + textBox4.Text + "";

Ahmed hassan

PH MAT

try some comma's between the ' and job and ' and title

hassanasp

not working

Ahmed hassan

Wendelius

And as an addition to the previous post, use parameters for values. You are now for example vulnerable to sql injections.

The need to optimize rises from a bad design.My articles[^]

Christian Graus

1: instead of saying 'not working', tell us what the error is. Putting commas in to fix your SQL will obviously work. 2: read up on SQL Injection attacks, to find out how I can erase your entire database if you release this code 3: tell me you're not really using variables called textBox1, textBox2, etc. Or are you trying to write unreadable code on purpose ?

Christian Graus Driven to the arms of OSX by Vista.

Lost User

You may try this: updatecom.CommandText = "update test2 set name='" + textBox1.Text + "', job= '" + textBox2.Text +"', title='" + textBox3.Text + "' where id='" + textBox4.Text + "'"; Fixed "," and "'"

Saludos!! ____Juan