Trimming data in dropdownlist from sqldatareader

[William Mild]

When I databind a value/text combination from an
sqldatareader to a dropdownlist, the trailing spaces are
getting included in the dropdownlist. I can RTRIM from
within the SQL to fix this problem, but I am wondering if
there is a more elegant solution to trim all the
text/value combinations in a dropdownlist.

[Jacob Yang [MSFT]]

Hi William

To my knowledge, there is not an elegant way from dropdownlist side. One
clumsy way I can think of is to populate a new collection or arraylist that
contains the data fields to be bound to the dropwodnlist. While populating
this new collection or arraylist we can trim the data accordingly.

Please let me know if it makes sense.

Best regards,

Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[William Mild]

Yes, that makes sense. Thank you.

-----Original Message-----
Hi William

To my knowledge, there is not an elegant way from dropdownlist side. One clumsy way I can think of is to populate a new collection or arraylist that contains the data fields to be bound to the dropwodnlist. While populating this new collection or arraylist we can trim the data accordingly.
Please let me know if it makes sense.

Best regards,

Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
.