Create dropdown list of table

Question

I currently have a table of series. In this table, a field status_id exists, which is the foreign key linking to a table Status. A status can be new, running, ended,...

My model classes are looking like this:

public partial class Serie
{
    public Serie()
    {
        this.Episodes = new HashSet<Episode>();
    }

    public int ID { get; set; }
    public string Name { get; set; }
    public string Country { get; set; }
    public Nullable<int> Status_id { get; set; }

    public virtual ICollection<Episode> Episodes { get; set; }
    public virtual Status Status { get; set; }
}

Status:

public partial class Status
{
    public Status()
    {
        this.Series = new HashSet<Serie>();
    }

    public int ID { get; set; }
    public string Name { get; set; }

    public virtual ICollection<Serie> Series { get; set; }
}

When editinga serie, I'd like to have a dropdown list of all possible statuses (the name field) and receive this when a user submits the form. What's the best way to accomplish this?

Dave Alperovich · Accepted Answer · 2013-02-10 18:54:05Z

1

The simplest answer is that you need to a List of Executives, pass the list in a model back to your View, create a select list, and render a drop down list.

public ActionResult EditSomething()
{
    Model Model = new Model();
    Model.statusList = {some method to fill IEnumerable<status>};

    return View(Model);
}

In your View:

@Html.DropDownListFor(model => model.Id, new SelectList(Model.statusList, "Id", "Name "))

answered Feb 10, 2013 at 18:54

Dave Alperovich

32.6k8 gold badges82 silver badges101 bronze badges

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

Comments

Ryan Byrne · Accepted Answer · 2013-02-10 18:50:27Z

0

You need to create the dropdown list using <%= Html.DropDownList("StatusId", Model.Statuses)%>. You would populate your view model with all possible statuses, the record the id of the status the user selected in a variable that gets sent with your view model when the user submits the form. Here is an article detailing the process: http://odetocode.com/blogs/scott/archive/2010/01/18/drop-down-lists-and-asp-net-mvc.aspx

answered Feb 10, 2013 at 18:50

Ryan Byrne

8605 silver badges8 bronze badges

Collectives™ on Stack Overflow

Create dropdown list of table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related