title: Insert datarow from one datatable to a particular index
body: <p>I'm retrieving <code>DataTables</code> from my database and I need to insert a particular row from one <code>DataTable</code> into a determined index into another <code>DataTable</code>.</p>
  
  <p>basically I would like to have say, row[0] of <code>DataTable</code> dt1 inserted into <code>DataTable</code> dt2 at index 4.</p>
  
  <p>These are two different tables obtained from two different database calls.  Is there a way to do this?</p>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>[EDIT]
  Sorry, Here's what I've done</p>
  
  <pre><code>DataTable dt1 = populateTable();
  DataTable targetTable = populateTargetTable();
  DataRow dr;
  dr = dt1.NewRow();
  dr = targetTable.Rows[0];
  
  int index=0;
  DataRow temp;
  for (int i = 0; i &lt; dt1.Rows.Count; i++)
  {
      temp = dt1.Rows[i];
      if (rowFitsCondition(temp)){
          index = i;
      }
  }
  dt1.Rows.InsertAt(dr, index);
  </code></pre>
  
  <p>and the <code>InsertAt()</code> call fails, and gives me the <code>This row already belongs to another table error.</code></p>