How to Do the CURD Operation In ASP.net With MVC

o perform CURD (Create, Update, Read, Delete) operations in ASP.NET MVC, follow these steps:

1. Create a new ASP.NET MVC project in Visual Studio.

2. Define the model for your data. This can be done by creating a new folder called "Models" in the project and adding a new class for your model. For example, if you are creating a simple employee management system, you can create a class called "Employee" with properties like Id, Name, Age, etc.

3. Create a new folder called "Controllers" in the project and add a new controller class. For example, you can create a class called "EmployeeController".

4. In the controller class, define the actions for each CURD operation. For example, you can have methods like "Create", "Edit", "Details", "Delete", etc. In these methods, you can perform the necessary logic to interact with the database or other data sources.

5. Create the corresponding views for each action. Views are used to display the data and receive user input. For example, you can have views like "Create.cshtml", "Edit.cshtml", "Details.cshtml", "Delete.cshtml", etc. You can use HTML helpers or Razor syntax to generate the necessary HTML elements for CRUD operations.

6. In the views, you can use form elements, buttons, and other HTML components to handle user input. You can also display the data from the model using Razor syntax.

7. In the controller actions, you can use the built-in model binding feature to automatically populate the model properties with user input. You can then perform the necessary CRUD operations using a database or other data sources.

8. To handle form submission and other user interactions, you can use HTTP verbs like GET and POST. For example, you can use the [HttpGet] and [HttpPost] attributes on your controller actions to specify the HTTP verb to be used.

9. Additionally, you can use validation attributes on the model properties to enforce data validation rules. For example, you can add [Required], [Range], or [RegularExpression] attributes to ensure that the user enters valid data.

10. Finally, you can deploy and run your ASP.NET MVC application to test and use the CRUD operations.

That's it! By following these steps, you can perform CURD operations in ASP.NET MVC. Remember to handle exceptions, secure your application, and follow best practices for database access and data validation.

public class EmployeeController : Controller
{
    private ApplicationDbContext db = new ApplicationDbContext();

    // Read (Retrieve)
    public ActionResult Index()
    {
        var employees = db.Employees.ToList();
        return View(employees);
    }

    // Create (Insert)
    public ActionResult Create()
    {
        return View();
    }

    [HttpPost]
    public ActionResult Create(Employee employee)
    {
        if (ModelState.IsValid)
        {
            db.Employees.Add(employee);
            db.SaveChanges();
            return RedirectToAction("Index");
        }
        return View(employee);
    }

    // Update (Edit)
    public ActionResult Edit(int id)
    {
        var employee = db.Employees.Find(id);
        if (employee == null)
        {
            return HttpNotFound();
        }
        return View(employee);
    }

    [HttpPost]
    public ActionResult Edit(Employee employee)
    {
        if (ModelState.IsValid)
        {
            db.Entry(employee).State = EntityState.Modified;
            db.SaveChanges();
            return RedirectToAction("Index");
        }
        return View(employee);
    }

    // Delete
    public ActionResult Delete(int id)
    {
        var employee = db.Employees.Find(id);
        if (employee == null)
        {
            return HttpNotFound();
        }
        return View(employee);
    }

    [HttpPost, ActionName("Delete")]
    public ActionResult DeleteConfirmed(int id)
    {
        var employee = db.Employees.Find(id);
        db.Employees.Remove(employee);
        db.SaveChanges();
        return RedirectToAction("Index");
    }
}

In ASP.NET MVC, CRUD (Create, Read, Update, Delete) operations can be achieved by following these steps:

1. Create Model: Define the data structure using models.
2. Create Controller: Generate controllers to handle interactions between views and models.
3. Create Views: Design views for user interfaces.
4. Implement Create: In the controller, handle HTTP POST requests to create new data entries.
5. Implement Read: Use actions in the controller to fetch and display data from the model.
6. Implement Update: Handle HTTP POST requests to update existing data entries.
7. Implement Delete: Process HTTP POST requests to remove data entries.
8. Routing: Configure routing to map URLs to controller actions.
9. Use Razor: Utilize Razor syntax in views for dynamic content rendering.
10. Entity Framework: Optionally, integrate Entity Framework for database operations.

Keep in mind MVC principles: Models represent data, Views display content, and Controllers handle requests. Use appropriate HTTP methods for each operation (GET for Read, POST for Create/Update/Delete).

https://www.c-sharpcorner.com/article/crud-operation-in-asp-net-mvc2/

Please refer to the below articles:
https://www.tutlane.com/tutorial/aspnet-mvc/ado-net-crud-operations-insert-update-delete-in-asp-net-mvc-4-example
https://ankitsharmablogs.com/crud-operation-with-asp-net-core-mvc-using-ado-net/
https://www.dotnettricks.com/learn/knockout/knockout-crud-operations-using-mvc4

Hi,

Do refer below articles 

https://www.aspsnippets.com/Articles/MVC-ADONet-CRUD-Select-Insert-Edit-Update-and-Delete-using-ADONet-in-ASPNet-MVC-Razor.aspx

https://www.compilemode.com/2016/05/video-crud-operation-in-Asp-Net-mvc-using-entity-framework.html?m=1

https://www.c-sharpcorner.com/UploadFile/0c1bb2/insertupdatedelete-in-Asp-Net-mvc-5-using-ado-net/

try below article using asp.net mvc5:

https://www.c-sharpcorner.com/UploadFile/0c1bb2/insertupdatedelete-in-Asp-Net-mvc-5-using-ado-net/

https://www.c-sharpcorner.com/article/crud-operation-in-asp-net-mvc2/

Please refer to the attached article