>>>Hi,
>>>
>>>I have a drop-down list control on the form. The .DataSource of this control is a dataview (from a dataset) created with the following SQL Select
>>>
>>>
>>>select MyField1, MyField2 from MyTable
>>>
>>>
>>>I want to create a column that will have MyField1 and then bunch of spaces and then MyField2. But when I add space to the SQL Select, the spaces are not shown. If I add '& + 'nbsp' + ';' still does not work. Here is an example of what I tried:
>>>
>>>
>>>select MyField1 + ' ' + MyField2 as MyField3 from MyTable
>>>
>>>or
>>>
>>>select MyField1 + '&' + 'nbsp' + ';' + '&' + 'nbsp' + ';' ' + MyField2 as MyField3 from MyTable
>>>
>>>
>>>
>>>What would you suggest?
>>
>>UPDATE. Here is the solution:
>>
>>
>>foreach (ListItem item in ddlist.Items)
>> {
>> item.Text = HttpUtility.HtmlDecode(item.Text);
>> }
>>
>
>You may also want to take a look at the HtmlHelper class for things like this. It is in the MVC namespace but there is no reason you can't use it in non-MVC apps.
>
Thank you. I will check it.
>Isn't your monthly day off coming up? <g>
>
Mabye <g>.
As to the rest of your message, Michel is very strict about technical thread etiquette. He just sent me a PM that he will ban both you and I if we discuss non-technical stuff in this forum.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham