Hi guys i have this code which insert the data in the textbox
Dim FilePath As String = "C:\Users\ezekiels\Desktop\New Folder\EBU 6.mdb"
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FilePath & "")
conn.Open()
Dim myadapter As New OleDbDataAdapter("SELECT * FROM Table_EBU6", conn)
Dim dtset As New DataSet
myadapter.Fill(dtset)
myadapter.Dispose()
Dim table As DataTable = dtset.Tables(0)
Me.Jan_Revenue2.Text = table.Rows(0).Item(1)
Me.Feb_Revenue2.Text = table.Rows(1).Item(1)
Me.Mar_Revenue2.Text = table.Rows(2).Item(1)
conn.close
what if i need to edit the Textbox and the record will update in access?