also I notice since I did nbsp; code it put the space, so add the # before
For Each row in dsData.tables(0).Rows
dropdownlist.items.Add(New ListItem(cstr(row("id")).Trim().PadRight(10,cchar(" ")).Replace(" ", "nbsp;") & cstr(row("description")), cstr(row("id"))))
Next row
>I did find the description of these functions in .net help.
>I will have to read your code a few times to understand it, I am still learning.
>Thank you very much.
>
>>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