Create DropDownListFor in MVC and bind data from Database

Question

hi I am developing a MVC application in one of The View I need to have a dropdownlist where user can select account_code and the selected value need to be posted back to controller so that further processing of data takes place. I need to populate this drop down from a table viz Account_Master in my database. I tried many tutorials from net but nothing fit in my scenario. Could you plz guide me step by step. Thanks in advance.

Jignesh Trivedi · Answer

hi Please refer below link to know how can you bind dropdown list in MVC http://www.c-sharpcorner.com/UploadFile/esubal/mvc-populate-dropdown/ and refer below link to fire onchange event of drop down list in mvc http://www.a2zmenu.com/Blogs/MVC/How-to-fill-DropdownList-control-and-SelectedIndexChanged-event-in-MVC.aspx # hope this will help you.

Anupam Singh · Answer

Hi Siraj. follow these steps : 1. create model ... class EmpTable { public int EmpID { get; set; } public string EmpName { get; set; } public IList bindEmp{get;set} } 2. controller action.. public ActionResult FillDeptName() { var emp = new EmpTable(); emp.bindEmp = (from data in context.tblEmployee select new SelectListItem() { Text = data.EmpName Value =data.EmpID }).ToList (); return View(Createemp); } 3.view. @model EmpTable Dept Name: @Html.DropDownList(EmpName Model.bindEmp Select) Hope will help. However there are many other ways to do this but this is clear and easy to understand.