Overview: Hey All, Let's make something on ASP.NET. This application contains basic CRUD Operation such as Create, Update, Delete.
Software Requirements Used:
- Microsoft Visual Studio 2019.
- SQL Server 2017.
Description: In this project description contain details about resource and system requirement used for develop Person Details form. This project use stored procedure for insert, update and delete operations. This project folder contains three sub-folder, 1)Project_Source_Code – contain entire source code of project, 2)Database – contain database scripts and store procedure, taken on project execution phase.
Database: In the database section,
- Create database using create database query.(Name: PersonDetails)
- Create 2 Table using create table query. (Name: Details, PersonAddress).
- Execute PersonInsertandUpdate_Store_Procedure. (For Insert and Update Element in Table)
- Execute PersonDetailsDelete_Store_Procedure. (For Delete Element in Table)
- Execute PersonDetailsView_Store_Procedure. (For View All Element In Table) 6 .Execute PersonDetailsViewById_Store_Procedure. (For Select Particular Element In Table)
(For Better Experiences also added the BACKUP of the Database – simply import this database and run this source code [PersonDetails.bak] )
After Executed the above SQL Query Open Project in Visual Studio and Run the Project.