I'm trying to figure out how to update a cell in a datagrid and also how to add or delete rows so it's saved in Access.
I have the datagrid1 property options set to true for "AllowUserToAddRows and DeleteRows"
So, I need to be able to save the changes to the database.
I used the wizard to create the adapter and the dataset. It fills the the datagrid fine with the code below.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load