getting selected Id instead of Name from dropdown

vishnu sharma

8y601.NET

public partial class EntryTable

{

public int Id { get; set; }

public string Name { get; set; }

public DateTime Date { get; set; }

public long Mobile { get; set; }

public string Email { get; set; }

[Display(Name="City")]

public int CityId { get; set; }

public IEnumerable City { get; set; }

[Display(Name="Category")]

public int CategoryId { get; set; }

public IEnumerable Category { get; set; }

public string Gender { get; set; }

public string Address { get; set; }

}

//controller

public ActionResult Index()

{

return View(db.EntryTables.ToList());

}

//View

@Html.DisplayNameFor(model => model.Email)

@Html.DisplayNameFor(model => model.CityId)

@Html.DisplayNameFor(model => model.CategoryId)

here i created two dropdowns, one for City and another for Category. My table is showing only Id of selected dropdown istead of Name.

how can i show the name from selected dropdown in the index view table.

4 Replies

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

vishnu sharma8y ago
can you help me please?
i didn't understand it! although it was a nice answer.
Jenith Thakkar8y ago
you have to pass that entryTable class directly to view
and using loop you can show that record like this
https://www.c-sharpcorner.com/UploadFile/f82e9a/data-displaying-in-table-format-in-diffrent-ways-in-mvc/
vishnu sharma8y ago
and what i have to pass in view?
Jenith Thakkar8y ago
It depends on what you enetered on Entry table in sql so If you have City ID and City Name Both are available in Same Sql Table then you can easily fetch that City name from that table

if you use foreign key constrint between city table and entry table then first you need to join and get name from That City Table

Another way is Following

Var EntryTableList= db.EntryTables.ToList();
List objEntryTablelist= new List();
objEntryTablelist.City=new List();
foreach(var EntryTableData in EntryTableList)
{
var CItyName=db.City.where(o=>o.CityId==EntryTableData).firstordefault();
objEntryTablelist.City.add(CItyName);
}
return View(objEntryTablelist);