title: How to bind value from database to Dropdown List in MVC 4
body: <p>This is My Model   </p>
  
  <pre><code>public class InsertOrder
  {
      public int CustomerId { get; set; }
      public string CustomerName { get; set; }     
  }
  
  public List&lt;InsertOrder&gt; getcustomerid()
  {
      List&lt;InsertOrder&gt; customerlist = new List&lt;InsertOrder&gt;();
      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;
          }
      }
  }
  </code></pre>
  
  <p>How to give in the view page</p>