title: c# datatable join and select all columns from both table
body: <p>I need to join two datatable's and select all values from both table because d1 columns are dynamic i have tried with below code and getting the join value but when i select it shows in 2 DataRows it should be in one row</p>
  
  <pre><code>        DataTable dtRtn = new DataTable();
  
          var result = from d1 in dtFormData.AsEnumerable()
                       join d2 in dtResponderDetails.AsEnumerable()
                       on d1.Field&lt;string&gt;("ResponderId") equals d2.Field&lt;string&gt;("EmployeeId")
                       select new { d1,d2};
  </code></pre>
  
  <p>I need both d1 and d2 joined result to be copied to dtRtn table</p>
  
  <p><strong>Edit</strong></p>
  
  <p>I have searched but there is not straight forward answer for and all answers shows how to select specific columns</p>
  
  <p>Please help thanks</p>