update values of two Columns in SQL database using C#
<pre><code>cmd.CommandText = "update  dbo.diagnosis SET id=" + SetValueForText + "ss=" + sh;
</code></pre>

<p>where <code>sh</code> and column <code>ss</code> are of bool datatype and <code>id</code> and <code>SetValueForText</code> are of int datatype.
exception is invalid syntax near <code>ss</code>.</p>
