0
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.
0
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.