Vb.net Access Database Example «LIMITED – Breakdown»

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"

If String.IsNullOrWhiteSpace(txtLastName.Text) Then MessageBox.Show("Last Name is required") Return False End If

Private Sub btnDelete_Click(sender As Object, e As EventArgs) Handles btnDelete.Click If dgvUsers.SelectedRows.Count = 0 Then MessageBox.Show("Please select a record to delete") Return End If Dim userID As Integer = Convert.ToInt32(dgvUsers.SelectedRows(0).Cells("UserID").Value) vb.net access database example

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

MessageBox.Show("Record added successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information) ClearInputs() LoadData() ' Refresh the grid End Sub Imports System

Dim result As DialogResult = MessageBox.Show("Are you sure you want to delete this record?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)

Return True End Function Add this to the Update button: vb.net access database example

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