Question Updating with a table adapter

[QEDDave]

I have a simple Windows form in VB: textbox bound thru an adapter and a bindingsource to my dataset.

I have a button that on Click I want it to update the database. The form loads and the first data row shows in the textbox, I change the text then click my button but no update happens.

Any ideas what I'm dooing wrong, or how I should do this??

Thanks,
Dave

Public Class Form1

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Me.AToolsTableAdapter.Fill(Me.Qedsandb_TroyDataSet.aTools)

End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

AToolsTableAdapter.Update(Qedsandb_TroyDataSet.aTools)

End Sub
End Class

 

[jmcilhinney]

What value is returned by your call to Update? If it's not zero then the changes are being saved and you're just looking in the wrong place or at the wrong time. In that case, follow the first link in my signature to learn how to manage local data files.