Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to bind dropdown with Database?

Jayden Bell 1941 18 May 2017

I am having problem in binding data in dropdown with Database. Please help me.

Ask by Jayden Bell

Updated 18 May 2017

1 Answers

Manish Kumar 18 May 2017

In the controller

   public ActionResult Index()
        {
            //get data from data base 
            ViewBag.Users =Uow.EmpDetail.SelectAll();       
            
            return View();
        }

In the view

<fieldset>
                              
                <legend><strong>Student Info:</strong></legend>
                @Html.HiddenFor(x=> x.Id)
                Name: @Html.TextAreaFor(x=> x.SName, new { maxlength = "10", style = "width:200px;text-align:center" })<br>
                Class: @Html.TextBoxFor(x=> x.Class)<br>
                Address:@Html.TextBoxFor(x=> x.Address)<br />
                Employee :@Html.DropDownListFor(x=> x.Id,
               new SelectList(ViewBag.ListItem, "Value", "Text"))
                <input type="submit" value="Submit" />
 
            </fieldset>

Hope this helps you..

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.