Here is the code I use and it appears to work well. My question is how do I get the newly edited values from the GridView and update the corresponding selected tuple.
Dim conX As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; Data Source=|datadirectory|questions.mdb; Jet OLEDB:Database Password=theh3t; ")Dim sel1 As String = "Select * from creds where Username like '" & TextBox1.Text.Trim & "'"Dim commandX As New OleDbCommand()commandX.Connection = conXcommandX.CommandText = sel1commandX.CommandType = CommandType.TextTry conX.Open() Dim adapterX As New OleDbDataAdapter(commandX) Dim tableX As New DataTable() adapterX.Fill(tableX) GridView1.DataSource = tableX GridView1.DataBind() Catch ex As Exception GridView1.EmptyDataText = "Unable to get records " & Err.DescriptionFinally conX.Close() conX = NothingEnd Try