ASP.NET MVC 4 Want to populate dropdown list from database

Question

I am new guy in ASP.NET MVC 4. I want to populate dropdownlist from database table BO where Column name is Id, Code, Name, OrgId. I want to bind two Code & Namecolumn's data to DataTextfield and Id column Data to DataValueField of dropdown. I have created code for this which are as follows BUT ITS NOT RETURNING DATA FROM TABLE and var BOList is remain empty :

my connectionstring is 


 <add name="iRegDBContext"
  connectionString="Data Source=****;Initial Catalog=iReg;User ID=**;Password=****;Integrated Security=True"
  providerName="System.Data.SqlClient"
/>

My Controller class :

public class iRegController : Controller
{
    private iRegDBContext l_oDbBO = new iRegDBContext();  

    // GET: /iReg/

    public ActionResult PopulatejQgrid()
    {
        var BOList = l_oDbBO
                     .BO
                     .ToList()
                     .Select(d => new SelectListItem
                         {
                             Value = d.Id.ToString(),
                             Text = d.Name + "[ " + d.Code + " ]"
                         });
        ViewBag.BOData = new SelectList(BOList, "Value", "Text"); 
        return View();
    }
}

My Model class :

public class BO
{
    public Guid Id { get; set; }
    public string Code { get; set; }
    public string Name { get; set; }
}

public class iRegDBContext : DbContext
{
    public DbSet<BO> BO { get; set; }
}

My cshtml class :

@model MvciReg.Models.BO

@{
    ViewBag.Title = "PopulatejQgrid";
}

@using (Html.BeginForm())
{
    <fieldset>
        BO : 

        @Html.DropDownList("BOData")
        <p>
            <input type="submit" value="Go" />
        </p>
    </fieldset>
}

I really don't know where I am going wrong. I developed my code from reference of following link Click here . Kindly suggest correction in code ...

UPDATE: I tried following Matt Bodily's code in my controller and what I see is code is not fetching data from database and that code is

    public ActionResult populatejQgrid()
    {
        ViewBag.BOData = GetDropDown();

        return View();
    }

    public static List<SelectListItem> GetDropDown()
    {
        List<SelectListItem> ls = new List<SelectListItem>();
        var lm = from m in db.BOs //fetch data from database
                 select m;
        foreach (var temp in lm)
        {
            ls.Add(new SelectListItem() { Text = temp.Name, Value = temp.Id.ToString() });
        }
        return ls;
    }

In Controller :

      @Html.DropDownList("BOData", (List<SelectListItem>)ViewBag.BOData)

But when I saw value of ls through watch it always show me Count = 0 but its not giving me any error.

I found something new this problem. When I kept mouse pointer over var lm; it shows me query and in query table name in FROM clause is not that one in my SQL database. My SQL table name is BO and in query it is taking BOes. I don't know from where this name is coming. I think this is the main cause of all this problem So How I overcome this??

@Html.DropDownList("BOData"): it just defined a drop down controll with the name. try using @Html.DropDownListFor(m=>m.Id, new SelectList(ViewBag.BOData,"Value", "Text")) in the view — Miller
– Miller, Commented Oct 12, 2013 at 11:09
Is there any rule that you have to give TableName to class name or DbContext class name???? — Rahul More
– Rahul More, Commented Oct 12, 2013 at 11:12
My Controller's variable var BOList is remain empty. So How do I get data into this variable?? — Rahul More
– Rahul More, Commented Oct 12, 2013 at 11:15
Before trying on drop down start on text box and label. You need to fetch the table content in the class. — Miller
– Miller, Commented Oct 12, 2013 at 11:17

Bhupendra Shukla · Accepted Answer · 2013-10-14 06:52:17Z

3

First Create a BO list for Dropdownlist in VIEW

@{
    var Bolst= Model.BO.Select(cl => new SelectListItem
       {
           Value = cl.Value.ToString(),
           Text = cl.Text== null ? String.Empty : cl.Text
       });
}

@(Html.DropDownList("sampleDropdown", BOlst, "-----Select-----"))

In Controller:

    return View(BOlst); // why use Viewbag when directly pass it to view

answered Oct 14, 2013 at 6:52

Bhupendra Shukla

3,9146 gold badges43 silver badges62 bronze badges

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

Comments

hjgraca · Accepted Answer · 2013-10-12 14:57:18Z

0

from what I see in your code you are creating the select list and setting the ViewBag.BOData on the controller. So in order to render it on the view you should do this

@Html.DropDownList(ViewBag.BOData)

instead of

@Html.DropDownList("BOData")

Regarding the access to the database are you trying to use "code first" in an existing database? If you are you need to override the context constructor like this

public class iRegDBContext : DbContext
{
  public iRegDBContext()
     :base("Name= iRegDBContext")
   {
   }
}

see this link http://msdn.microsoft.com/en-us/data/jj200620.aspx

Hope it helps.

edited Oct 12, 2013 at 14:57

answered Oct 12, 2013 at 14:27

hjgraca

1,7131 gold badge14 silver badges29 bronze badges

2 Comments

Rahul More Over a year ago

Please can you tell me, Why did you use public iRegDBContext() :base("Name= iRegDBContext") What's the meaning and use of this???

hjgraca Over a year ago

When you are using "Code First" trying to connect to an existing Database you need to tell entity framework to use that database otherwise it will create a database called iRegDBContext + hash. you can see it all in the link I posted in the answer.

Matt Bodily · Accepted Answer · 2013-10-12 15:25:46Z

0

try building your dropdown this way

@Html.DropDownList(x => x.Selected, PathToController.GetDropDown())

and then in your controller

public static List<SelectListItem> GetDropDown()
{
    List<SelectListItem> ls = new List<SelectListItem>();
    lm = (call database);
    foreach (var temp in lm)
    {
        ls.Add(new SelectListItem() { Text = temp.name, Value = temp.id });
    }
    return ls;
}

Hopefully this helps

answered Oct 12, 2013 at 15:25

Matt Bodily

6,4134 gold badges32 silver badges51 bronze badges

2 Comments

Rahul More Over a year ago

:Thanx to take interest my question and for your suggestion. But VS showing me red underline to PathToController. What should i do for this??

Matt Bodily Over a year ago

type in your controller name and type ctrl-. this will bring in the full path to your controller (project, area, etc)

Community · Accepted Answer · 2017-05-23 12:24:47Z

0

I recently had this issue also and managed to get it working using Viewbag. You will need to make it fit your Db tables but it works and is quite simple.

Populating Drop Down Box with Db Data

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Jul 11, 2014 at 10:30

ricky89

1,4067 gold badges27 silver badges37 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC 4 Want to populate dropdown list from database

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related