How to Create a Simple Employee Master Application using Visual Studio | VB .Net with SQL Server DB
This video explains how to create a Simple Employee Master Application using Visual Studio 2022 (Visual Basic | VB .Net) with SQL Server Database.
We have explained step by step on how to frame a Employee Master Application with a DATAGRIDVIEW added to the application to view the LIVE data from the database.
This video demonstrates how to use the CURD operations on a Employee Master, wherein Insert, Update and Delete commands are been executed over the SQL Server via Visual Studio (Visual Basic) program.
Please refer to previous videos for Installation of SQL Server 2022 : • How to Install SQL Server 2022 Database in...
For Installation SQL Server Management Studio (SSMS) : • How to Install SQL Server Management Studi...
For Database Creation in SQL Server : • How to Create a New Database in SQL Server...
Code for the Create Table & Insert used in the video is as under for your practice.
/* CREATE TABLE FOR EMPLOYEES TABLE */
CREATE TABLE EMPLOYEES
(
EMPLOYEE_ID VARCHAR(10) NOT NULL,
EMPLOYEE_NAME VARCHAR(30) NOT NULL,
EMPLOYEE_DESIGNATION VARCHAR(20) NOT NULL,
EMPLOYEE_SALARY NUMBER(5,2) NOT NULL,
EMPLOYEE_GENDER VARCHAR(10) NOT NULL,
EMPLOYEE_EMAIL VARCHAR(40)
CONSTRAINT PK_EMPLOYEE PRIMARY KEY(EMPLOYEE_ID)
)
/* INSERT STATEMENT FOR EMPLOYEES TABLE */
INSERT INTO EMPLOYEES VALUES ('10091','JESSY','MANAGER',52451,'FEMALE','[email protected]')
INSERT INTO EMPLOYEES VALUES ('10092','JIM','CLERK',15262,'MALE','[email protected]')
INSERT INTO EMPLOYEES VALUES ('10093','JACK','ASST. MANAGER',35451,'MALE','[email protected]')
