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
Solved

Fill a DropDownList with two columns from an SQL Database

Posted on 2011-02-15
4
592 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
  • 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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
how to wrap a merged cells of datagridview column in vs2010 (vb.net) 8 44
get row value in vb.net 4 17
VB.Net Tranfer data between to VB.Net apps 8 40
location of a form 2 25
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 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