title: unclosed quotation mark after the character string sql server
body: <p>I'm trying to get my update command in SQL to work. Every time I try to update a record I get the following error unclosed quotation mark after the character string. Here my code: </p>
  
  <pre><code>String^ connectionString = L"**********"; 
  SqlConnection^ myCon = gcnew SqlConnection(connectionString);
  
  SqlCommand^ myCommand = gcnew SqlCommand("UPDATE ******* SET Customer_Name = '" + this -&gt; txtName -&gt; Text + "', Customer_Address = '" + this -&gt; txtPhone -&gt; Text + "', Customer_City = '" + this -&gt; txtCity -&gt; Text + "', Customer_State = '" + this -&gt; txtState -&gt; Text + "', Customer_Zip = '" + this -&gt; txtZip -&gt; Text + "', Customer_Phone = '" + this -&gt; txtPhone -&gt; Text + "', Customer_Email = '" + this -&gt; txtEmail -&gt; Text + "' where Customer_Name = '" + this -&gt; txtName -&gt; Text + ",);", myCon);
  SqlDataReader^ myReader;
  
  try {
         myCon -&gt; Open();
         myReader = myCommand -&gt; ExecuteReader();
         MessageBox::Show("Updated!!");
  }
  catch (Exception^ ex) {
      MessageBox::Show(ex-&gt;Message);
  }
  </code></pre>
  
  <p>I am not sure how to fix this error. Any help would be great.</p>