Q: query for dropdown list

[Guest]

Hello,
I need to create a dropdown list that combines 3 fields form a table and
show it a single item in dropdownlist. So List should have rows like
Filed1-Filed2-Filed3. How can I do this?
Thanks,
Jim.

 

[Alejandro Penate-Diaz]

you do change your SQL query to join both fields and assign an alias, then
set your dropdownlist DataValue property to the alias.

 

[T. DAVIS JR]

Or, you can populate the list manually. However, using sql concantenation is
by far the easiest method

 

[Guest]

Can you give me an example?

you do change your SQL query to join both fields and assign an alias, then
set your dropdownlist DataValue property to the alias.

 

[T. DAVIS JR]

http://sqlzoo.net/howto/source/u.cgi/tip725372/oracle
http://www.codetoad.com/asp_sql_concatenate.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_operator_3qov.asp

Cheers!

 

[Vishnu-Chivukula]

Hi Jim,
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-programming/28368/concat
enating-multiple-results-to-a-string
http://www.umachandar.com/technical/SQL6x70Scripts/main.htm

You can even do it in the front end after getting the values from the query.
Still, SP is the right way to go in terms of performance

Hope this helps...

Happy Coding