StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
416080
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-01-06T10:45:28.810
FavoriteCount
0
LastActivityDate
2009-01-06T11:34:34.843
LastEditDate
2009-01-06T11:34:34.843
LastEditorUserId
50136
OwnerUserId
50136
ParentId
415991
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
Giraffe
text
Body
You can use a parameter in the constructor to pass it in: <pre><code>public ApplicationController(string movieCategory) { ViewData["categories"] = DataContext.spMovieCategories(movieCategory); } </code></pre> Obviously, you'd need to be able to supply this from the derived controllers, which may be an issue unless the category is specific to each derived controller which seems unlikely: <pre><code>public DerivedController() : base("Derived Movie Category") { // ... } </code></pre> What is probably best is to move the categories retrieval out of the constructor, and move it into a separate method in ApplicationController. The simplest way of getting this called is then to insert a call to it in each Action once you have the category parameter (I'm assuming it's one of the parameters to the Action call?). This is a bit of a pain though. The intended way to solve this problem is ActionFilters, if you create a new ActionFilter like this: <pre><code>public class CategoryAttribute : ActionFilterAttribute, IActionFilter { #region IActionFilter Members void IActionFilter.OnActionExecuted(ActionExecutedContext filterContext) { string category = (string)filterContext.RouteData.Values["category"]; ((ApplicationController)filterContext.Controller).PopulateCategory(category); } void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext) { } #endregion } </code></pre> Any action with the <code>Category</code> attribute applied will execute this code. (I've assumed that you've moved the code in <code>ApplicationController</code> into a method called <code>PopulateCategory</code>. You can also apply it at the Controller level, which then will cause this ActionFilter to be called for every action in the controller. Since you want it to be called for every action on every controller, you can apply it to your ApplicationController so that every derived controller will inherit it: <pre><code>[Category] public class ApplicationController : Controller { // ... } </code></pre> [Edit - Slightly better solution] However, an even further step to simplify is to not use an attribute, but instead to override the OnActionExecuted method of Controller (that I just noticed after I wrote this answer). That means you can get rid of the <code>CategoryAttribute</code> class and the <code>Category</code> attribute on the <code>ApplicationController</code> class and just add this to the <code>ApplicationController</code> class: <pre><code>protected override void OnActionExecuted(ActionExecutedContext filterContext) { string category = (string)filterContext.RouteData.Values["category"]; this.PopulateCategory(category); base.OnActionExecuted(filterContext); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POdynamic site.master menu
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USGiraffe
UserOwnerUserId
1. USGiraffe
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. This table or related slice is empty.
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.