Private Sub txtSearch_TextChanged(sender As Object, e As EventArgs) Handles txtSearch.TextChanged Dim da As New OleDbDataAdapter("SELECT * FROM tblStudents WHERE StudentName LIKE '%" & txtSearch.Text & "%'", conn) Dim dt As New DataTable da.Fill(dt) DataGridView1.DataSource = dt End Sub Note: Use parameters to prevent SQL injection in production code. Add a "Export to Excel" button. This is a highly desired professional feature.
Introduction In the world of desktop application development, few combinations offer the perfect balance of simplicity, power, and rapid deployment as Visual Basic .NET (VB.NET) paired with Microsoft Access Database . Whether you are a student completing your final year project, a hobbyist building a personal inventory system, or a junior developer looking to sharpen your skills, this stack remains a timeless choice. vb.net projects with ms access database free download
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\MyDatabase.accdb" Or using a fixed path: Private Sub txtSearch_TextChanged(sender As Object