Populating data on drop-down list in ASP.Net MVC

Question

I am trying to Load data from Category table into a Bootstrap Drop down list like:

  <div class="form-group">
            <label for="sel1"></label>
            <select class="form-control" id="cat">
                <option>Select From The List</option>
                @{
                    DataEntities ctx = new DataEntities();
                    var cat = ctx.Categories.OrderByDescending(p => p.CategoryName);
                    foreach (var item in cat)
                    {
                        <option>item</option>
                    }
                }
            </select>
        </div>

but I am getting this is result

the count of item is equal to number of rows in Category table but I am not getting the actual value! What am I doing wrong?

Eric Sondergard · Accepted Answer · 2016-11-01 18:01:50Z

2

You're missing an @ symbol in your option tag.

foreach (var item in cat)
{
    <option>@item</option>
}

In your code, you're just adding the string "item" for each item in cat.

answered Nov 1, 2016 at 18:01

Eric Sondergard

6057 silver badges22 bronze badges

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

2 Comments

Eric Sondergard Over a year ago

I also want to add that those missing @'s like this get me way more often than they should, heh.

Bosco Over a year ago

@Mona Coder You should also consider adding values to your options <option value="@item">@item</option>

Collectives™ on Stack Overflow

Populating data on drop-down list in ASP.Net MVC

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related