dropdownlist: 2 columns in the DataTextField

[nicholas]

I would like to view 2 columns of my datatable in my dropdownlist.

Now I have:

mydropdown.datasource = myDataTable.defaultview
mydropdown.DataValueField = "optionID"
mydropdown.DataTextField = "optionnameFR"

so I just see the "optionnameFR" in the dropdownlist.

and I would like to have this:

mydropdown.datasource = myDataTable.defaultview
mydropdown.DataValueField = "optionID"
mydropdown.DataTextField = "optionnameFR" &
"optionprice"

So I would see for example: "gift wrap +2euro" in the dropdowntextfield.

So it does not have to be 2 columns, but the data of 2 columns should be on
1 line

THX for help,
Nic

 

[Marina]

This question was asked just yesterday.

 

[nicholas]

could you tell me which topic it was or send a link.
I can't find.

THX

 

[Marina]

I am reading through OE, I have no link. It is something like
'concatenating multiple values for datavaluefield'. Searching for keywords
on google groups would probably bring up answers from many similar posts.

 

[Ken Cox [Microsoft MVP]]

I think you can solve this with your SQL SELECT query...something like this:

"SELECT optionnameFR + '  ' + optionprice AS OptionInfo, optionID ,
optionnameFR from ..."

mydropdown.DataTextField = "OptionInfo"

 

[nicholas]

seems to work, but as my price is an integer, he doesn't want to concatenate
a string with an integer.
I tried Ctype (...,...) in the sal statement, but that doesn't work.
How could I fix this?
THX