MVC DropDownList讀取資料庫

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

View @Html.DropDownList("ProductionType", (SelectList)ViewBag.ProductionTypeList, "請選擇生產類型") Model public IEnumerable<ProductionType> GetProductionTypeList() { IList<ProductionType> result = new List<ProductionType>(); using (AbobSysEntities db = new AbobSysEntities()) { var ProductionTypeList = db.MasterCodeDetail.ToList(); foreach (var item in ProductionTypeList) { result.Add(new ProductionType { ID = item.ID, Name = item.Name }); } } return result; } Control SelectList ProductionTypeList = new SelectList(TOM.GetProductionTypeList(), "ID", "Name"); ViewBag.ProductionTypeList = ProductionTypeList;