title: Incorrect syntax near '('.?
body: <p>I have <code>ShowGrid()</code>, <code>RowEditing</code> and <code>RowCancelingEdit</code> but they are correct.</p>
  <p>When executing the website I get this general error that I can not figure out:</p>
  <blockquote>
  <p>Incorrect syntax near '('.</p>
  <p>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.</p>
  <p>Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '('.</p>
  </blockquote>
  <pre><code>Protected Sub GridView1_OnRowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles GridView1.RowUpdating
      Dim connStr, cmdStr As String
      connStr = &quot;XXXXX&quot;
      cmdStr = &quot;UPDATE OrbitDates SET (JD=@JD,Xecl1=@Xecl1,Yecl1=@Yecl1,Zecl1=@Zecl1) WHERE ido=@ido;&quot;
      Try
          Using conn As New SqlConnection(connStr)
              Using cmd As New SqlCommand(cmdStr, conn)
                  conn.Open()
                  cmd.Parameters.AddWithValue(&quot;@ido&quot;, GridView1.Rows(e.RowIndex).Cells(0).Text)
                  cmd.Parameters.AddWithValue(&quot;@JD&quot;, GridView1.Rows(e.RowIndex).Cells(1).Text)
                  cmd.Parameters.AddWithValue(&quot;@Xecl1&quot;, GridView1.Rows(e.RowIndex).Cells(2).Text)
                  cmd.Parameters.AddWithValue(&quot;@Yecl1&quot;, GridView1.Rows(e.RowIndex).Cells(3).Text)
                  cmd.Parameters.AddWithValue(&quot;@Zecl1&quot;, GridView1.Rows(e.RowIndex).Cells(4).Text)
  
                  cmd.ExecuteNonQuery()
                  conn.Close()
                  cmd.Dispose()
                  conn.Dispose()
              End Using
          End Using
      Catch ex As Exception
          Throw ex
      End Try
      ViewState(&quot;edit&quot;) = e.RowIndex
      ShowGrid()
  End Sub
  </code></pre>