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.

Form

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

List View

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.

Duplicate

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.

Update

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.

Multiple Delete
Single Delete

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

Search

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! :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byph_donene (not verified)on Sun, 03/16/2014 - 10:51

hey ajroof thanks for your codes...i'm currently making a Student Information System. this codes will help a lot ^_^
Submitted byD.love (not verified)on Fri, 11/25/2016 - 17:43

In reply to by Anonymous (not verified)

Gudmorning, pls i want to use mysql as my databases, and the primary id with be firstname of the detail, but i did not know how to write the code for it. pls help me with something like these in my txtFirstName.text LastName.Text = "" txtResidential_Address.Text = "" txtLocalGovernment.Text = "" CmbRelationship.Text = "" txtTelephone.Text = "" txtregistration.Text = ""
Submitted bygidwon (not verified)on Tue, 07/22/2014 - 09:12

thanks the web site become. good

Submitted bymark ven (not verified)on Mon, 04/03/2017 - 09:08

Hi guys my name is mark ven and I want code delete,search,print,save,update.. Thanks
Submitted byaj_ellpo (not verified)on Sun, 12/03/2017 - 06:14

I really hope that this will help me for my school project

Submitted bymark manalansan (not verified)on Wed, 12/06/2017 - 08:23

thx for the code
Submitted bydhimz (not verified)on Sat, 01/16/2021 - 15:10

kindly email me the source can support visual studio 2019? i downloaded this, and got error on program. can not view the form

Add new comment