how to show text with whitespace in label

Question

0.00/5 (No votes)

See more:

hi,
i am fetching text from database into label its working fine, but it is not showing the lots of white space between the text...?how it is possible to show text same as it is in databse...

Posted 5-Jul-12 21:10pm

mohansahu

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-07-05T21:16:00

Solution 3

When you send data to a web browser, it squashes strings of spaces to a single space - regardless of the data source. To get round this, convert your spaces to " " which are always shown as a single space character and do not get squashed into a single spaces.
You could use string.Replace(" ", " ") on your string before you set the label.Text value.

[edit]Arrgggh! Browser swallowed the ampersand nbsp semicolon and replaced it with space! - OriginalGriff[/edit]

Posted 5-Jul-12 21:16pm

OriginalGriff

Updated 5-Jul-12 21:18pm

v2

Comments

mohansahu 6-Jul-12 9:05am

i am fetching data from database and showing it in label..in repeater how it is possible to show data same as from database with sapce and new line

OriginalGriff 6-Jul-12 9:14am

In your SELECT statement, use the SQL REPLACE function to change the spaces before they are returned.

mohansahu 6-Jul-12 9:53am

no its not working..

OriginalGriff 6-Jul-12 10:02am

Without the SQL code you used, that is a very pointless remark...:laugh:

Shmuel Zang · Answer 2 · 2012-07-05T21:15:00

Solution 2

For presenting spaces within an HTML page you can use the   entity.

Just replace your spaces with   entities.

For more information about HTML entities, you can see that link: http://www.w3schools.com/html/html_entities.asp[^].

Posted 5-Jul-12 21:15pm

Shmuel Zang

Updated 5-Jul-12 21:29pm

v3

sanwar_mal_jat · Answer 3 · 2012-07-05T21:15:00

Solution 1

Hello try this code

<asp:label style="letter-spacing: 3px;" id="Label1" runat="server" />

Posted 5-Jul-12 21:15pm

sanwar_mal_jat

Updated 5-Jul-12 21:16pm

v3

Comments

mohansahu 6-Jul-12 9:04am

its not workin..