How to bind value from database to Dropdown List in MVC 4

Question

This is My Model

public class InsertOrder
{
    public int CustomerId { get; set; }
    public string CustomerName { get; set; }     
}

public List<InsertOrder> getcustomerid()
{
    List<InsertOrder> customerlist = new List<InsertOrder>();
    SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString);
    SqlDataReader Datareader;
    {
        using (SqlCommand command = new SqlCommand("SELECT CustomerID,FirstName FROM customers", connection))
        {
            connection.Open();
            Datareader = command.ExecuteReader();
            while (Datareader.Read())
            {
                InsertOrder ID = new InsertOrder();
                ID.CustomerId = Convert.ToInt32(Datareader["CustomerID"]);
                ID.CustomerName = Datareader["FirstName"].ToString();

                customerlist.Add(ID);
            }
            Datareader.Close();
            return customerlist;
        }
    }
}

How to give in the view page

Whats the model that contains the property you want to bind the selected InsertOrder to? — user3559349
– user3559349, Commented Nov 13, 2014 at 11:47
@jabi, Your not understanding. You need a model with a property to bind the selected InsertOrder to. In Moksh's answer below, it assumes you have a model with a property int SampleDropDownValue so the CustomerID value of the selected InsertOrder is bound to the value of SampleDropDownValue — user3559349
– user3559349, Commented Nov 13, 2014 at 22:29

Mox Shah · Accepted Answer · 2014-11-13 11:30:27Z

0

            public ActionResult Index()
            {
                var customerList = new InsertOrder().getcustomerid();

                ViewBag.CustomerList = new SelectList(customerList, "CustomerId",CustomerName") ;
                return View(YourModel);
            }

At View

@Html.DropDownListFor(m => m.SampleDropDownValue, Model.CustomerList , "--Select--")

edited Nov 13, 2014 at 11:30

answered Nov 13, 2014 at 11:12

Mox Shah

3,0153 gold badges29 silver badges44 bronze badges

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

1 Comment

adiga Over a year ago

You can avoid the for loop: ViewBag.CustomerList = new SelectList(customerList, "CustomerId", "CustomerName")

Collectives™ on Stack Overflow

How to bind value from database to Dropdown List in MVC 4

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related