capture data in datagridview
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"
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)
Dim table As New DataTable()
'Set as DataSource for grid
Me.dgResults.DataSource = table