dropdownlist-concat two fields-can it be done

[ctb]

I am not sure how to, or even if you can do this. I have
tried several things.
I have a drop down list that is databound to a
datareader. I wish to set the DataTextField to a
concatentation of first and last name that are stored in
the database.

any idea if there is a way to do this?
Thanks

[ctb]

I will try this, especially the first option
but, one more question
I also bind the datafieldvalue to the Member_id in the
drop down list.
In my select statement can I select another field
(member_id) in addition to the concatenated fields in the
AS clause.

-----Original Message-----
There are two approaches to this:

1) Concatenate the fields in your select statement from the database "SELECT(lastName + ', ' + firstName) AS fullName From tblNames

2) You could concatenate the fields in the drop down's OnItemDataBoundevent.

The first way is probably the more efficient one.

I hope this helps.

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
"ctb" <cl***@speakeasyinteractive.com> wrote in message
news:08****************************@phx.gbl...

I am not sure how to, or even if you can do this. I have tried several things.
I have a drop down list that is databound to a
datareader. I wish to set the DataTextField to a
concatentation of first and last name that are stored in
the database.

any idea if there is a way to do this?
Thanks

.

[S. Justin Gengo]

Yes, you can select as many fields as you want!

SELECT Member_id, (lastName + ', ' + firstName) AS fullName From tblNames


--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
"ctb" <cl***@speakeasyinteractive.com> wrote in message
news:09****************************@phx.gbl...

I will try this, especially the first option
but, one more question
I also bind the datafieldvalue to the Member_id in the
drop down list.
In my select statement can I select another field
(member_id) in addition to the concatenated fields in the
AS clause.

-----Original Message-----
There are two approaches to this:

1) Concatenate the fields in your select statement from

the database "SELECT

(lastName + ', ' + firstName) AS fullName From tblNames

2) You could concatenate the fields in the drop down's

OnItemDataBound

event.

The first way is probably the more efficient one.

I hope this helps.

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
"ctb" <cl***@speakeasyinteractive.com> wrote in message
news:08****************************@phx.gbl...

I am not sure how to, or even if you can do this. I have tried several things.
I have a drop down list that is databound to a
datareader. I wish to set the DataTextField to a
concatentation of first and last name that are stored in
the database.

any idea if there is a way to do this?
Thanks

.