How to bind dropdown values from Database through stored procedure in Strongly typed views in MVC..?

Question

I have a strongly typed view as shown below:

  <div class="form-group">
      @Html.LabelFor(model => model.Text, htmlAttributes: new { @class = "control-label col-md-2" })
         <div class="col-md-10">

             @Html.DropDownListFor(model => model.Text, "Drop");    @*Error Line*@

               @Html.ValidationMessageFor(model => model.Text, "", new { @class = "text-danger" })
            </div>

With model Class DropdownCheck like below:

 public class DropdownCheck
 {
    public string Text { get; set; }
    public String Test { get; set; }
 }

Basically, I don't want to hard-code values to view through list items,but wants to bind it from database through stored procedure.

So, For that I have controller like below

   [HttpGet]
    public ActionResult Dropdown()
    {
        BusDataContext dtnew=new BusDataContext();
        ViewBag.Drop = new SelectList(dtnew.Bind_Dropdown().ToList(), "BusSrlNo", "Name");
        return View();
    }

Also storing dropdown id,text in ViewBag as above. where Bind_Dropdown() is like below

  public IEnumerable<DropdownValues> Bind_Dropdown()
   {
       var res = dt.Get_Bus_Dropdown().ToList();
       List<DropdownValues> drop = new List<DropdownValues>();

       for (var i = 0; i < res.Count; i++)
       {
           DropdownValues name = new DropdownValues();
           name.drpbusid = Convert.ToInt32(res[i].BusSrlNo);
           name.drpbusname = Convert.ToString(res[i].Name);
           drop.Add(name);
       }
       return drop;
   }

where DropdownValues is a class like below:

   public class DropdownValues
{
    public int drpbusid { get; set; }
    public string drpbusname { get; set; }
}

Stored procedure returns dropdown value and Text as BusSrlNo and Name. After doing all these stuff,getting error compilation like below: :

CS1928: 'System.Web.Mvc.HtmlHelper' does not contain a definition for 'DropDownListFor' and the best extension method overload 'System.Web.Mvc.Html.SelectExtensions.DropDownListFor(System.Web.Mvc.HtmlHelper, System.Linq.Expressions.Expression>, System.Collections.Generic.IEnumerable)' has some invalid arguments

Denys Wessels · Accepted Answer · 2016-06-06 04:51:29Z

1

1) Change this line:

ViewBag.Drop = new SelectList(dtnew.Bind_Dropdown().ToList(), "BusSrlNo", "Name");

Into this:

ViewBag.Drop = new SelectList(dtnew.Bind_Dropdown().ToList(), "drpbusid", "drpbusname");

2)Change this line:

@Html.DropDownListFor(model => model.Text, "Drop");

Into this:

@Html.DropDownList("anyName", ViewBag.Drop as SelectList)

I've replicated your error on my side and those are the only two changes I had to make to get it working.I hope it helps you.

answered Jun 6, 2016 at 4:51

Denys Wessels

17.1k16 gold badges85 silver badges121 bronze badges

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

Comments

Kristian Oye · Accepted Answer · 2016-06-05 18:12:40Z

0

I am not familiar with the signature you are trying to use (can .NET bind a value from a string like this?)

@Html.DropDownListFor(model => model.Text, "Drop");    @*Error Line*@

What happens if you switch this to:

@Html.DropDownListFor(m => m.Text,
 ((IEnumerable<SelectListItem>)ViewBag.Drop.Items))

answered Jun 5, 2016 at 18:12

Kristian Oye

1,21215 silver badges28 bronze badges

1 Comment

Abhi Over a year ago

No still I am getting-> Unable to cast object of type 'System.Collections.Generic.List1[MVC_DAL.DropdownValues]' to type 'System.Collections.Generic.IEnumerable1[System.Web.Mvc.SelectListItem]'.

Collectives™ on Stack Overflow

How to bind dropdown values from Database through stored procedure in Strongly typed views in MVC..?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related