Update database from vb.net
<p>Is there a way I can update an Access database from text boxes in vb.net. My current program is capable of display the values from an Access database. </p>

<pre><code>Private Sub DateTimePicker1_ValueChanged(sender As Object, e As EventArgs) Handles DateTimePicker1.ValueChanged

    Dim ds As New DataSet

    Dim sql As String =
    "Select TOP 1 GEUR,GUSD FROM GBPtb WHERE Date= ?"

    Using connection As New OleDb.OleDbConnection(strConnectionString),
      command As New OleDb.OleDbCommand(sql, connection),
      adapter As New OleDb.OleDbDataAdapter(command)

        connection.Open()
</code></pre>

<p>How can I modify this program in a way that the user will be able to edit the currency exchange rates from the textboxes in the program? </p>