syntax error in update statement in C# with access 2010

Question

im working on updating information in mic access 2010 using this code, but its keep telling me the syntax error in update statement. ihd already search through the previous answers but non of them work. here is my snipped code. tell me if you guys need more information.

try
{
    OleDbCommand renew = test.CreateCommand();
    renew.CommandType = CommandType.Text;
    renew.CommandText ="UPDATE Energy_Audit SET Appliances = @app, Usage Per Day = @usg, Power (Watt) = @pow, Number of Item = @num Where ID = @id )";
    renew.Parameters.AddWithValue("@app", txtApp.Text);
    renew.Parameters.AddWithValue("@usg", txtUsg.Text);
    renew.Parameters.AddWithValue("@pow", txtPwr.Text);
    renew.Parameters.AddWithValue("@num", txtNum.Text);
    renew.Parameters.AddWithValue("@id", txtID.Text);
    renew.ExecuteNonQuery();
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}

you would need to enclose in brackets like [Usage Per Day] — V4Vendetta
– V4Vendetta, Commented Jul 17, 2013 at 9:13

Zaki · Accepted Answer · 2013-07-17 09:12:09Z

1

You cannot have space in column name, so do this, put [] around it :

UPDATE Energy_Audit SET Appliances = @app, [Usage Per Day] = @usg, [Power (Watt)] = @pow, [Number of Item] = @num Where ID = @id

answered Jul 17, 2013 at 9:12

Zaki

5,6087 gold badges58 silver badges91 bronze badges

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

2 Comments

cSharpNoobies Over a year ago

thank you!!. that solve the syntax problem. but then i got the extra ")" error. i removed it. then i run the program again but when i clicked update button it not updating the data T.T . any idea?

Zaki Over a year ago

It should work, make sure your id is found in the table. and that the updated values are not the same

gzaxx · Accepted Answer · 2013-07-17 09:12:36Z

0

Change your query like this:

UPDATE Energy_Audit
SET Appliances = @app, [Usage Per Day] = @usg, [Power (Watt)] = @pow, [Number of Item] = @num
Where ID = @id )

if your column name contains spaces it has to be encapsulated in square brackets.

answered Jul 17, 2013 at 9:12

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Collectives™ on Stack Overflow

syntax error in update statement in C# with access 2010

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related