Passing value to select list in ASP.net

Question

I am trying to pass a concatenated columns from a LINQ statement to a select list using view bag.

Controller:

var translators = bidsinfo1.Select(x => new { Name = x.TranslatorFirstName + " " + x.TranslatorLastName} ).ToList();
ViewBag.TranslatorList = translators;

View:

<div class="form-group">
   <select class="form-control" asp-items="new SelectList(ViewBag.TranslatorList)">
                    <option>Select Translator</option>
   </select>
</div>

But in the select list when i run the project it's showing the values like this { Name = harvey specter }, please any suggestion?

https://stackoverflow.com/a/16595386/125981 should help you here perhaps — Mark Schultheiss, Nov 21 '22 at 19:51

score 0 · Answer 1 · answered Nov 21 '22 at 21:57

0

u should convert List(of oBject) to a List(of String) and pass it to viewBag so change your linqQuery to

var translators = bidsinfo1.Select(x =>  x.TranslatorFirstName + " " + x.TranslatorLastName ).ToList();

GoodLuck.

answered Nov 21 '22 at 21:57

sep7696

494
2
16

score 0 · Answer 2 · answered Nov 21 '22 at 22:04

i tried this and it's work now..

var translators = bidsinfo1.Select(x => new { Id = x.Id, Name = x.TranslatorFirstName + " " + x.TranslatorLastName });
ViewBag.TranslatorList = new SelectList(translators, "Id", "Name");
<div class="form-group">
    <select class="form-control" asp-items="ViewBag.TranslatorList">
        <option>Select Translator</option>
    </select>
</div>

Passing value to select list in ASP.net

2 Answers2