Whats the deal?

[Doug Bell]

buc
have you tried select field1 & ' - ' & field2
Doug

 

[buc]

I have a simple combox on the screen that is bound via a datareader to a
stored proc in sql that returns a simple string. The code is

'load stored proc then

dReader = tmpSQL.SQLcmd.ExecuteReader()
combobox1.DataSource = dReader
dReader.Read()
combobox1.DataTextField = dReader.GetName(0)
combobox1.DataBind()

This works great EXCEPT VB is removing the spaces from the string. I build
the string with a SQL statement
select field1 + ' - ' + field2 from table
This returns XXX - YYYY for example (verified by just reading the
strings). HOWEVER, when VB places this string in the combo box, It trims the
spaces between the XXX and YYYY and leaves the string
XXX-YYYY. It always does this. This is crazy. It does it on every machine I
try it on, (diff developemnt computers too). Whats going on? I have no TRIM
statments, NO FORMAT statements in the combobox properties. It is directly
bound!! Thanks!!
BUC

 

[buc]

No effect... A BUG maybe??

buc
have you tried select field1 & ' - ' & field2
Doug

 

[Cor Ligthert]

Buc,

A combobox does not have a DataTextField, that is a property from a
dropdownlist.

Windowforms controls cannot be loaded directly from a datareader as webform
controls can.

Your code looks completly as webform code by the way however there does the
combobox not exist.

So it is strange it works "great"

And please don't call something a bug before you know it is, because you
could have said as well, "is the problem that it is raining here". The only
thing it is telling it "I have to less knowledge to solve this problem".
However say that than and don't accusse others who made those controls.

Just my thoughts.

Cor

"buc" <[email protected]>

....

 

[Greg Burns]

Browser will toss extra spaces in HTML. I am pretty sure that is what you
are seeing.

You may have to replace your spaces with &nbsp; codes. But don't quote me
on that! (That will be tricky to do without using a loop and manually
adding items to the dropdown box.

untested:

Do while dReader.Read
combobox1.Items.Add(New ListItem(dReader(0).Value.Replace(" ", "&nbsp;"),
dReader(1).Value)
Loop

Greg

 

[Buc]

Cor,

Maybe a misunderstanding, my apologies..it is in a webform, with a
'dropdownlist', not a 'combo' type box. However, I have contacted Microsoft
and this is a reproducible issue using the dropdownlist in a webform. Maybe
a fix sometimes in the future. O Well...
Buc