How to add several table columns in one DataGrid Column?

Carlos Sanchez

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos Sanchez22y ago
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.
jshepler22y ago
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 <%# DataBinder.Eval(Container.Dataitem, "Name") %> <%# DataBinder.Eval(Container.Dataitem, "LastName") %> <%# DataBinder.Eval(Container.Dataitem, "SecondLastName") %> 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.