How to add several table columns in one DataGrid Column?

Question

Is there any possibility to diplay several columns of a table in one column of a DataGrid? eg: I heve a table with the below Columns: - IDEmployee - Name - LastName - SecondLastName So in a DataGrid in the first column I want to display the ID and in the second column I want to diplay the complete name (Name LastName n' SecondLastName) is it possible? thanx in advance. Regards.

Carlos Sanchez · Answer

Thank you jshepler. I prefer the first method cuz is esier and cuz I dont know if the second method is possible in C#. thank you again I appreciate your help. Regards.

jshepler · Answer

2 ways to do this: 1. Combine the two (or more) columns in your select statement: SELECT IDEmploee Name + ' ' + LastName + ' ' + SecondLastName AS 'Employee'. You would then have 2 columns: IDEmployee and Employee. 2. Tell the datagrid not to automatically generate the columns - do them manually: Employee The first method is the preferred way unless you need to have the columns seperate for something else. Having the database doing the work is much more efficient not to mention easier to code.