Incorrect syntax near ''. Unclosed quotation mark after the character string ' '
<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>
