appending columns in a dataset

[Stephen Noronha]

Hi,

is it possible for two columns to be appended from a dataset and bound to a
dropdownlist.
for example: I want to append firstName and lastName like this
ddName = ds.tables(0).Columns("FirstName") & "-" &
ds.tables(0).Columns("LastName")

but it displays an error.

Thanks,
Stephen

 

[ViewState]

When you make the query string you do that
select id,firstname + ' ' + lastname

 

[Trevor Benedict R]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data05312002.asp

HTH

Trevor Benedict R
MCSD

 

[Stephen Noronha]

Thanks,
Stephen

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data05312002.asp

HTH

Trevor Benedict R
MCSD