Link to home
Start Free TrialLog in
Avatar of CHKillswitch
CHKillswitch

asked on

Fill a DropDownList with two columns from an SQL Database

I have a Table in which two of the columns are "First Name" and "Last Name".

On the same page I have a Drop Down List which you can select a person from the database, but I want the two fields, "First Name" and "Last Name" to be concatenated together into just "Full Name" that shows in the Drop Down List.

Is there anyway to do this?
ASKER CERTIFIED SOLUTION
Avatar of hes
hes
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Both methods work to do what the question asked