I have a table with two fields for a person's name.(e.g.
FirstName, LastName).

Is there a way to bind both fields with a space between
them to a dropdownlist control so that the full name is
displayed?

Thanks,

Billy Jacobs

Hi Billy, you can add another column to the table, set the values you want
to display in that column, and bind to it.

Etienne

"Billy Jacobs" <(E-Mail Removed)> wrote in message
news:07d701c3570c$a177e880$(E-Mail Removed)...
> I have a table with two fields for a person's name.(e.g.
> FirstName, LastName).
>
> Is there a way to bind both fields with a space between
> them to a dropdownlist control so that the full name is
> displayed?
>
> Thanks,
>
> Billy Jacobs

sql="Select Id, FullName=FirstName + ' ' + LastName from table";

Now you have two columns, Id and FullName, to bind to the DropDownList.

John
http://www.mallsocket.com


"Billy Jacobs" <(E-Mail Removed)> wrote in message
news:07d701c3570c$a177e880$(E-Mail Removed)...
> I have a table with two fields for a person's name.(e.g.
> FirstName, LastName).
>
> Is there a way to bind both fields with a space between
> them to a dropdownlist control so that the full name is
> displayed?
>
> Thanks,
>
> Billy Jacobs