Click to See Complete Forum and Search --> : Combo Box


deepak_r_patel
March 22nd, 2001, 02:36 AM
How do I put two database field values in a single combo box? If it is not possible then what is the alternative to do the same?

vin
March 22nd, 2001, 02:59 AM
I suppose you talk about databound combobox

It is possible by concatenating the two fields
when you specify your sql query

In SQL server this works:

For example:

SELECT FirstField + SecondField AS Both
FROM MyTable

Have fun.

Valery Iskarov Nikolov
http://listen.to/quark

deepak_r_patel
March 22nd, 2001, 05:20 AM
Thanks Valery Iskarov Nikolov for ur help.