title: Copying Rows from One DataTable to another Displays Nothing
body: <p>I'm trying to copy rows from one <code>DataTable</code> to another, but only copy rows where the data is yet to be saved to the database table.</p>
  
  <p>The <code>SQL</code> side of this is working fine, it's returning the correct number of columns, however, when I add the rows that were found to my second <code>DataTable</code> and set it as the <code>DataSource</code> for my grid, there is no data displayed, although there is a row that has been added, since the row selector is visible.</p>
  
  <p>What am I doing wrong, and why isn't the data being copied with it?</p>
  
  <pre><code>lftable = New DataTable
  
  Try
    For Each dc As DataColumn In lineTable.Columns
      lftable.Columns.Add()
    Next
  
    Dim ds As New DataSet
  
    For Each row As DataRow In lineTable.Rows
       Dim da As New OleDbDataAdapter("SELECT * FROM [Order_Freight] WHERE [Order_Number] = ? AND [Product_Code] &lt;&gt; ?", con)
       da.SelectCommand.Parameters.Add("@num", OleDbType.Integer).Value = orderNum
       da.SelectCommand.Parameters.Add("@prod", OleDbType.VarChar).Value = row.Item("Product_Code")
       da.Fill(ds)
  
       For Each dr As DataRow In ds.Tables(0).Rows
          Dim nRow = lftable.Rows.Add()
          nRow.ItemArray = dr.ItemArray()
       Next
   Next
  
   ugProducts.DataSource = lfTable
  </code></pre>
  
  <p>Screenshot of the grid after assigning it the <code>DataSource</code></p>
  
  <p><a href="https://i.stack.imgur.com/cDQag.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cDQag.jpg" alt="enter image description here"></a></p>