hi did u find the way to insert data as well as were u able to update changes to ur access db?
Thank you for your answer.
In the application i wish to buildt, the user adds rows in a plain DataGridView to the tables.
I have found one example that allows me to update and add rows, but get this error message if i try to make a buildt.
Eksample:
Dim UpdatePending As Boolean = False ’ in Public class
Me.OleDbDataAdapter1.Fill(Me.DataSet11.Table1) ’ in form_load
Private Sub ExampleBindingSource_ListChanged(ByVal sender As Object, ByVal e As System.ComponentModel.ListChangedEventArgs) Handles _ BindingSource1.ListChanged
If Me.DataSet11.HasChanges Then
Me.UpdatePending = True
End If
End Sub
Private Sub DataGridView1_RowValidated(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles _ DataGridView1.RowValidated
If UpdatePending Then
Me.OleDbDataAdapter1.Update(Me.DataSet11.Table1)
Me.UpdatePending = False
End If
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.DataGridView1.Rows.GetLastRow()
Me.OleDbDataAdapter1.Fill(Me.DataSet11.Table1)
End Sub
This is the close as I get, i can run the example and add rows and update it but I can not make a build because of this error message:
Argument not specified for parameter ‘includeFilter’ of ‘PublicFunction
GetLastRow(includeFilter As System.Windows.Forms.DataGridViewEleementsStates) As Integer’