Vb.net Access Database Example Info

Private Sub btnLoad_Click(sender As Object, e As EventArgs) Handles btnLoad.Click LoadData() End Sub Private Sub LoadData() Dim query As String = "SELECT * FROM Users"

Introduction Connecting a VB.NET application to a Microsoft Access database is one of the most common tasks for desktop developers. Whether you're building a small inventory system, a contact manager, or a data entry application, this guide will walk you through everything you need to know.

Using conn As New OleDbConnection(connectionString) Using cmd As New OleDbCommand(query, conn) cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text) cmd.Parameters.AddWithValue("@LastName", txtLastName.Text) cmd.Parameters.AddWithValue("@Email", txtEmail.Text) cmd.Parameters.AddWithValue("@Age", Convert.ToInt32(txtAge.Text)) cmd.Parameters.AddWithValue("@UserID", userID) conn.Open() cmd.ExecuteNonQuery() conn.Close() End Using End Using

Using conn As New OleDbConnection(connectionString) Using cmd As New OleDbCommand(query, conn) ' Add parameters to prevent SQL injection cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text) cmd.Parameters.AddWithValue("@LastName", txtLastName.Text) cmd.Parameters.AddWithValue("@Email", txtEmail.Text) cmd.Parameters.AddWithValue("@Age", Convert.ToInt32(txtAge.Text)) conn.Open() cmd.ExecuteNonQuery() conn.Close() End Using End Using vb.net access database example

Private Sub btnUpdate_Click(sender As Object, e As EventArgs) Handles btnUpdate.Click If dgvUsers.SelectedRows.Count = 0 Then MessageBox.Show("Please select a record to update") Return End If If ValidateInputs() = False Then Exit Sub

If result = DialogResult.Yes Then Dim query As String = "DELETE FROM Users WHERE UserID=@UserID" Using conn As New OleDbConnection(connectionString) Using cmd As New OleDbCommand(query, conn) cmd.Parameters.AddWithValue("@UserID", userID) conn.Open() cmd.ExecuteNonQuery() conn.Close() End Using End Using MessageBox.Show("Record deleted successfully!") LoadData() ClearInputs() End If End Sub Add these utility methods:

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load LoadData() End Sub Private Sub btnLoad_Click(sender As Object, e As EventArgs)

Imports System.Data.OleDb Public Class Form1 Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\VB.NET Projects\Demo\SampleDB.accdb"

Using conn As New OleDbConnection(connectionString) Using adapter As New OleDbDataAdapter(query, conn) Dim table As New DataTable() adapter.Fill(table) dgvUsers.DataSource = table End Using End Using

Private Sub btnInsert_Click(sender As Object, e As EventArgs) Handles btnInsert.Click If ValidateInputs() = False Then Exit Sub Dim query As String = "INSERT INTO Users (FirstName, LastName, Email, Age) VALUES (@FirstName, @LastName, @Email, @Age)" Private Sub btnLoad_Click(sender As Object

Dim query As String = "UPDATE Users SET FirstName=@FirstName, LastName=@LastName, Email=@Email, Age=@Age WHERE UserID=@UserID"

' Optional: Display record count lblStatus.Text = $"Loaded dgvUsers.Rows.Count records" End Sub Add this code to the Insert button:

If Not IsNumeric(txtAge.Text) Then MessageBox.Show("Age must be a number") Return False End If