Create DropDownListFor in MVC and bind data from Database

Siraj Ahmed Mujahid

12y1.7k.NET

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
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 Singh12y ago
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("Create",emp);
}

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.