DropDownList from Database using a viewmodel

Question

I'm building an ASP.NET MVC 4 web app which allows to create users which have a role. There's two roles : Administrator and User. When a registration comes, the user can choose thanks to a dropdown list the role of the new user. So here's what I've done so far.

My UserViewModel :

public class UserModel
{
    [Required]
    [StringLength(50)]
    [Display(Name="Username : ")]
    public string Username { get; set; }

    [Required]
    [DataType(DataType.Password)]
    [StringLength(50, MinimumLength=6)]
    [Display(Name = "Password : ")]
    public string Password { get; set; }


    public Role Role { get; set; }
}

And my HttpGet Method :

    [HttpGet]
    public ActionResult Registration()
    {
        context = new MainDatabaseEntities();
        ViewBag.Roles = new SelectList(context.Roles, "RoleId", "RoleDesc");
        return View();
    }

From here, I have no idea what I should do. Is my ViewModel good enough to do what I want (create and update an user)? How should I use my ViewBag.Roles into my Registration View?

Any help guys? I would appreciate it very much !

Go to http://www.asp.net/mvc/tutorials/older-versions/nerddinner/use-viewdata-and-implement-viewmodel-classes — Chirag Adhvaryu, Mar 25 '14 at 09:10
This could prove very helpful for you... http://stackoverflow.com/questions/781987/how-can-i-get-this-asp-net-mvc-selectlist-to-work — Paul Zahra, Mar 25 '14 at 09:12

score 3 · Accepted Answer · answered Mar 25 '14 at 09:06

3

View:

@Html.DropDownListFor(m => m.RoleId, (SelectList)ViewBag.Roles )

You should have a RoleId in your model to save the selected item in.

answered Mar 25 '14 at 09:06

Murdock

4,352
3
34
63

Yes indeed, through the Role object, I can get the RoleId and it works, thank you ! – Traffy Mar 25 '14 at 09:10

ElectricRouge · Answer 2 · 2014-03-25T09:15:48.280

0

You can use it like this.

@Html.DropDownList("Roles")

It will create the DropDownList for your ViewBag

edited Mar 25 '14 at 09:15

answered Mar 25 '14 at 09:10

ElectricRouge

1,239
3
22
33

Murali Murugesan · Answer 3 · 2014-03-25T11:25:15.667

0

You need to explicitly convert your ViewBag items to an expected type (IEnumerable<SelectListItem>), as ViewBag is a dynamic type

@Html.DropDownListFor(m => m.RoleId,((IEnumerable<SelectListItem>)ViewBag.Roles))

edited Mar 25 '14 at 11:25

answered Mar 25 '14 at 10:49

Murali Murugesan

22,423
17
73
120

Don't just post code here, explain it so future users can understand it better – Fabio Antunes Mar 25 '14 at 11:23
1

@FabioAntunes, added explanation – Murali Murugesan Mar 25 '14 at 11:26

score 0 · Answer 4 · answered Apr 04 '17 at 18:06

First look, it is showing you are trying to register the account. For that follow step by step procedure:

Register http get method add following line

ViewBag.Name = new SelectList(context.Roles.ToList(), "Name", "Name");

Then HttpPost methods add following line:

ViewBag.Name = new SelectList(context.Roles.ToList(), "Name", "Name");

In the register view add following line:

@Html.DropDownList("UserRoles", (SelectList)ViewBag.Name, " ")

I hope this will work.

DropDownList from Database using a viewmodel

4 Answers4