title: Adding to a sql integer column using C#
body: <p>I am trying to update a SQL table from my C# backend, but it never successfully executes; mainServiceButton is a pre-existing value in the linkName column. Here is what I have so far:</p>
  
  <pre><code>conn.Open();
         string qry = "UPDATE clickStream SET clickCount = (clickCount + 1) WHERE linkName = mainServiceButton";
         SqlCommand cmd = new SqlCommand(qry, conn);
         try
         {
             cmd.ExecuteScalar();
         }
         catch
         {
             MessageBox.Show("not executed");
         }
          conn.Close();
  </code></pre>
  
  <p>This is how the table was created:</p>
  
  <pre><code>CREATE TABLE clickStream(
  click_ID int identity(1,1),
  linkName nvarchar(50) not null,
  clickCount int,
  PRIMARY KEY(click_ID));
  </code></pre>
  
  <p>The desired result is to increase the clickCount by 1 every time a link(linkName) is clicked on. Any Suggestions?</p>