Asp.net mvc dropdown-list from database with 2 data

Question

I'm trying to do a dropdownlist from database that have 2 values (zipcode and city). In my table I only have "ZipCode" and "City" meaning I don't have id and I've used my ZipCode as id so far.

I want the dropdown show "Select city"

New York 10001
New York 10010
Los Angeles 90001
etc

But now it's only showing like this:

New York
New York
Los Angeles

So if there is two New York then you don't know which one to choose since there is no zipcode. I could change that I shows only zipcodes and not cities and that works, but I want to show both.

In my Customers.cs I have this:

public partial class Customers
{
 public int CustomerId { get; set; }
    public string Name { get; set; }
    public string Address { get; set; }
    public string ZipCode { get; set; }
    public virtual Cities Cities { get; set; }
}

In my Cities.cs I have this:

public partial class Cities
{
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
    public Cities()
    {
        this.Customer = new HashSet<Customers>();
    }

    public string ZipCode { get; set; }
    public string City { get; set; }

    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
    public virtual ICollection<Customers> Customer { get; set; }
}

In my create.cshtml I have this:

<div class="form-group">
    @Html.LabelFor(model => model.ZipCode, "Cities", htmlAttributes: new { @class = "control-label col-md-2" })
    <div class="col-md-10">
        @Html.DropDownList("ZipCode", null, htmlAttributes: new { @class = "form-control" })
        @Html.ValidationMessageFor(model => model.ZipCode, "", new { @class = "text-danger" })
    </div>
</div>

In controller it's like this:

public ActionResult Create()
{
        ViewBag.ZipCode = new SelectList(db.Cities, "ZipCode", "City");
        return View();
}

How can I change this? I'm stuck..

Richard Deeming · Accepted Answer · 2021-11-25 15:19:41Z

1

Try:

ViewBag.ZipCode = db.Cities.Select(c => new SelectListItem
{
    Value = c.ZipCode,
    Text = $"{c.City} {c.ZipCode}",
});

answered Nov 25, 2021 at 15:19

Richard Deeming

31.5k11 gold badges86 silver badges167 bronze badges

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

1 Comment

JennieKari Over a year ago

Ah awesome thanks!! That worked :)

Collectives™ on Stack Overflow

Asp.net mvc dropdown-list from database with 2 data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related