How to keep the id from the selectlist when using multiple columns in the textfield

Question

I am trying to show multiple columns from my database in a dropdownlist using a SelectList

public ActionResult Create()
    {
        var times = db.Show_Courses
                 .Select(x =>
                         new {
                             id = x.show_course_id,
                             times = x.show_course_before + "," + x.show_course_after
                         });


        ViewBag.course_id = new SelectList(times, "id", "times");
        return View();
    }

It shows up properly in the view but in the database the value of the id is 0

This was my code before i wanted to show two columns in the textfield of the selectlist

public ActionResult Create()
    {
        ViewBag.course_id = new SelectList(db.Show_Courses, "show_course_id", "show_course_time_before");
        return View();
    }

And here is my code in the view

        <div class="form-group">
        @Html.LabelFor(model => model.course_show_id, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.DropDownList("course show id", (SelectList)ViewBag.course_id, new { htmlAttributes = new { @class = "form-control" } })
            @Html.ValidationMessageFor(model => model.course_show_id, "", new { @class = "text-danger" })
        </div>
    </div>

So my question is how can I display 2 values in the Textfield of the Selectlist without the id becoming 0?

score 0 · Answer 1 · edited May 23 '17 at 12:08

0

You could generate SelectList manually.

For example,

ViewBag.course_id = db.Show_Courses
   .Select(x => new SelectListItem { 
       Text = x.show_course_before + "," + x.show_course_after, 
       Value = x.show_course_id.ToString() })
   .ToList();

I personally like to use strongly type model. You can read more here

edited May 23 '17 at 12:08

Community

1
1

answered Jan 05 '17 at 18:02

Win

61,100
13
102
181

Okey now i have an error in the view at compile time: The System.Collections.Generic.List-Type cannot be converted to System.Web.Mvc.SelectList."} – David Schmalzer Jan 05 '17 at 18:07
`@Html.DropDownList("course show id", (IList)ViewBag.course_id, new { htmlAttributes = new { @class = "form-control" } })` Replace ***SelectList*** with ***IList*** – Win Jan 05 '17 at 18:08
Thanks, but the id still becomes 0 when inserting it into the database :( – David Schmalzer Jan 05 '17 at 18:11
`"course show id"` is not a valid Id, so ModelBinder could not bind the posted value. You need to read [this](http://stackoverflow.com/questions/37818949/best-programming-practice-of-using-dropdownlist-in-asp-net-mvc/37819577#37819577). You won't have this problem if you use strongly type Model since the beginning. – Win Jan 05 '17 at 18:14
I changed the things you mentioned and i still get 0 for my id – David Schmalzer Jan 05 '17 at 19:33

score 0 · Answer 2 · answered Jan 05 '17 at 18:12

0

Your code seems to be fine, you need to map the dropdown to according value from model: show_course_id - from what I see, so please update your dropdown to:

@Html.DropDownList("show_course_id", (SelectList)ViewBag.course_id, new { htmlAttributes = new { @class = "form-control" } })

answered Jan 05 '17 at 18:12

Ionut N

434
4
9

I tried your solution without changin anything else of my sourcecode but still the id is 0 – David Schmalzer Jan 05 '17 at 19:33

How to keep the id from the selectlist when using multiple columns in the textfield

2 Answers2