title: c# (ado) alter table add column - give a name to a column from a variable (Datetime)
body: <p>This my code:</p>
  <pre class="lang-cs prettyprint-override"><code>string myDate = dateTime.Month.ToString() + &quot;/&quot; + dateTime.Year.ToString();
  sqlCommand.CommandText = (&quot;ALTER TABLE working_hours ADD &quot;+ myDate  +&quot; float &quot;);
  </code></pre>
  <p>It doesn't work. But if I replace the Date value with something else then everything works</p>
  <pre class="lang-cs prettyprint-override"><code>//*string myDate=&quot;DateTime&quot;;
  </code></pre>
  <p>I have to get a new column named date (month/year) -&gt; 11/20 10/20 09/20.</p>