UPDATE Query : Incorrect Syntax

I have a button in my windows forms which UPDATES every table. However, I am getting error SQLException was unhandled. Incorrect syntax near '='.

This is my code in Update Button:

  public void btnUpdate_Click(object sender, EventArgs e)
  {

   foreach (DataGridViewRow row in dataGridView1.Rows)
   {
    try
    {

     //MessageBox.Show(row.Cells[7].FormattedValue.ToString());
     System.Data.SqlClient.SqlConnection sqlConnection1 =
      new System.Data.SqlClient.SqlConnection("server=Test\\Test; Integrated Security=true; Database=Testing;");

     System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
     cmd.CommandType = System.Data.CommandType.Text;
     cmd.CommandText = "UPDATE dbo.JobStatus SET ShipTrackingNumber = '" + row.Cells[7].FormattedValue.ToString() + "' WHERE jobtableid = " + row.Cells[5].FormattedValue.ToString();
     cmd.CommandText = "UPDATE dbo.JobStatus SET ShipMethodTransmitted = '" + row.Cells[8].FormattedValue.ToString() + "' WHERE jobtableid = " + row.Cells[5].FormattedValue.ToString();
     cmd.CommandText = "UPDATE dbo.JobStatus SET开发者_JAVA百科 DateShipTransmitProcessed = '" + row.Cells[9].FormattedValue.ToString() + "' WHERE jobtableid = " + row.Cells[5].FormattedValue.ToString();
     cmd.CommandText = "UPDATE dbo.JobStatus SET ShipmentProcessedBy = '" + row.Cells[10].FormattedValue.ToString() + "' WHERE jobtableid = " + row.Cells[5].FormattedValue.ToString();
     cmd.CommandText = "UPDATE dbo.JobStatus SET Critical = '" + row.Cells[11].FormattedValue.ToString() + "' WHERE jobtableid = " + row.Cells[5].FormattedValue.ToString();
     cmd.CommandText = "UPDATE dbo.JobStatus SET ShipTransmitStatus = '" + row.Cells[13].FormattedValue.ToString() + "' WHERE jobtableid = " + row.Cells[5].FormattedValue.ToString();

     cmd.Connection = sqlConnection1;

     sqlConnection1.Open();
     cmd.ExecuteNonQuery();
     sqlConnection1.Close();
    }
    catch (Exception e)
    {
     MessageBox.Show("Update Failed!!!");
    }

   }
  }

Can anyone tell me what is wrong with these statements? Thanks!

---

Why not simply do it in a single update statement. So something like:

var sql = new StringBuilder();
sql.AppendLine( "UPDATE dbo.JobStatus" );
sql.AppendLine( "Set ShipTrackingNumber = @TrackingNumber" );
sql.AppendLine( ", DateShipTransmitProcessed = @DateShipTransmitProcessed" );
sql.AppendLine( ", ShipmentProcessedBy = @ShipmentProcessedBy" );
sql.AppendLine( ", Critical = @Critical" );
sql.AppendLine( ", ShipTransmitStatus = @ShipTransmitStatus" );
sql.AppendLine( "Where jobtableId = @jobTableId" );

cmd.Connection = sqlConnection1;
cmd.CommandText = sql.ToString();
cmd.Parameters.AddWithValue("@TrackingNumber", row.Cells[7].FormattedValue);
cmd.Parameters.AddWithValue("@DateShipTransmitProcessed", row.Cells[8].FormattedValue);
cmd.Parameters.AddWithValue("@ShipmentProcessedBy", row.Cells[9].FormattedValue);
cmd.Parameters.AddWithValue("@Critical", row.Cells[10].FormattedValue);
cmd.Parameters.AddWithValue("@ShipTransmitStatus", row.Cells[11].FormattedValue);
cmd.Parameters.AddWithValue("@jobTableId", row.Cells[5].FormattedValue);

---

Aside from what was mentioned in my comment; I don't see anything wrong with the syntax of your SQL. It's quite possible that your FormattedValue has an invalid character like a ' in the string itself, which would lead to a SQL error. Print out the value of the CommandText itself after the string has been built to see what it actually looks like.

---

1. Your UPDATE statement is incorrect. UPDATE syntax is:

   UPDATE table
      SET
         column1 = 'value',
         column2 = 'value2'
      WHERE
         condition;
   

2. You are overwriting your statement every time you assign to cmd. You probably want something more like:

   cmd =  "UPDATE table";
   cmd += "SET column1 = '" + value + "',";
   cmd += "SET column2 = " + intValue;
   cmd += "WHERE idRow = '" + rowToUpdateValue + "'";
   

Also, if this doesn't help, check that you are not trying to check an INT column using a 'char' value.

---

Please check your conditions thus:

if(row.Cells[5].FormattedValue.ToString())
then execute update query