StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8852941
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-01-13T15:29:24.983
FavoriteCount
0
LastActivityDate
2012-01-13T18:35:54.410
LastEditDate
2012-01-13T18:35:54.410
LastEditorUserId
304832
OwnerUserId
304832
ParentId
8851929
PostTypeId
2
Score
19
ViewCount
0
LastEditorDisplayName
text
Body
We use Serge Zab's helper for optgroup dropdowns. Here is a sample: The viewmodel: <pre><code>public class OurViewModel { public int? TypeId { get; set; } public IEnumerable<GroupedSelectListItem> GroupedTypeOptions { get; set; } } </code></pre> The controller: <pre><code>public ActionResult Add() { var model = new OurViewModel { // fill with initial values }; PutTypeDropDownInto(model); return View(model); } [NonAction] private void PutTypeDropDownInto(OurViewModel model) { model.GroupedTypeOptions = _repos.GetTypes() .OrderBy(t => t.Category.EnglishName).ThenBy(t => t.EnglishName) .Select(t => new GroupedSelectListItem { GroupKey = t.Category.RevisionId.ToString(), GroupName = t.Category.EnglishName, Text = t.EnglishName, Value = t.RevisionId.ToString() } ); } </code></pre> The view <pre><code>@Html.DropDownGroupListFor(m => m.TypeId, Model.GroupedTypeOptions, "[Select a type]") </code></pre> Note that you can't use a regular SelectList. You have to use a collection of his GroupedSelectListItem class. Also, our solution doesn't use viewbag. The dropdown list is strongly typed on the viewmodel. Update To get the html helper to work in your view, the view needs to be able to find it. You can either add a @using directive at the top of the view with your MyExtensionClass.cs namespace, or add the namespace to the view-specific web.config, like so: <pre><code><pages pageBaseType="System.Web.Mvc.WebViewPage"> <namespaces> <add namespace="System.Web.Mvc" /> <add namespace="System.Web.Mvc.Ajax" /> <add namespace="System.Web.Mvc.Html" /> <add namespace="System.Web.Routing" /> <add namespace="Microsoft.Web.Mvc" /> <add namespace="Namespace.For.MyExtensionClass" /> </namespaces> </pages> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POConsuming a Helper code for optgroup functionality in Asp.net MVC
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USdanludwig
UserOwnerUserId
1. USdanludwig
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POConsuming a Helper code for optgroup functionality in Asp.net MVC
 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
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
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.