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

"Stephen Noronha" <st********@hotmail.com> escreveu na mensagem
news:eV**************@TK2MSFTNGP09.phx.gbl...

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

[Trevor Benedict R]

http://msdn.microsoft.com/library/de...ta05312002.asp

HTH

Trevor Benedict R
MCSD

"Stephen Noronha" <st********@hotmail.com> wrote in message
news:eV**************@TK2MSFTNGP09.phx.gbl...

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

[Stephen Noronha]

Thanks,
Stephen

"Trevor Benedict R" <tr********@yahoo.com> wrote in message
news:uF**************@TK2MSFTNGP09.phx.gbl...

http://msdn.microsoft.com/library/de...ta05312002.asp
HTH

Trevor Benedict R
MCSD

"Stephen Noronha" <st********@hotmail.com> wrote in message
news:eV**************@TK2MSFTNGP09.phx.gbl...

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