title: Concat columns adding data in datatable
body: <p>I am getting some data from database that has date break up in year month and year due to some reason i want to concat the column and add a new column.</p>
  
  <p>What i  am doing is adding the data</p>
  
  <pre><code>                    DataColumn newColumn;
                      newColumn = new DataColumn("CompositeDate");
                      newColumn.Expression = "Day + Month + Year" ;
                      scaleResponseData.Columns.Add(newColumn);
  </code></pre>
  
  <p>the data in the data table  is some thing like this</p>
  
  <pre><code>year | Month | Day
  2009   10       2
  2010   11       3
  </code></pre>
  
  <p>What my current code is doing</p>
  
  <pre><code>year | Month | Day | composite_Date 
  2009   10       2      2021
  2010   11       3      2024
  </code></pre>
  
  <p>But the result should be some thing</p>
  
  <pre><code>year | Month | Day | composite_Date 
   2009   10     02      20091002
   2010   11     03      20101103
  </code></pre>
  
  <p>I have different combination but nothing is working</p>