I have got the following code in my form load function;
da_products = New OleDb.OleDbDataAdapter(SQL_String, con)
dt_Products = New DataTable
'Assign datatable to datagrid
RadGridView1.DataSource = dt_Products
RadGridView1.Columns(0).Width = 100
RadGridView1.Columns(1).Width = 300
This displays the database as expected (two text fields and around twenty tick boxes).
I then have a button to allow me to save the RADGRIDVIEW back to my database, but this does not work and comes up with error
System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
Code in update button;
Private Sub CmdDatabaseSave_Click(sender As Object, e As EventArgs) Handles cmdDatabaseSave.Click
da_products and dt_Products are defined as global
Public da_products As OleDb.OleDbDataAdapter
Public dt_Products As DataTable