title: How can I add the selected row that has been deleted to a backup database?
body: <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Private Sub Delete1_Click(sender As Object, e As EventArgs) Handles Delete1.Click
          Dim mResult
          Dim ObjConnection As New MySqlConnection()
          mResult = MsgBox("You are really want to delete the slected record?",
          vbYesNo + vbQuestion, "Removal Confirmation")
          If mResult = vbNo Then
              Exit Sub
          End If
          ObjConnection.ConnectionString = "server=127.0.0.1;userid=root;password=;database=equipment"
          ObjConnection.Open()
          Try
              Dim ObjCommand As New MySqlCommand()
              ObjCommand.Connection = ObjConnection
  
              ObjCommand.CommandText = "delete from equipment where asset_code='" &amp; Me.DataGridView1.CurrentRow.Cells(0).Value &amp; "'"
              ObjCommand.ExecuteNonQuery()
          Finally
              ObjConnection.Close()
          End Try
  
          Me.DataGridView1.Rows.Remove(Me.DataGridView1.CurrentRow)
  
      End Sub</code></pre>
  </div>
  </div>
  </p>
  
  <p>This is my code for the button when the selected row is deleted, I want to insert it to a new database</p>