SQL Update on a windows form

Chris Johnson

Hi all.

This is driving me nuts. I am trying to update an SQL record with a pic from a c# Windows form. I have written the code but it fails on the update command with incorrect syntax near (.

Can someone please spot what I am doing wrong?

SqlCommand cmd = new SqlCommand("UPDATE ITMRVA (Pic) values (@Pic) where ITNBR = 'OCB75'", cnn);
cmd.Parameters.AddWithValue("@Pic", content);
cmd.ExecuteNonQuery();
cnn.Close();
MessageBox.Show("Image inserted");

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar4y ago
Accepted answer
Hi Chris,

Its wrong in update query, just change below line,
SqlCommand cmd = new SqlCommand("UPDATE ITMRVA set Pic=@Pic where ITNBR = 'OCB75''", cnn);
Yazhini MP4y ago
You can try this Update query,

SqlCommand cmd = new SqlCommand("UPDATE ITMRVA set Pic=@Pic where ITNBR = 'OCB75'", cnn);
cmd.Parameters.AddWithValue("@Pic", content);
cmd.ExecuteNonQuery();
cnn.Close();
MessageBox.Show("Image Inserted");
geetha geetha4y ago
I think there is a mistake in your update Query,
you can replace the (pic) , instead of using (pic) use update set for updating the image
conn.open();
SqlCommand cmd = new SqlCommand("UPDATE ITMRVA  set pic = @Pic where ITNBR = 'OCB75'", conn);
cmd.Parameters.AddWithValue("@Pic", content);
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Image inserted");
Vikas Panwar4y ago
Use like as
SqlCommand cmd = new SqlCommand("UPDATE ITMRVA Set Pic = @Pic where ITNBR = 'OCB75'", cnn);
               cmd.Parameters.AddWithValue("@Pic", content);
               cmd.ExecuteNonQuery();
               cnn.Close();
               MessageBox.Show("Image inserted");