multiple fields in datagrid column 1

[mattbold]

hello,

just a quick question
how do i go about putting two fields in one column in a datagrid? for example i would like to have a column called name, and in there there will be both the first and last names of a person..?

at the moment the datagrid is getting its data using a datareader..

cheers,
matt

 

[rk1962]

Try this:
select (FirstName + ' ' + LastName) as 'Name' from tblEmployees

Use 'Name' in Datagrid binding.

 

[mattbold]

good thinking my man!

i had totally forgotten about doing stuff in the SQL beforehand!

- matt