How to fetch data from database to dropdown in ASP.Net MVC using separ

Question

Vishal Yelve · Answer

Hi Rutwik Do refer below article https://www.aspsnippets.com/Articles/2484/Populate-Bind-DropDownList-from-ViewModel-in-ASPNet-MVC/

Jayraj Chhaya · Answer

To fetch data from a database and populate a dropdown list in an ASP.Net MVC application using Entity Framework you can follow these steps: Create a model class for the data you want to fetch from the database. For example if you want to fetch a list of categories create a Category model class with properties like Id and Name . Create a DbContext class that inherits from DbContext and represents your database context. This class will have a DbSet property for the model class you created in the previous step. For example if you created a Category model class your DbContext class will have a DbSet property. Use Entity Framework to query the database and retrieve the data you need. In your controller action method create an instance of your DbContext class and use LINQ queries to fetch the data. For example to fetch a list of categories you can use dbContext.Categories.ToList() . Pass the fetched data to the view. Create a view model class that represents the data you want to display in the dropdown list. For example if you want to display the category names in the dropdown list create a view model class with a property like List CategoryNames . In your controller action method populate the view model with the fetched data and pass it to the view. For example if you have a view model class named CategoryViewModel  you can populate its CategoryNames property with the category names fetched from the database. In your view use the Html.DropDownListFor helper method to render the dropdown list. Pass the view model property that contains the data as the data source for the dropdown list. For example if your view model has a property named CategoryNames  you can use Html.DropDownListFor(m => m.SelectedCategory new SelectList(Model.CategoryNames)) .