Help Updating the database

[markvan]

I have these 2 buttons, the load button works, it gets all the data into the dataset and I have bound some txtboxes to the dataset so it displays the relevant info.
My problem is when I try to update the changes I make.

Please comment on my code as I have stuffed around with this for hours and can't save the updates back into the database. The bolded line is the problem.

Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
' this loads all the data from the databse into the dataset
daAuthor.Fill(PolicyCreatorDataset1)
' Confirmation message
MsgBox("You have loaded this info")
End Sub

Private Sub btnSaveChanges_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveChanges.Click
' This is supposed to save the changes made in the dataset into the database
daAuthor.Update(PolicyCreatorDataset1, "tblAuthor")
' Confirmation message
MsgBox("You pressed the right button to save your editing")
End Sub

Mark Van
EZ-PC Help

http://www.ezpc.com.au

 

[chrissie1]

I suppose you used the wizard to make the dataset and dataadapter and the connection and all the other thins (Not a good choise).

before the update line add this

me.bindingcontext(PolicyCreatorDataset1).endcurrentedit

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting