Wrapping label text in C#

[le_mo_mo]

Hi,

I am trying to have one label on a form with multi line display of the
results from a database query. so my query looks like

Select FirstName+" "+LastName+"\r\n"+Address as Info

I want to have the label show

FirstName LastName
Address

I thought that \r\n in the returned result will make it happen but
Label shows up as

FirstName LastName\r\nAddress

Anybody knows how the string should e cosntructed so that the label
text is wrapped where is needed?

Thanks

[carion1]

If this is for a windows app then \n should work. If this is for the web
use <br>.

--

Derek Davis
dd******@gmail.com

<le******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

I am trying to have one label on a form with multi line display of the
results from a database query. so my query looks like

Select FirstName+" "+LastName+"\r\n"+Address as Info

I want to have the label show

FirstName LastName
Address

I thought that \r\n in the returned result will make it happen but
Label shows up as

FirstName LastName\r\nAddress

Anybody knows how the string should e cosntructed so that the label
text is wrapped where is needed?

Thanks

[Mark R. Dawson]

Hi le_mo_mo,
instead of using \r\n use System.Environment.NewLine instead. This will
substitute in the correct newline characters for the system you are running
the code on.

Hope that helps
Mark R Dawson
http://www.markdawson.org

"le******@yahoo.com" wrote:

Hi,

I am trying to have one label on a form with multi line display of the
results from a database query. so my query looks like

Select FirstName+" "+LastName+"\r\n"+Address as Info

I want to have the label show

FirstName LastName
Address

I thought that \r\n in the returned result will make it happen but
Label shows up as

FirstName LastName\r\nAddress

Anybody knows how the string should e cosntructed so that the label
text is wrapped where is needed?

Thanks

[rviray]

For a Web Application, carion1, is correct...use "<BR>"...

for a Windows Application, try (if the \n..doesn't work for you)

Select FirstName + ' ' + LastName + char(10)+char(13) <or is it 13 then
10...double check> + Address as info
--
rviray
------------------------------------------------------------------------
rviray's Profile: http://www.msusenet.com/member.php?userid=4211
View this thread: http://www.msusenet.com/t-1871084823

[Danny Tuppeny]

<le******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I am trying to have one label on a form with multi line display of the
results from a database query. so my query looks like

Select FirstName+" "+LastName+"\r\n"+Address as Info

This would add a literal "\r\n" to the string, which would be the same as
doing:

label1.Text = "Danny\\r\\nTuppeny";

IIRC, you can use linebreaks in SQL, so maybe something like

SELECT FirstName + " " + LastName + "
" + Address as Info

would work?

Alternatively, you could (though it's pretty bad ;)) replace literal \r\n
with real linebreaks:

label1.Text = dr["Info"].Replace("\\r\\n", "\r\n");

[Mark R. Dawson]

I would not recommend writing:

Select FirstName + ' ' + LastName + char(10)+char(13) <or is it 13 then
10...double check> + Address as info
That is not very readable or portable. System.Environment.NewLine should be
used
"rviray" wrote:

For a Web Application, carion1, is correct...use "<BR>"...

for a Windows Application, try (if the \n..doesn't work for you)

Select FirstName + ' ' + LastName + char(10)+char(13) <or is it 13 then
10...double check> + Address as info
--
rviray
------------------------------------------------------------------------
rviray's Profile: http://www.msusenet.com/member.php?userid=4211
View this thread: http://www.msusenet.com/t-1871084823