Solved

Fill a DropDownList with two columns from an SQL Database

Posted on 2011-02-15
4
593 Views
Last Modified: 2012-05-11
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
Comment
Question by:CHKillswitch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
hes earned 250 total points
ID: 34900337
In the SQL Select [First Name] + " " + [Last Name] as FullName
0
 
LVL 83

Assisted Solution

by:CodeCruiser
CodeCruiser earned 250 total points
ID: 34906341
In case you dont want to change your SQL, this would help

http://forums.asp.net/t/1298196.aspx
0
 
LVL 20

Expert Comment

by:hes
ID: 35027669
Both methods work to do what the question asked
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
.NET 2008 VB and C# 6 48
VB.Net. Reading xml value 6 38
VB.net DataGridView show bit field as Text column not CheckBox column 5 30
Name Space error VS2015 1 37
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question