Dropdownlist selected value not saved into database

Question

HI.I`m new to this . Im using Northwind database . You may see the attached files as well. The REGION DESCRIPTIONS appears in the dropdownlist  but when i try to create a new customer  no new record is saved into database  because dropdownlist selected value isnt working. Any help ?! Thank you so.

Bhuvanesh Mohankumar · Answer

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. public class MyViewModel{ public List CountryList { get ; set } public string Country { get ; set } public MyViewModel(){ CountryList = new List (); Country = USA ; //default values go here } Fill it with the data you need public ActionResult New() { var countryQuery = (from c in db.Customers orderby c.Country ascending select c.Country).Distinct(); MyViewModel myViewModel = new MyViewModel (); foreach (var item in countryQuery) { myViewModel.CountryList.Add( new SelectListItem() { Text = item Value = item }); } myViewModel.Country = UK ; //Pass it to the view using the `ActionResult` return ActionResult( myViewModel); } At the view declare that this view is expecting a Model with type MyViewModel using the following line at the top of the file @model namespace .MyViewModel And at anytime you may use the Model as you please @Html.DropDownList( Country  Model.CountryList Model.Country) Mark as answer if helpful

Bhuvanesh Mohankumar · Answer

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.