title: how to update empty datatable by the data from another datatable
body: <p>I have 2 servers that contain the same databases with the same structure (Main Server + Sub Server).</p>
  <ol>
  <li>I deleted all data from the table in the sub server.</li>
  <li>I got the data from the table from the main server and put it in Datatable.</li>
  <li>I copied the data from the Datatable of the server2.</li>
  <li>I use Dataadapter2 to update the table in the sub server.</li>
  </ol>
  <p>but still, the sub server is empty?!</p>
  <pre><code>'Delete Data From The Sub Server
      xSlConn.Open()
      Dim xcmddelete As New MySqlCommand(&quot;Delete FROM tblplaces&quot;, xSlConn)
      xcmddelete.ExecuteNonQuery()
  
  
      'Get Data Drom The Main Server
      Conn.Open()
      Dim xcmd1 As New MySqlCommand(&quot;SELECT * FROM tblplaces&quot;, Conn)
      Dim xdt1 As New DataTable
      Dim xda1 As New MySqlDataAdapter(xcmd1)
      xda1.Fill(xdt1)
  
  
  
      'Preparing the datatable for the Sub Server
      Dim xcmd As New MySqlCommand(&quot;SELECT * FROM tblplaces&quot;, xSlConn)
      Dim xdt2 As New DataTable
      Dim xda2 As New MySqlCommand(xcmd)
      Dim xB As New MySqlCommandBuilder(xda2)
      xda2.Fill(xdt2)
  
      'Copt the data from the main datatable to the sub datatable
      xdt2 = xdt1.Copy()
  
      'Update The Datatable2
      xB.GetUpdateCommand()
      xda2.Update(xdt2)
  </code></pre>