title: Incorrect syntax near '('.
body: <p>When I tried to run the program I got the error:</p>
  
  <blockquote>
    <p>Incorrect syntax near '('.</p>
  </blockquote>
  
  <pre><code>SqlCommand com = new SqlCommand();
  com.Connection = con;
  SqlDataReader dr;
  
  string query = "Update Emp SET(id,dt,Nam,Desig,Address,Phone,UserId) Values(@id,@dt,@Nam,@Desig,@Address,@Phone,@UserId)";
  com.CommandText = query;
  
  com.Parameters.Add(new SqlParameter("@id",(int)nid));
  com.Parameters.Add(new SqlParameter("@dt",(object)txtDOJ.Value.ToString()));
  com.Parameters.Add(new SqlParameter("@Nam",(object)txtName.Text));
  com.Parameters.Add(new SqlParameter("@Desig",(object)txtDesig.Text));
  com.Parameters.Add(new SqlParameter("@Address",(object)txtAddress.Text));
  com.Parameters.Add(new SqlParameter("@Phone",(object)txtPhone.Text));
  com.Parameters.Add(new SqlParameter("@userId",(object)txtUserId.Text));
  
  com.ExecuteNonQuery();   //I am getting incorrect syntax near '(' error here;
  
  MessageBox.Show("Save!");
  getlist();
  </code></pre>