C# OleDb SQL Update syntax error

Question

I cannot figure out why this gives me a syntax error when trying to update this?

string editComp = "UPDATE Competitive SET (PartNumber, Location, Description) values (@Edpart, @Edlocation, @Eddescrip) where SerialNumber = @serial";
command.CommandText = editComp;
command.Parameters.Add("@serial", OleDbType.VarChar).Value = Serialtext.Text;
command.Parameters.Add("@Edpart", OleDbType.VarChar).Value = Parttext.Text;
command.Parameters.Add("@Edlocation", OleDbType.VarChar).Value = cboLocation.Text;
command.Parameters.Add("@Eddescrip", OleDbType.VarChar).Value = Descriptiontext.Text;
command.ExecuteNonQuery();
MessageBox.Show("Successfully Updated");

What database are you using?

SLaks
– SLaks

2016-06-29 01:28:15 +00:00
Commented Jun 29, 2016 at 1:28 — SLaks
– SLaks, Commented Jun 29, 2016 at 1:28

sujith karivelil · Accepted Answer · 2016-06-29 01:28:59Z

2

You are trying to execute an update query with syntax of an insert. use correct syntax for UPDATE like the following;

 string editComp = "UPDATE Competitive SET PartNumber=@Edpart, Location=@Edlocation, Description=@Eddescrip";

If the above code is not working then try replacing @Edlocation,@Eddescrip and @Edpart with ?

answered Jun 29, 2016 at 1:28

sujith karivelil

29.1k7 gold badges60 silver badges90 bronze badges

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

5 Comments

CamlCase Over a year ago

Well I changed to the above and added this to the end - WHERE SerialNumber=@serial. It says it has updated but it doesn't actually update.

CamlCase Over a year ago

The add, delete statements I put in work just fine with "@" .

sujith karivelil Over a year ago

enclose the statements within a try and check whether any exception is comming

CamlCase Over a year ago

I already have it enclosed , that's why I was getting the syntax error from before. Now it shows my message box but no actual update.

CamlCase Over a year ago

Got it!,,,,By adding the serial number parameter first but not using it until the end of the statement it would not work. Moved the serial number to the end of the parameters I added and now it works, thank you for getting me started.

Collectives™ on Stack Overflow

C# OleDb SQL Update syntax error

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related