Bound Text box not updating Database

[cday119]

I am trying to bind a textbox to a dataset. When I try to use the adapter.update command, nothing in the database update. I feel like I am doing something wrong. Here is my code

 
'Fill Computers Table
        Using da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(My.Settings.ComputersSQL, My.Settings.ConnectionString)
            da.MissingSchemaAction = MissingSchemaAction.AddWithKey
            da.Fill(dsHardware, "Computers")
        End Using
 
'Add DataBinding to Textboxe
        txtDeviceName.DataBindings.Add(New Binding("Text", dsHardware.Tables("Computers"), "Assignment", True, DataSourceUpdateMode.OnPropertyChanged))
 
'Update the Textbox's value
 
 Using da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(My.Settings.ComputersSQL, My.Settings.ConnectionString)
            Try                           
                da.Update(dsHardware, "Computers")
            Catch ex As Exception
                MsgBox(ex.Message)
            End Try
        End Using
 

I can see that the value in the dataset changes. I don't know if it matters but da.UpdateCommand is equal to nothing at the time I call da.Update.

[Curtis Rutland]

Well, your problem is that you are creating a new adapter to update from! You are disposing of your adapter after you bind fields. You need to keep the same adapter. Also, you need to give the adapter an update command.

You might want to look into using SqlDataSource. It makes binding a bit easier.

[cday119]

Alright, that was in the back of my mind but I wasn't quite sure. I'll try it out and tell you what I find.

Thanks