Hi All,
Hope someone here can help me. I've been searching all day to no avail. I've found multiple ways to put data into a datagridview, but when it comes to taking it from the datagridview to a table I come up empty. I may be trying to do something that can't be done, but what I want to do is have a click event inwhich the data in the datagrid is saved to a table in my dataset and updated to the database. Below is the code I use to populate the grid, but so far reverse engineering has netting me a good result.

Private mAdapter As New OleDb.OleDbDataAdapter()
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source='I:\Wave_Selection\Wave_Selection.mdb';Pers ist Security Info=False"
        'Load DataGridView

        mAdapter.SelectCommand = _
            New OleDb.OleDbCommand(SQL1, New OleDb.OleDbConnection(connectionString))

        'Auto-Generate INSERT, UPDATE and DELETE sql commands
        Dim cb As New OleDb.OleDbCommandBuilder(mAdapter)

        'Fill table
        Dim table As New DataTable()
        mAdapter.Fill(table)
        'Set as DataSource for grid
        Me.dgResults.DataSource = table