IE Webcontrol Dropdownlist

[freddie]

I am trying to populate a dropdownlist with data from two
fields with cod like the following:

"select OrderNo + ' - ' +OrderName as OrderName from
Orders "

This works fine as long as OrderNo and OrderName are both
Varchar, but OrderNo must now be of type Integer.

How do I still get both into one dropdownlist?

 

[Teemu Keiski]

Hi,

convert the OrderNo to (n)varchar in the query. Then you could concatenate
it with other (n)varchar value.