
Imports System.Data.OleDb
Public Class Form1
Dim objDA As OleDbDataAdapter
Dim objTable As DataTable
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
objDA = New OleDbDataAdapter("Select * From snippets", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Snippets.mdb")
objTable = New DataTable
objDA.Fill(objTable)
Dim commandBuilder As New OleDbCommandBuilder(objDA)
Dim objBS As New BindingSource
objBS.DataSource = objTable
BindingNavigator1.BindingSource = objBS
DataGridView1.DataSource = objBS
End Sub
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click
objDA.Update(objTable)
MsgBox("updated.")
End Sub
End Class