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 · Accepted 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" ));           }