Showing Access Database data in VB textboxes?

See more:

Visual-Studio

MS-Access

database

, +

Hey there, I would like to know how to display Access data from certain fields in VB's textboxes using SQL? I'm a beginner to VB and I've been searching a lot but I can't seem to get it working...

So far, following a tutorial, I can display every row of a column in Message boxes but I want it to show in textboxes and people should be able to edit it and save the changes to the database

Here's the code:

Imports System.Data.OleDb
Public Class Form1
    Dim SQL As String
    Dim dbConnection As OleDbConnection
    Dim dbCommand As New OleDbCommand
    Dim dbFilePath As String = "C:\..\..\..\dbTest.accdb"

'When user clicks writes something on textbox1 and then clicks Button Insert
    Private Sub buttonInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles buttonInsert.Click
        dbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & dbFilePath)
       
        SQL = "INSERT INTO tblTest (fldTest) VALUES ('" & TextBox1.Text & "')"
        dbConnection.Open()
        dbCommand = New OleDbCommand(SQL, dbConnection)
        dbCommand.ExecuteNonQuery()
        dbConnection.Close()
    End Sub

'When user clicks Button Read
    Private Sub buttonRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles buttonRead.Click
        SQL = "SELECT fldTest FROM tblTest"
        dbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & dbFilePath)
        dbCommand = New OleDbCommand(SQL, dbConnection)
        Dim data As New OleDbDataAdapter(dbCommand)
        Dim table As New DataTable("Test")
        dbConnection.Open()
        data.Fill(table)
        For Each row As DataRow In table.Rows
            MessageBox.Show(row.Item("fldTest"))
        Next
    End Sub

End Class

Here's a screen that shows my sample form and the sample database http://goo.gl/yLkuc

Now I have textbox2 and textbox3 and I want the field1 and field2 from the database to show in textbox 2 and textbox3 respectively

How can I do it?