(MVC) Html.DropDownList with viewbag error

Question

I'm trying to populate dropdownlist from sql database, but I get the following error:

'System.Char' does not contain a property with the name 'ID'.

Here is my code:

Controller:

string leaverulequery = "select ID,TypeDetail,LeaveType,Max from LeaveRule";
var leaver = db.LeaveRule.SqlQuery(leaverulequery).ToList();
var lists = new SelectList(leaverulequery, "ID", "TypeDetail");
ViewBag.CategoryId = lists;

View:

@Html.DropDownList("lv_type", (SelectList) ViewBag.CategoryId, "--Select One--", new{  @class = "form-control input-sm"})

And my Model:

public class LeaveRule
{
    [Key]
    public int ID { get; set; }
    public string LeaveType { get; set; }
    public int Max { get; set; }
    public string TypeDetail { get; set; }
}

Please help guys, seems simple but i really cant get through this.. And i also want to ask can we filter what record from database populated to that dropdownlist with attribute LeaveType as reference? Thankyou

new SelectList(leaver, "ID", "TypeDetail"); (not leaverulequery) — user3559349
– user3559349, Commented Jun 1, 2016 at 8:23

SilentCoder · Accepted Answer · 2016-06-01 08:27:15Z

1

string leaverulequery = "select ID,TypeDetail,LeaveType,Max from LeaveRule";
        var leaver = db.LeaveRule.SqlQuery(leaverulequery).ToList();
        var lists = new SelectList(leaver, "ID", "TypeDetail");
        ViewBag.CategoryId = lists;

In you code for selectedlist, the variable should be leaver. Not the leaverulequery

answered Jun 1, 2016 at 8:27

SilentCoder

1,9901 gold badge16 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

(MVC) Html.DropDownList with viewbag error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related