Crud Operation in VB.net Windows Application

Crud Operation in VB.net

This is a simple window application.it's developed using Vb.net and backend MS SQL Express LocalDB.In this project You will learn how to Create, Retrieve, Update and Delete in vb.net.

This project interface contains the Profile Form Panel, Data Grid View that displays the list of students, and the action buttons section.

The Update Button will be enabled when DataGridView Cell is clicked. The action for the Update Button is to update the existing data in the database.

Database Scripts

CREATE TABLE [dbo].[StudentInfo] (
    [Id]            INT            NOT NULL IDENTITY,
    [LastName]      NVARCHAR (20)  NULL,
    [FirstName]     NVARCHAR (20)  NULL,
    [MiddleName]    NVARCHAR (20)  NULL,
    [Gender]        NVARCHAR (7)   NULL,
    [Birthday]      DATETIME       NULL,
    [ContactNumber] NVARCHAR (11)  NULL,
    [Address]       NVARCHAR (200) NULL,
    [Course]        NVARCHAR (100) NULL,
    [Year]          NVARCHAR (50)  NULL,
    [Section]       NVARCHAR (50)  NULL,
    [SchoolAddress] NVARCHAR (200) NULL,
    [Created]       DATETIME       NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

Features Crud Operation in VB.net Windows Application

• Add New Data
• Updated Data
• Data List display
• Delete Data
• Load Data

How to run Crud Operation in VB.net Windows Application

• Open the extracted source code folder and locate the Solution file. The file is known as ProfilingSystem.sln.
• Open the solution file with your MS Visual Studio Software.
• Press the F5 key of your keyboard to run the program.

Code Download