Copy a record from one datagrid view to another

[Yippiekaiaii]

Hello All

I am writing a programme that copies the selected row in one datagridview to a new row in a second datagridview when a button is clicked.

Can someone tell me the best way to go about this?

This is my code thus far:

Imports System.Data.OleDb

Public Class Form1
    Dim cs As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\VB\DBSelectAndAddTest\addtest.accdb")
    Dim daCat As New OleDbDataAdapter("SELECT Catalogues.* from Catalogues", cs)
    Dim daOrd As New OleDbDataAdapter("SELECT * from Order", cs)
    Dim ds As New DataSet
  

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        daCat.Fill(ds, "Catalogue")
        daOrd.Fill(ds, "Order")

        dgcats.DataSource = ds.Tables("Catalogue")
        dgorder.DataSource = ds.Tables("Order")

    End Sub