alternate view for a drop down list

[RALF]

I have a drop down list that I have populated with values such as
customer names. This is what shows up in the textbox part of the drop
down list. When I hit the arrow for the drop down, I want each row
that drops down to have additional info appended to the customer name.
Something like,

John Doe MS Corporation
Sally Doe ORCL Corporation
Bill Doe NT Corporation

Is this possible??

When the list is pulled down, I would like the text value shown for
each item along with their place of business, which is a field in the
same datasource

 

[Mike Robbins]

Hi, Ralf.

Can you modify the output of your datasource to concatenate the name and
company columns? Something like:

SELECT CustomerID, FirstName + ' ' + LastName + ' ' + Company AS ListText
FROM Customers

Then:

ddlCustomers.DataTextField = "ListText";
ddlCustomers.DataValueField = "CustomerID";

If you can't modify the SQL for some reason, then you can loop through the
DataReader and concatenate the colums there before adding them to the drop
down list's items collection.

HTH,

Mike