Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design consideration : DropDownList vs Popup window
Message
From
22/08/2002 09:44:06
 
 
To
22/08/2002 06:15:58
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00692359
Message ID:
00692421
Views:
16
This doesn't solve your problem, but one thing you can do to display multiple columns in your dropdownlist is to combine them in a sql statement. For example, you have a table called employee with the fields eID, strFirstName, and strLastName. You want to display the whole name, so in the sql statement say:

SELECT eID, (LTRIM(RTRIM(strFirstName)) + ' ' + LTRIM(RTRIM(strLastName))) AS WholeName FROM employee

Now just use WholeName as the display in the combo. It would be a pain to combine 5 of 6 columns, but it is better than nothing.
Randy Belcher
AFG Industries, Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform