this is vb.net code you can always look in the help file for .net
>I would prefer to do it in my SQL select. But I am not familiar with the functions cstr() and cchar(). Where do I learn about them?
>
>Thank you.
>
>>Ok I bet is a HTML prb so what will need to do on that case is convert the scaces to
>>You can do it on your select or you can do it in code I would say in code.
>>so in your code you will have something like this
>>
>>For Each row in dsData.tables(0).Rows
>> dropdownlist.items.Add(New ListItem(cstr(cstr(row("id")).Trim().PadRight(10,cchar(" ")).Replace(" ", " ") & row("description")), cstr(row("id"))))
>>Next row
>>
>>
>>something along this lines.
>>
>>
>>>>Dimitry did you saw the hml that got generated to see if the spaces appears in the html?
>>>>
>>>
>>>Alexandre,
>>>
>>>Yes, the HTML source does show the spaces. I wish there was a way to replace the spaces with NBSP. So, why do you think DDL ignores my spaces?
Alexandre Palma
Senior Application Architect