More than one field in one column (boundcolumn, etc.) 1

[lonechicken]

Is there an easy way using datagrid or something similar to display more than one field for a certain column?

Say in a database, there are separate firstname and lastname fields. But when I want to display it, I want them in one column listed as lastname, firstname (instead of separate columns).

Like:
Name
----
Doe, John

Instead of having to do:
Lastname Firstname
-------- ---------
Doe John

Am I just going to have to bite the bullet and come up with a more complicated SQL statement to "ready the data" for the datagrid?

 

[JuanitaC]

It is easy to combine two columns into one in a SQL statement:

SELECT LastName + ', ' + FirstName as [FullName]
FROM table
ORDER BY FullName

Then use the column alias FullName in your datagrid or table in your code.

 

[lonechicken]

Thanks,
I figured as much and was hoping datagrid was more flexible.

The Lastname, Firstname thing is actually a simplistic example of what I'm trying to do, but at least I know which way I'd have to go.