Databinding to dropdownlist

[Billy Jacobs]

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

[John]

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" <bi********@csa.com> wrote in message
news:07****************************@phx.gbl...

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

[Etienne Charland]

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" <bi********@csa.com> wrote in message
news:07****************************@phx.gbl...

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