CRUD Functions in ASP.NET C# Using SQL Server and AngularJS

We’ll build a small app that manages a “Student” table with fields like:

StudentID
Name
Email
Age
City

We’ll use:

Frontend: AngularJS
Backend: ASP.NET Web API (C#)
Database: SQL Server

Step 1. Create Database and Table

Step 2. Create ASP.NET Web API Project

Open Visual Studio → Create a new project → Choose
ASP.NET Web Application (.NET Framework)
Select Web API template → Name it StudentAPI.

Step 3. Create the C# Model

File: Models/Student.cs

Step 4. Database Connection Class

File: Models/DbClass.cs

Step 5. Web.config Connection String

Step 6. Create Web API Controller

File: Controllers/StudentController.cs

Step 7. Frontend Using AngularJS

Create a new HTML file in your project (e.g., index.html) and include AngularJS.

Step 8. Run and Test

Run your ASP.NET Web API project (it should start on https://localhost:xxxx/).
Open index.html in the browser.
You can now Add, Edit, Delete, and View student records in real-time.

External References

Microsoft Docs – ASP.NET Web API
AngularJS Official Documentation
SQL Server Management Studio (SSMS)

Summary

You’ve successfully built a complete CRUD system using:

AngularJS for frontend UI and API communication.
ASP.NET Web API (C#) for backend logic.
SQL Server for data persistence.

This structure is lightweight, scalable, and ideal for small-to-medium web applications.

ASP.NET 10.0 Hosting Recommendation

ASP.NET is a powerful platform for creating web applications and services. You must be comfortable with JavaScript, HTML, CSS, and C# before developing a web application in ASP.NET. On the market, there are thousands of web hosting companies providing ASP.NET Hosting. But, only very few web hosting companies could provide high quality ASP.NET hosting solution.

ASP.NET is the best development language in Windows platform, which is released by Microsoft and widely used to build all types of dynamic Web sites and XML Web services. With this article, we’re going to help you to find the best ASP.NET Hosting solution in Europe based on reliability, features, price, performance and technical support. After we reviewed about 30+ ASP.NET hosting providers in Europe, our Best ASP.NET Hosting Award in Europe goes to HostForLIFE.eu, one of the fastest growing private companies and one of the most reliable hosting providers in Europe.