Multiple values in DisplayMember of DatagridViewComboBoxColumn

Question

I have DatagridViewComboBoxColumn bound to a datasource, i want to show "First Name" + "Last Name" in list and display member. How do i do that?

I have created another table adapter with concatenation query — SMUsamaShah, Feb 05 '11 at 10:22

score 4 · Accepted Answer · answered Mar 09 '11 at 15:56

4

Add a property to the datasource that exposes "Name". Have the "Name" property return the "FirstName" + "LastName".

Bind to that property instead.

If the datasource is SQL, use SELECT FirstName + LastName AS 'Name' FROM table

answered Mar 09 '11 at 15:56

Marc Johnston

1 Answers1