How to show the dropdown text value rather than id in mvc

Mark Tabor

6y1.7k.NET

I have a create view in which i have static dropdown list populated with some pre-defined values for the year , Now on listing i want to show the year text like 2012,2014,2019 rather than their values 1,2,3 How to achieve that remember i have static dropdown data is not coming from database below is the code

@Html.DropDownListFor(model=>item.Year_Passed, new List

{

new SelectListItem{ Text="Select Year", Value = "0" },

new SelectListItem{ Text="2000", Value = "1" },

new SelectListItem{ Text="2001", Value = "2" },

new SelectListItem{ Text="2002", Value = "3" },

new SelectListItem{ Text="2003", Value = "4" },

new SelectListItem{ Text="2004", Value = "5" },

new SelectListItem{ Text="2005", Value = "6" },

new SelectListItem{ Text="2006", Value = "7" },

new SelectListItem{ Text="2007", Value = "8" },

new SelectListItem{ Text="2008", Value = "9" },

new SelectListItem{ Text="2009", Value = "10" },

new SelectListItem{ Text="2010", Value = "11" },

new SelectListItem{ Text="2011", Value = "12" },

new SelectListItem{ Text="2012", Value = "13" },

new SelectListItem{ Text="2013", Value = "14" },

new SelectListItem{ Text="2014", Value = "15" },

new SelectListItem{ Text="2015", Value = "16" },

new SelectListItem{ Text="2016", Value = "17" },

new SelectListItem{ Text="2017", Value = "18" },

new SelectListItem{ Text="2018", Value = "19" },

new SelectListItem{ Text="2019", Value = "20" },

}, item.Year_Passed, new { @class = "well well-sm", @id = "Year", @disabled = "disabled" })

item.YEar_passed is coming from Db it is saving year id value not text

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gopaiah Nekarukanti6y ago
Please try with below changes...

View.cshtml

@{
var years = new List()
{
new SelectListItem{ Text="Select Year", Value = "0" },
new SelectListItem{ Text="2000", Value = "1" },
new SelectListItem{ Text="2001", Value = "2" },
new SelectListItem{ Text="2002", Value = "3" },
new SelectListItem{ Text="2003", Value = "4" },
new SelectListItem{ Text="2004", Value = "5" },
new SelectListItem{ Text="2005", Value = "6" },
new SelectListItem{ Text="2006", Value = "7" },
new SelectListItem{ Text="2007", Value = "8" },
new SelectListItem{ Text="2008", Value = "9" },
new SelectListItem{ Text="2009", Value = "10" },
new SelectListItem{ Text="2010", Value = "11" },
new SelectListItem{ Text="2011", Value = "12" },
new SelectListItem{ Text="2012", Value = "13" },
new SelectListItem{ Text="2013", Value = "14" },
new SelectListItem{ Text="2014", Value = "15" },
new SelectListItem{ Text="2015", Value = "16" },
new SelectListItem{ Text="2016", Value = "17" },
new SelectListItem{ Text="2017", Value = "18" },
new SelectListItem{ Text="2018", Value = "19" },
new SelectListItem{ Text="2019", Value = "20" },
};
}
@model MVCWebApplication.Models.YearModel
@Html.DropDownListFor(model => Model.Year_Passed, new SelectList(years, "Value", "Text", Model.Year_Passed), new { @class = "well well-sm", @id = "Year" })

Model

public class YearModel
{
public int Year_Passed { get; set; }
}

Contoller

public ActionResult About()
{
var model = new YearModel
{
Year_Passed = 19 //Usually this is for edit mode, for add new case this assignment is not required default label will be displayed
};
return View(model);
}

Output
Mark Tabor6y ago
Ashutosh Gupta Thansk for the response , But is there any way to do it from Razor rather than from viewmodel to bind it using viewbag or something , My dropdown is populated successfully , but on index view it is taking the year id from the db i want to show the text
Ashutosh Gupta6y ago
you could create view Model with text and year property and that can be bind with DropDownListFor

e.g. create list of yearpassed from your DB and map it.
public class yearPassed

{

public string year {get;set;}

public int id {get; set;}

}
public IEnumerable Items
{
get
{
var items = new SelectList{ new SelectListItem{ Text="2000", Value = "1" },
new SelectListItem{ Text="2001", Value = "2" },
new SelectListItem{ Text="2002", Value = "3" },
new SelectListItem{ Text="2003", Value = "4" },
new SelectListItem{ Text="2004", Value = "5" },
new SelectListItem{ Text="2005", Value = "6" },
new SelectListItem{ Text="2006", Value = "7" },
new SelectListItem{ Text="2007", Value = "8" }
}
return items;
}
}
@model Yearpassed
@Html.DropDownListFor(m => m.Year, Items, "Select Year")

I hope this will help.