How do I get a dropdownlist to show value from database and not the selectlist?

Question

4.00/5 (1 vote)

See more:

I am using asp.net mvc with code first entity framework. The dropdownlist saves selected value to the database, but when I go back to the page it just shows the select list values from the model.

What I have tried:

Model
------------

public class myRating
   {
       public int fRatingId { get; set; }
       public string Desc { get; set; }

       public IEnumerable<SelectListItem> listRatings { get; set; }
   }

Controller
----------------

public List<SelectListItem> GetRatingList()
        {
            var ratingList = db.fRatings.ToList()
                .Select(d => new SelectListItem
                {
                    Value = d.fRatingId.ToString(),
                    Text = d.Desc
                });
            return ratingList.ToList();

        }

model.listRatings = GetRatingList();

View
--------------

@foreach (var item in Model.myDpExercises)
<tr>
    <td>
        @Html.DisplayFor(modelitem => item.Exercise)
    </td>
       <td>

                        @Html.DropDownListFor(modelItem => item.RatingId,Model.listRatings, "--Please Select--", new { id = "ddlRating", onchange = "UpdateRating(this)", data_mydpexid = item.Id })
                        
                    </td>
</tr>

Posted 14-Oct-19 2:15am

FrankStubbs

Updated 16-Oct-19 2:21am

Add a Solution

Comments

Richard Deeming 14-Oct-19 14:17pm

Is the problem that the "--Please Select--" option is always selected? That would be because you've not set the Selected property on any of the SelectListItem items.

But it's not clear from your code how you would know which item to select.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dnxit · Answer 1 · 2019-10-16T02:22:00

Though your question is not pretty clear what's the problem What I understood from

when I go back to the page it just shows the select list values from the model.

is you're not redirecting after a successful post back to database, so you want to insert another record at the same view. MVC usually Maintain Model state of selected data and if you want to clear the form after a successful post back then you can Clear model state.
e.g.

C#

[HttpPost]
public ActionResult Create(CreateRequest request)
{
    var vm = new CrateViewMModel();

    if (ModelState.IsValid && Save to db was success)
    {
        vm.ResultMessage = "Success";

        return View("Create",vm);
    }

    ModelState.Clear(); // add this if you want to clear for all controls
    ModelState.Remove("IsActive"); // if just want to clear one control

    return View(vm);
}