Dropdownlist selected value not saved into database

Sign in to answer this question.

• 

  Bhuvanesh Mohankumar9y agoPosted Apr 14, 2017, 11:07 AM

  I belive the values are not assign to the drop down list, so the item selected is not assigned to model, which makes data to stop inserting into database.

   

  This code may help you,

   

  Create a ViewModel that will hold everything you want to be rendered at the view.

  1. public class MyViewModel{  
  2.   
  3.   public List CountryList {get; set}  
  4.   public string Country {get; set}  
  5.   
  6.   public MyViewModel(){  
  7.       CountryList = new List();  
  8.       Country = "USA"; //default values go here  
  9. }  

  Fill it with the data you need

  1. public ActionResult New()  
  2. {  
  3.     var countryQuery = (from c in db.Customers  
  4.                         orderby c.Country ascending  
  5.                         select c.Country).Distinct();  
  6.     MyViewModel myViewModel = new MyViewModel ();  
  7.   
  8.     foreach(var item in countryQuery)  
  9.     {  
  10.         myViewModel.CountryList.Add(new SelectListItem() {  
  11.                         Text = item,   
  12.                         Value = item  
  13.                         });  
  14.     }  
  15.     myViewModel.Country = "UK";  
  16.   
  17.   
  18.   
  19.     //Pass it to the view using the `ActionResult`  
  20.     return ActionResult( myViewModel);  
  21. }  

  At the view, declare that this view is expecting a Model with type MyViewModel using the following line at the top of the file

   

  1. @model namespace.MyViewModel   

  And at anytime you may use the Model as you please

  1. @Html.DropDownList("Country", Model.CountryList, Model.Country)  

   Mark as answer, if helpful
• 

  Bhuvanesh Mohankumar9y agoPosted Apr 14, 2017, 9:46 AM

  It would be great, if you can copy the code to Notepad and from notepad copy and paste in the question sesion, it is very difficult to view and understand the code.