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 doing wrong, or how I should do this??

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