Vb Net Lab Programs For Bca Students Fix -

Your nested loops are off by one. Use this standard bubble sort fix:

Imports System.Data.OleDb Private Sub btnInsert_Click(sender As Object, e As EventArgs) Handles btnInsert.Click ' Step 1: Connection string Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\BCA_Lab\CollegeDB.accdb" Dim conn As New OleDbConnection(connString) vb net lab programs for bca students fix

' Step 2: SQL Query (Use Parameters to avoid SQL Injection and quote errors) Dim query As String = "INSERT INTO Students ([Name], [Age], [Course]) VALUES (?, ?, ?)" Dim cmd As New OleDbCommand(query, conn) Your nested loops are off by one

' Step 3: Add parameters cmd.Parameters.AddWithValue("?", TextBox_Name.Text) cmd.Parameters.AddWithValue("?", Val(TextBox_Age.Text)) cmd.Parameters.AddWithValue("?", TextBox_Course.Text) [Course]) VALUES (?