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?

Answer 1

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" />

Answer 2

Try combining carriage return with line feed:

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