Simple Add, Edit, Update, Delete, Search in VB.NET and MS Access with Source Code

Hello! I develop this application when I was a newbie in VB.NET programming. I want to share this sort of simple code for the beginner in the VB.NET language. This is a simple program that was originally programmed in Visual Studio 2008 and MS Access 2003. This application can Add, Edit, Update, Delete, Search records. The code itself is easy to understand which is can easily be modified. This has a pleasing user interface and user-friendly functionalities.

How it Works:

When Adding a record, the user must fill-up the form provided and click the "Add" Label to add the record into the list view. Take note that adding the record into the list view is not yet directly saved into the database. Below screenshot is the form provided.

And below image is the list view where the added data will temporarily save.

The user can also add multiple data and save them to the database at once. To do this, the user must add all the data into the list view before clicking the "Save" label.

The code itself also validates the IDNo entered if already exists on the database before adding it to the list. The following screenshot is a sample image when duplicate IDNo is tried to add into the list.

To update the existing record, select the target row from Data Grid View first then click the "Edit" label. After that, the update form will be popup.

The Delete feature of this application can be multiple or single data. To delete multiple data, select multiple rows in the Data Frid View first then click the "Delete" label.

The search feature scans only if the entered keyword or text has similar to the IDNo.

How to Run

Download and Install the following

• Microsoft Visual Studio
• Microsoft Access Database Engine 2010

Setup

• Download and Extract the source code zip file.
• Open the Extracted folder and locate the "BASIC in VB.NET.sln" file.
• Open the solution file (.sln) with your Microsft Visual Studio Software.
• Press the "F5" key on your keyboard to run.

Hope this code can help! :)