SQL string not line breaking in gridview

Question

I have this string in some sql:

FT_TBL.Title  + CHAR(13) + 'Job:' + str(FT_TBL.JobName) as Title

Now the Title is parsed as a boundfield in a c# gridview, the first row puts "Job" on the next line, but after that its random, some lines are next line some aren't! Any ideas?

FWIW you shouldn't do your HTML formatting in SQL. Return two data fields and format your grid accordingly. — n8wrl
– n8wrl, Commented Nov 10, 2009 at 21:49
that makes sense , but how do you format 2 boundfields into one? — David
– David, Commented Nov 10, 2009 at 21:51
I would use a template field and lay out accordingly. aspnet101.com/aspnet101/tutorials.aspx?id=58 — n8wrl
– n8wrl, Commented Nov 10, 2009 at 21:55
thanks, this is an alternative, but for now, setting htmlencode worked easier for me — David
– David, Commented Nov 10, 2009 at 21:59
Possible duplicate of How do I break the a BoundField's HeaderText — Michael Freidgeim
– Michael Freidgeim, Commented Oct 1, 2019 at 4:19

Canavar · Accepted Answer · 2009-11-10 21:56:53Z

11

Instead of char(13) use <br /> for line breaks in HTML.

Note : Do not forget to add HtmlEncode="false" to your columns that show HTML content :

<asp:BoundField DataField="Title" HtmlEncode="false" />

edited Nov 10, 2009 at 21:56

answered Nov 10, 2009 at 21:46

Canavar

48.1k17 gold badges94 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

n8wrl Over a year ago

This is exaclty it - unless you flag the column as 'nowrap' HTML will wrap w/o the linebreak

David Over a year ago

<br /> doesnt seem to work as it just adds <br /> to the text now and doesnt parse it as html in the boundfield :(

Michael Freidgeim Over a year ago

HtmlEncode="false" is not recommended due to potential XSS attacks learn.microsoft.com/en-us/dotnet/api/…

Registered User · Accepted Answer · 2009-11-10 21:46:52Z

0

Try combining carriage return with line feed:

FT_TBL.Title  + CHAR(10) + CHAR(13) + 'Job:' + str(FT_TBL.JobName) as Title

answered Nov 10, 2009 at 21:46

Registered User

8,4338 gold badges54 silver badges67 bronze badges

Collectives™ on Stack Overflow

SQL string not line breaking in gridview

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related