StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9334268
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-02-17T19:36:36.083
FavoriteCount
0
LastActivityDate
2012-04-17T16:12:57.290
LastEditDate
2012-04-17T16:12:57.290
LastEditorUserId
953009
OwnerUserId
953009
ParentId
8262489
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
After revisiting this issue, I have found that updatepanels were causing the problem. Doing some more testing, I looked into what the string contained using the following code: <pre><code>MsgBox(textbox.Text.Contains(vbCr)) MsgBox(textbox.Text.Contains(vbCrLf)) MsgBox(textbox.Text.Contains(vbNewLine)) MsgBox(textbox.Text.Contains(Environment.Newline)) </code></pre> All four statements returned false. This was tested on the string before sending to the database as well as on the string retrieved from the database. From my point of view, there had to be something on the markup that was removing the line breaks. At first, I thought the Literal, Textbox, and Label controls did something funny to line breaks when retrieved in the code behind. This is not the case (and would be bizarre if Microsoft let this happen). Combing through the code some more, I found that all these controls were inside an UpdatePanel. Remembering my previous negative experiences with UpdatePanels, I then thought that this might just be the culprit. I removed it and lo and behold, the line breaks did not go away in the code. The code I posted just above all returned true. Both pages had the controls for submitting the text and displaying the text inside an UpdatePanel. I found that the line breaks disappeared when retrieving the text from the page. When displaying the text onto the page, the UpdatePanel does not alter the string in any way. The following code ended up working just fine: <pre><code>litMessage.Text = messageBody.Replace(Environment.NewLine, " ") </code></pre> Although I'm still not sure why line breaks were still displayed correctly when using the <code>pre</code> tag or even displaying the retrieved value using a javascript alert box.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POReplace(Environment.NewLine, " ") is not working as expected when displaying text on a web page
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USnullexception
UserOwnerUserId
1. USnullexception
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POReplace(Environment.NewLine, " ") is not working as expected when displaying text on a web page
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.