Dropdown list from table in ASP NET MVC

Question

I want to get dropdown list with values from table. I'm have model:

namespace MobileService.Models
{
    public class Mobile
        {
            public int Id { get; set; }

            public string Model { get; set;}

            Public string EMEI { get; set ;}

            public int MasterId { get; set; }

            public List<Master> MasterList { get; set; }
    }

    public class Master
    {
        public int Id { get; set; }

        public string Name { get; set; }
    }

}

In controller I creat action for this model:

    public ActionResult Create()
    {
        return View();
    }

In view:

@model MobileService.Models.Mobile
@using (Html.BeginForm()) {

 @Html.EditorFor(model => model.Model)
 @Html.EditorFor(model => model.EMEI )
 // And here i want to display a dropdown list with all available masters

<button type="submit" class="btn btn-primary">Creat</button>
}

But it always tell me that Model.MasterList is null . But why? In model i told to get list from another model (public List MasterList { get; set; }). Why is it null?

Show us the controller code where you suppose to load your model.. — Oscar
– Oscar, Commented Nov 24, 2014 at 20:20
C# MVC get values from dropdownlist amazing what a Simple GOOGLE SEARCH can Yield — MethodMan
– MethodMan, Commented Nov 24, 2014 at 20:22
Model.MasterList is null . But why? - what makes you think it wouldn't be? — Ant P
– Ant P, Commented Nov 24, 2014 at 20:25
Try this topic. There's an explanation on how to create DropDownList. — Celdor
– Celdor, Commented Nov 25, 2014 at 0:11
But it always tell me that Model.MasterList is null Currently, based on your code, you are not returning anything to View: return View() // it's EMPTY. Therefore, your model is null, even though the View expects Mobile. Later, look for SelectList and DropDownList. SelectList can be tricky but once you have understood it, It's easy to create DropDonwList, or even better DropFownListFor — Celdor
– Celdor, Commented Nov 25, 2014 at 0:14

L202 · Accepted Answer · 2014-11-24 20:28:23Z

0

This code is in VB. In the beginning even i looked for a lot of time this is the simple solution i found.

Convert the model into list of selectListItems

Dim lstEmpTypes As New List(Of SelectListItem)



lstTicketWrTypes.Add(New SelectListItem With {.Text = row("Something"), .Value = row("Something")})

'Then load it into a ViewBag

ViewBag.EmpTypes = lstEmpTypes

'And in you View

                 @Html.DropDownList("selectWrType", New SelectList(ViewBag.EmpTypes , "Value", "Text"), New With {.class = "span3"})

answered Nov 24, 2014 at 20:28

L202

953 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Honorable Chow · Accepted Answer · 2014-11-24 20:29:08Z

0

When you query for Mobile you need to Include("MasterList"), or turn lazy loading on on your context (not recommended)

answered Nov 24, 2014 at 20:29

Honorable Chow

3,1833 gold badges26 silver badges22 bronze badges

Comments

dantey89 · Accepted Answer · 2014-11-25 16:22:48Z

0

The answer for me was to add this to controller:

   public ActionResult Create()
    {    
     ViewBag.MasterId = new SelectList(db.Masters, "Id", "Name");
     return View();
    }

Then in view to show droplist:

 @Html.DropDownList("MasterId", null, htmlAttributes: new { @class = "form-control" })

Thnx ZikO who let me now that list didn't loaded automatical.

answered Nov 25, 2014 at 16:22

dantey89

2,2971 gold badge28 silver badges37 bronze badges

Collectives™ on Stack Overflow

Dropdown list from table in ASP NET MVC

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related