Performing CRUD Operations in ASP.NET MVC
In ASP.NET MVC, you can perform list, insert, update, and delete operations in a single view by following these steps:
- Create a Model: You need to create a model class that represents the data you want to work with. For example, let’s say we have a “Product” model with properties like ProductId, ProductName, and Price.
- Create a Controller: Next, you need to create a controller class that will handle the CRUD operations for the “Product” model. This controller will have action methods for listing, inserting, updating, and deleting products.
- Create Views: For each action method in the controller, you need to create views that will display the required data and provide the necessary user interface elements for performing CRUD operations.
List Operation
To perform the list operation, you can create a view to display a table of all products. In the controller’s action method, retrieve the list of products from the database and pass it to the view. Then in the view, iterate over the products and display them in a table.
Example
<table>
<tr>
<th>Product Id</th>
<th>Product Name</th>
<th>Price</th>
</tr>
@foreach (var product in Model)
{
<tr>
<td>@product.ProductId</td>
<td>@product.ProductName</td>
<td>@product.Price</td>
</tr>
}
</table>
Insert Operation
To perform the insert operation, you can create a form in the view with input fields for the product details. In the controller’s action method, receive the submitted form data and insert the new product into the database.
Example
<form action="/Product/Insert" method="post">
<label for="productName">Product Name:</label>
<input type="text" id="productName" name="productName" required>
<label for="price">Price:</label>
<input type="number" id="price" name="price" required>
<input type="submit" value="Submit">
</form>
Update Operation
To perform the update operation, you can create a form in the view with input fields pre-populated with the existing product details. In the controller’s action method, receive the submitted form data and update the corresponding product in the database.
Example
<form action="/Product/Update" method="post">
<input type="hidden" name="productId" value="@Model.ProductId">
<label for="productName">Product Name:</label>
<input type="text" id="productName" name="productName" value="@Model.ProductName" required>
<label for="price">Price:</label>
<input type="number" id="price" name="price" value="@Model.Price" required>
<input type="submit" value="Update">
</form>
Delete Operation
To perform the delete operation, you can create a button or link in the view that triggers the deletion of a specific product. In the controller’s action method, receive the product ID to be deleted and remove it from the database.
Example
<a href="/Product/Delete/@product.ProductId">Delete</a>
With these steps, you can perform list, insert, update, and delete operations in a single view in ASP.NET MVC.