How to combine columns for DatatextFiled of DropdownList?

Question

I have Dropdown list of Faculty Name. In my database they are stored as FirstName, LastName, MiddleName,

I want to combine it in dropdownlist

ViewData["FacultyID"] = new SelectList(faculty, "ID", "FirstName");

at place of datatextfield.

Answer 1

You could change your sql query:

SELECT ..., COALESCE(FirstName + ' ' + MiddleName + ' ' + LastName) as FullName,...

Answer 2

ViewData["FacultyID"] = 
   new SelectList(faculty.Select(f=> new 
   {id= f.Id, Name = f.Firstname + f.LastName}), "ID", "Name");