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

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:
>[url]www.aboutfortunate.com[/url]
>
>"Out of chaos comes order."
> Nietzche
>"ctb" <clark@speakeasyinteractive.com> wrote in message
>news:089e01c34d42$b57463f0$a001280a@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:
[url]www.aboutfortunate.com[/url]

"Out of chaos comes order."
Nietzche
"ctb" <clark@speakeasyinteractive.com> wrote in message
news:090201c34d47$c0ef7080$a001280a@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:
> >[url]www.aboutfortunate.com[/url]
> >
> >"Out of chaos comes order."
> > Nietzche
> >"ctb" <clark@speakeasyinteractive.com> wrote in message
> >news:089e01c34d42$b57463f0$a001280a@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

> >
> >
> >.
> >