Populate dropdown from entity framework db context

Question

I know that there are plenty of similar questions but I couldn't get it working ... I want to populate dropdown list from entity framework entity. I have following entity class:

namespace Accounting.Entity
{
    [Table("Cities", Schema = "np")]
    public class Cities
    {
        [Key]
        [XmlElement("Ref")]
        public System.Guid Ref { get; set; }
        [XmlElement("Description")]
        public string Description { get; set; }

    }
}

Controller:

public class OrderController : Controller
{

    public ActionResult PopulateCitiesDD()
    {

        var list = _repository.All<Cities>().ToList();
        ViewBag.MyCities = new SelectList(list, "Ref", "Description", 0);
        return View();
    }
}

What should I use in the view to populate dropdown?

DropDownListFor is fine

Andy Wiesendanger
– Andy Wiesendanger

2015-10-02 16:00:09 +00:00
Commented Oct 2, 2015 at 16:00 — Andy Wiesendanger
– Andy Wiesendanger, Commented Oct 2, 2015 at 16:00
what is the first param for DropDownListFor?

Dmitrij Kultasev
– Dmitrij Kultasev

2015-10-02 16:06:21 +00:00
Commented Oct 2, 2015 at 16:06 — Dmitrij Kultasev
– Dmitrij Kultasev, Commented Oct 2, 2015 at 16:06

Peter · Accepted Answer · 2015-10-02 16:56:48Z

1

Based on the controller/action code you posted, you could create a dropdown list in your view like this:

@Html.DropDownList("city", (SelectList)ViewBag.MyCities)

answered Oct 2, 2015 at 16:56

Peter

12.8k4 gold badges36 silver badges39 bronze badges

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

3 Comments

Dmitrij Kultasev Over a year ago

Message=There is no ViewData item of type 'IEnumerable<SelectListItem>' that has the key 'city'.

Peter Over a year ago

Hmm. Just to be sure: you're setting ViewBag.MyCities in the controller?

user3559349 Over a year ago

@sidux, You would only ever get that message if ViewBag.MyCities is null (possibly because in a POST method you return the view but have not reassigned ViewBag.MyCities as you did in the GET method)

Collectives™ on Stack Overflow

Populate dropdown from entity framework db context

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related