Bind Dropdown list from Database and show in GridView

Question

How to bind drop down list in mvc using Sql server as Database and show the details in Gridview

Vincent Maverick Durano · Answer

GridView does not exist in MVC - What you can do is to load your grid data via AJAX call and generate the rows on the fly based on the value selected from the list. Or you could use WebGrid like this one: http://www.authorcode.com/filtering-records-in-webgrid-using-dropdownlist-in-mvc/ Here's another one example: http://www.c-sharpcorner.com/UploadFile/abhikumarvatsa/filter-records-in-mvc/

Abhineet Srivastava · Answer

Put some login in your controller to intertact with your model and get the result set. afterthatStore this data to Viewbag and send it to view where Dropdown located

ramya bharath · Answer

In the grid view create a template for displaying the details you require. For binding dropdownlist here is a examplehttp://www.c-sharpcorner.com/UploadFile/4d9083/binding-dropdownlist-in-mvc-in-various-ways-in-mvc-with-data/