title: Joining Values Of Two Columns From DataTable
body: <p><strong>Joining Values Of Two Columns From DataTable</strong> 
  Two columns make it in one columns from datatable</p>
  
  <p>my datatable is</p>
  
  <pre><code>   TagNumber, LogNumber  Combined
      124           1         2
      125           1         3
      126           2         4
  o/p:
  
       TagNumber 
      124 ~1~2          
      125 ~1~3         
      126 ~2~4         
   combined column is merge from column0 and column1
  </code></pre>
  
  <p>i dont understand hw can i do please write sample of code</p>
  
  <p>I dont have experience on linq .
  I add column bt hw can i merge two columns in that one columns </p>
  
  <pre><code>I got answer:
  
  For i As Integer = 0 To dstemp.Tables(0).Rows.Count - 1
  dstemp.Tables(0).Rows(i)(0) = dstemp.Tables(0).Rows(i)("TagNumber") &amp; "~" &amp;      dstemp.Tables(0).Rows(i)("LogNumber") &amp; "~" &amp; dstemp.Tables(0).Rows(i)("Combined")
  next
  </code></pre>