title: Incorrect syntax near ''. Unclosed quotation mark after the character string ' '
body: <p>I'm just wondering if someone could point me in the right direction here, I think i've been looking at it for too long so can't see the mistake.</p>
  
  <p>The following code:</p>
  
  <pre><code>SqlCommand updateStyle = new SqlCommand("UPDATE [Lorenz].[dbo].[Layout] SET [bgColour] = '" + bgColour + "' , [textColour] = '" + txtColour + "WHERE &lt;[LoweredUserName] ='" + currentUser + "' ", connection);
  updateStyle.ExecuteNonQuery();
  </code></pre>
  
  <p>Is giving the error:</p>
  
  <p>Incorrect syntax near 'admin'.
  Unclosed quotation mark after the character string ' '.</p>