Can i select two attributes and display them as one column in the gridview using sql statement?

Previously, i tried this ';SELECT (u.LastName + ' ' + u.FirstName + ' ') From User '; and its work....i managed to display both LastName and FirstName side by side in the dropdownlist.





but i wonder how come it doesn't work for gridview?


or isit it really cant display that way when using gridview?


any help?Can i select two attributes and display them as one column in the gridview using sql statement?
Try to give name to column:





SELECT (u.LastName + ' ' + u.FirstName + ' ') AS uName From User u