P
philip
On a form, I have a datagridview.
This datagridview is constructed on a dataset filled by a tableadapter.
The table adapter do very well what it must do when filling dataset.
Insertions, modifications and deletions functions very well in the dataset.
But impossible to transmit modifications in ACCESS database. Impossible to
WRITE in database.
Here is the code for data transmission from tableadapter to Access database
:
Private Sub ArtistesBindingNavigatorSaveItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ArtistesBindingNavigatorSaveItem.Click
Try
Me.Validate()
Me.ArtistesBindingSource.EndEdit()
Me.ArtistesTableAdapter.Update(Me.StarDvdDataDataSet.artistes)
System.Windows.Forms.MessageBox.Show("Success !")
Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
Program says "Success !" but nothing has changed in access database.
May be I am stupid, but I don't understand !
Please help me.
Excuse me for my english. I'm french.
This datagridview is constructed on a dataset filled by a tableadapter.
The table adapter do very well what it must do when filling dataset.
Insertions, modifications and deletions functions very well in the dataset.
But impossible to transmit modifications in ACCESS database. Impossible to
WRITE in database.
Here is the code for data transmission from tableadapter to Access database
:
Private Sub ArtistesBindingNavigatorSaveItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ArtistesBindingNavigatorSaveItem.Click
Try
Me.Validate()
Me.ArtistesBindingSource.EndEdit()
Me.ArtistesTableAdapter.Update(Me.StarDvdDataDataSet.artistes)
System.Windows.Forms.MessageBox.Show("Success !")
Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
Program says "Success !" but nothing has changed in access database.
May be I am stupid, but I don't understand !
Please help me.
Excuse me for my english. I'm french.