hi
I am new to vb.net so please bear with me
I am trying to search a table with last and first name and update table after changes .I can retrieve rows and display in datagridview,
I would like to know how do I update table after changes, i would appreciate any help

Code:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
ds.Tables("table1").DefaultView.RowFilte… = "FName_ LIKE '*" & TextBox1.Text & "*' OR LName_ LIKE '*" & TextBox1.Text & "*'"
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Me.data IsNot Nothing Then
Dim builder As New OleDbCommandBuilder(Me.adapter)
Me.adapter.Update(Me.data)
End If
End Sub