unclosed quotation mark after the character string sql server
<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>