• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

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?
0
CHKillswitch
Asked:
CHKillswitch
  • 2
2 Solutions
 
hesCommented:
In the SQL Select [First Name] + " " + [Last Name] as FullName
0
 
CodeCruiserCommented:
In case you dont want to change your SQL, this would help

http://forums.asp.net/t/1298196.aspx
0
 
hesCommented:
Both methods work to do what the question asked
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now