Update a Database through Dataset [Resolved]

[FishGuy]

Im sure I had this working before but now it only appears to work i.e the text box updates and the code doesnt error, but the change isnt reflected in the database. Basically all I have is a text box bound to a dataset, the user can edit the text box and on clicking the button it should update the database through the data adapter.

Private Sub btnUpdateCont_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateCont.Click
 
        Me.SqlDataAdapter1.Update(DsUser1)
        DsUser1.AcceptChanges()
        Me.lblChanged.Text = "Detail Changes Successful"
    End Sub

or does this just update the dataset and not the database? If not what is the code for doing so? pls.