asp.net core selectlist to show multiple text values

Question

I have a table with 3 entries in addition to the Id. I want a select list to show all entries in a row, for better identification of the data. Right now select only show me either the value (Id) or one text(one field) from table ex. "Location" class = "form-control border-warning" asp-items= "Model.Locations" > "" >--Select Asset Location-- In the table I have the following fields Id, Location, City, Country Locations = await _context.WOAssetLocations.Where(s => s.OrgID == orgid) .Select(s => new SelectListItem { Value = s.WOALId.ToString(), Text = s.AssetLocation }).ToListAsync(); get me only one field, depending on my choice, either Location, City or Country. This is good but the select I want to show in a row all values coresponding to Id

Sachin Singh · Answer

it is not about json , it is about SelectList public async Task OnGetAssetAsync( string id) { Locations = await _context.WOAssetLocations.Where(s => s.OrgID == orgid) .Select(s => new SelectListItem { Value = s.WOALId.ToString(), Text = s.AssetLocation + "" +s.City+ "" + s.Country }).ToListAsync(); return new JsonResult(Locations); }

Sachin Singh · Answer

for text , just assign them all what's big deal?? Locations = await _context.WOAssetLocations.Where(s => s.OrgID == orgid) .Select(s => new SelectListItem { Value = s.WOALId.ToString(), Text = s.AssetLocation + "" +s.City+ "" + s.Country }).ToListAsync(); but in UI you will really need a select of huge width.

Marius Vasile · Answer

Thank you again, you are a genius Sachin

Marius Vasile · Answer

Ok, no big deal :). But how do I do that in json public async Task OnGetAssetAsync( string id) { var asset = await (from a in _context.WOAssetAssets where a.WOALId == id select a).ToListAsync(); return new JsonResult( new SelectList(asset, "WOAId" , "AssetID" , "AssetName" , "AssetManufacturer" )); }