This project was created to practise CRUD Operations for ASP.NET,SQL using Stored Procedures (ASP.NET Core Web App - Model View Controller)
- Create a Database and Table:
- Use SQL Server Management Studio to create a database called "EmployeeDB" and a table called "Employee" with columns such as EmployeeID, FirstName, LastName, Email, and Salary.
-
Create a Model Class
-
Establish Database Connection:
- Configure a connection string in your web.config or appsettings.json file.
-
Create a Stored Procedure for Insert:
-
Create an ASP.NET Page for Data Entry:
- Create a web form with TextBox controls for each input field. Handle the button click event to insert data into the database using ADO.NET or Entity Framework.
-
Create a Stored Procedure for Select (Read):
-
Display Data in an ASP.NET Page:
- Create an ASP.NET page that retrieves data from the "GetEmployees" stored procedure and displays it in a GridView control.
-
Create a Stored Procedure for Update:
-
Implement Record Update in ASP.NET:
- Create an ASP.NET page that allows users to edit existing data and update it using the "UpdateEmployee" stored procedure.
- Create Implement Record Deletion in ASP.NET:
- Create an ASP.NET page that allows users to delete records using the "DeleteEmployee" stored procedure.
- Error Handling and Validation:
- Add error handling for exceptions and validate user inputs to ensure data integrity.
- User Authentication and Authorization:
- Implement user authentication and authorization to control who can perform CRUD operations.
- Advanced Features (Optional):
- Add features like pagination, sorting, searching, or filtering to enhance the user experience.