StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2692978
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
2010-04-22T17:18:03.707
CreationDate
2010-04-22T17:18:03.707
FavoriteCount
0
LastActivityDate
2010-05-11T11:06:40.127
LastEditDate
2010-05-11T11:06:40.127
LastEditorUserId
1
OwnerUserId
323480
ParentId
414605
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
I wanted to be able to have this kind of syntax: <pre><code>using (var w = new HtmlTextWriter(sw)) { w.Html() .Head() .Script() .Attributes(new { type = "text/javascript", src = "somescript.cs" }) .WriteContent("var foo='bar'") .EndTag() .EndTag() .Body() .P() .WriteContent("some content") .EndTag() .EndTag() .EndTag(); } </code></pre> In order to acheive this I've added extension methods to the HtmlTextWriter although a container would probably be more appropriate (I was more interested in getting it to work first of all!) Feeling lazy, I didn't want to write a method for each of the available tags, so I codegend the methods using a t4 template by iterating through the System.Web.UI.HtmlTextWriterTag enum. Tag attributes are managed using anonymous objects; the code basically reflects on the anonymous type, pulls out the properties and turns them into attributes which I think gives the resultant syntax a very clean appearance. The codegend result: <pre><code>using System; using System.Web.UI; using System.Collections.Generic; /// <summary> /// Extensions for HtmlTextWriter /// </summary> public static partial class HtmlWriterTextTagExtensions { static Stack<Tag> tags = new Stack<Tag>(); /// <summary> /// Opens a Unknown Html tag /// </summary> public static HtmlTextWriter Unknown(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("Unknown", null)); return writer; } /// <summary> /// Opens a A Html tag /// </summary> public static HtmlTextWriter A(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("a", null)); return writer; } /// <summary> /// Opens a Acronym Html tag /// </summary> public static HtmlTextWriter Acronym(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("acronym", null)); return writer; } /// <summary> /// Opens a Address Html tag /// </summary> public static HtmlTextWriter Address(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("address", null)); return writer; } /// <summary> /// Opens a Area Html tag /// </summary> public static HtmlTextWriter Area(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("area", null)); return writer; } /// <summary> /// Opens a B Html tag /// </summary> public static HtmlTextWriter B(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("b", null)); return writer; } /// <summary> /// Opens a Base Html tag /// </summary> public static HtmlTextWriter Base(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("base", null)); return writer; } /// <summary> /// Opens a Basefont Html tag /// </summary> public static HtmlTextWriter Basefont(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("basefont", null)); return writer; } /// <summary> /// Opens a Bdo Html tag /// </summary> public static HtmlTextWriter Bdo(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("bdo", null)); return writer; } /// <summary> /// Opens a Bgsound Html tag /// </summary> public static HtmlTextWriter Bgsound(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("bgsound", null)); return writer; } /// <summary> /// Opens a Big Html tag /// </summary> public static HtmlTextWriter Big(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("big", null)); return writer; } /// <summary> /// Opens a Blockquote Html tag /// </summary> public static HtmlTextWriter Blockquote(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("blockquote", null)); return writer; } /// <summary> /// Opens a Body Html tag /// </summary> public static HtmlTextWriter Body(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("body", null)); return writer; } /// <summary> /// Opens a Br Html tag /// </summary> public static HtmlTextWriter Br(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("br", null)); return writer; } /// <summary> /// Opens a Button Html tag /// </summary> public static HtmlTextWriter Button(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("button", null)); return writer; } /// <summary> /// Opens a Caption Html tag /// </summary> public static HtmlTextWriter Caption(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("caption", null)); return writer; } /// <summary> /// Opens a Center Html tag /// </summary> public static HtmlTextWriter Center(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("center", null)); return writer; } /// <summary> /// Opens a Cite Html tag /// </summary> public static HtmlTextWriter Cite(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("cite", null)); return writer; } /// <summary> /// Opens a Code Html tag /// </summary> public static HtmlTextWriter Code(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("code", null)); return writer; } /// <summary> /// Opens a Col Html tag /// </summary> public static HtmlTextWriter Col(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("col", null)); return writer; } /// <summary> /// Opens a Colgroup Html tag /// </summary> public static HtmlTextWriter Colgroup(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("colgroup", null)); return writer; } /// <summary> /// Opens a Dd Html tag /// </summary> public static HtmlTextWriter Dd(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("dd", null)); return writer; } /// <summary> /// Opens a Del Html tag /// </summary> public static HtmlTextWriter Del(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("del", null)); return writer; } /// <summary> /// Opens a Dfn Html tag /// </summary> public static HtmlTextWriter Dfn(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("dfn", null)); return writer; } /// <summary> /// Opens a Dir Html tag /// </summary> public static HtmlTextWriter Dir(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("dir", null)); return writer; } /// <summary> /// Opens a Div Html tag /// </summary> public static HtmlTextWriter Div(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("div", null)); return writer; } /// <summary> /// Opens a Dl Html tag /// </summary> public static HtmlTextWriter Dl(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("dl", null)); return writer; } /// <summary> /// Opens a Dt Html tag /// </summary> public static HtmlTextWriter Dt(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("dt", null)); return writer; } /// <summary> /// Opens a Em Html tag /// </summary> public static HtmlTextWriter Em(this HtmlTextWriter writer) { WritePreceeding(writer); tags.Push(new Tag("em", null)); return writer; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFluent interface for rendering HTML
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJeff Atwood
UserOwnerUserId
1. USToby Couchman
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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

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.