Is it possible to add two CheckedListBox.DisplayMember?

Question

I want to display two columns from my List

My code:

BindingSource DatenNameVorfahr = new BindingSource();
BindingSource DatenNameNachfolg = new BindingSource();
DataClasses1DataContext d = new DataClasses1DataContext();

////

var query = from pers in d.Person select pers;

List<Person> personen = query.ToList();

DatenNameVorfahr.DataSource = query;
DatenNameNachfolg.DataSource = query;

clNachfolg.DataSource = DatenNameVorfahr;
clVorfahr.DataSource = DatenNameNachfolg;

clNachfolg.DisplayMember = "Name" + "Nachname"; <----! (doesnt work) 
clNachfolg.ValueMember = "ID";

When I do this my CheckedListBox only displayes the "ID" (its the first column in my database / list)

Answer 1

One solution would simply be to use a bit of LINQ to get a new List with the Name and Nachname concatenated and bind to that instead. Something like:

var query2 = from q in query
                select new
                {
                    FullName = q.Name + " " + q.Nachname,
                    Id = q.Id
                };
DatenNameNachfolg.DataSource = query2;
clNachfolg.DataSource = DatenNameNachfolg;
clNachfolg.DisplayMember = "FullName";
clNachfolg.ValueMember = "Id";

HTH