SQL Update on a windows form

Question

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");

Jignesh Kumar · 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 MP · Answer

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 geetha · Answer

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 Panwar · Answer

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" );