How to bind Database values to the DropDownList in C#

Question

I have a sql server table ProjectDetails. The table has following columns ID(PK), ProjectID, Project. I need the values of ProjectID & Project to be populated into the 2 different dropdown list.

Model:

public class ViewModel
    {
        public int ID { get; set; }
        public string Project { get; set; }
        public string ProjectID { get; set; }

    }

Controller:

 [ActionName("DetailsForm")]
    [HttpGet]
    public ActionResult DetailsForm()
    {
        try
        {
            IEnumerable<ViewModel> dropConfig = new List<ViewModel>();

            IEnumerable<ViewModel> selectList = floorService.DropDownList();

            ViewModel model = new ViewModel()
         {

             dropConfig = selectList,


         };

            return View("DetailsForm",model);

        }

I have difficulties in figuring out what should go under repository code where I need to execute the stored proc GetProjectDetails which will give me the data from Table ProjectDetails Please help me with some examples where I can learn to go ahead with my solution. Thanks in advance.

The code you have posted makes no sense. Your ViewModel class does not have a property named dropConfig but in your controller you have that code. Your code will not compile. Please post code which will compile and tell us which specific part you are having issues with. — CodingYoshi
– CodingYoshi, Commented Nov 14, 2017 at 4:23

TanvirArjel · Accepted Answer · 2017-11-14 05:02:03Z

2

In ASP.NET MVC, Dropdownlist is generated with SelectList Helper Class, So You need to use Select List Item and You can send the value with ViewBag

ViewBag.SelectList= new SelectList(_classObject.YourClassMethod(), "DropDownListValue", "DropDownListText");

In Razor View You Can Directly add it with Razor HTML Helper

@Html.DropDownList("SelectList", ViewBag.SelectList as SelectList,"Select Item", new {@class = "form-control" })

Other Hand If You Want to Use Strongly Typed

@Html.DropDownListFor(model => model.SelectList, ViewBag.SelectListas SelectList, "Select Item", new { @class = "form-control" })

edited Nov 14, 2017 at 5:02

TanvirArjel

32.5k14 gold badges89 silver badges120 bronze badges

answered Nov 14, 2017 at 4:26

Ashiqur Rahman Emran

2072 silver badges12 bronze badges

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

2 Comments

shrey Pav Over a year ago

My question is how to get the values from database. There should be executereader or something right? I have a stored proc which has select statement.

Ashiqur Rahman Emran Over a year ago

You can use Entity Framework , Drapper or ADO.NET fetch these data

Collectives™ on Stack Overflow

How to bind Database values to the DropDownList in C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related