StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1115621
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-07-12T09:09:05.723
FavoriteCount
0
LastActivityDate
2009-07-12T09:09:05.723
LastEditDate
LastEditorUserId
0
OwnerUserId
48963
ParentId
1115554
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You can try my pager HTML helper: <pre><code>using System; using System.Text; using System.Web.Mvc; using System.Web.Routing; namespace System.Web.Mvc { public class Pager { private ViewContext viewContext; private readonly int pageSize; private readonly int currentPage; private readonly int totalItemCount; private readonly RouteValueDictionary linkWithoutPageValuesDictionary; public Pager(ViewContext viewContext, int pageSize, int currentPage, int totalItemCount, RouteValueDictionary valuesDictionary) { this.viewContext = viewContext; this.pageSize = pageSize; this.currentPage = currentPage; this.totalItemCount = totalItemCount; this.linkWithoutPageValuesDictionary = valuesDictionary; } public string RenderHtml() { int pageCount = (int)Math.Ceiling(this.totalItemCount / (double)this.pageSize); int nrOfPagesToDisplay = 8; var sb = new StringBuilder(); sb.Append("<ul class=\"pagination\">"); // Previous if (this.currentPage > 1) { sb.Append(string.Format("<li class=\"prev\"><a href=\"{0}\">«</a></li>", Route(this.currentPage - 1))); } else { sb.Append("<li class=\"prev disabled\">«</li>"); } int start = 1; int end = pageCount; if (pageCount > nrOfPagesToDisplay) { int middle = (int)Math.Ceiling(nrOfPagesToDisplay / 2d) - 1; int below = (this.currentPage - middle); int above = (this.currentPage + middle); if (below < 4) { above = nrOfPagesToDisplay; below = 1; } else if (above > (pageCount - 4)) { above = pageCount; below = (pageCount - nrOfPagesToDisplay); } start = below; end = above; } if (start > 3) { sb.Append(GeneratePageLink("1", 1)); sb.Append(GeneratePageLink("2", 2)); sb.Append("<li class=\"more\">...</li>"); } for (int i = start; i <= end; i++) { if (i == this.currentPage) { sb.Append(string.Format("<li class=\"page selected\">{1}</li>", Route(i),i)); } else { sb.Append(GeneratePageLink(i.ToString(), i)); } } if (end < (pageCount - 3)) { sb.Append("<li class=\"more\">...</li>"); sb.Append(GeneratePageLink((pageCount - 1).ToString(), pageCount - 1)); sb.Append(GeneratePageLink(pageCount.ToString(), pageCount)); } // Next if (this.currentPage < pageCount) { sb.Append(string.Format("<li class=\"next\"><a href=\"{0}\">»</a></li>", Route(this.currentPage + 1))); } else { sb.Append("<li class=\"next disabled\">»</li>"); } sb.Append("</ul>"); return sb.ToString(); } private string Route(int pageNumber) { var pageLinkValueDictionary = new RouteValueDictionary(this.linkWithoutPageValuesDictionary); pageLinkValueDictionary.Add("page", pageNumber); var virtualPathData = RouteTable.Routes.GetVirtualPath(this.viewContext.RequestContext, pageLinkValueDictionary); return virtualPathData.VirtualPath; } private string GeneratePageLink(string linkText, int pageNumber) { var pageLinkValueDictionary = new RouteValueDictionary(this.linkWithoutPageValuesDictionary); pageLinkValueDictionary.Add("page", pageNumber); var virtualPathData = RouteTable.Routes.GetVirtualPath(this.viewContext.RequestContext, pageLinkValueDictionary); if (virtualPathData != null) { string linkFormat = "<li class=\"page\"><a href=\"{0}\">{1}</a></li>"; return String.Format(linkFormat, virtualPathData.VirtualPath, linkText); } else { return null; } } } } </code></pre> How to use: <pre><code><%= Html.Pager(10, (Request["page"].IsNotNull() ? Request["page"].ToInt() : 1), ViewData["Total"].ToInt(), new { category = Request["category"], alphabet = Request["alphabet"] })%> </code></pre> And Controller implementation looks like this: <pre><code>public ActionResult Index(string page, string category, string alphabet) { ..... ViewData["Total"] = model.Count(); return View(model.ToPagedList((page.IsNotNull() ? page.ToInt() - 1 : 0), 10)); } </code></pre> And finally output: <a href="http://clip2net.com/clip/m12007/1247389672-clip-1kb.png" rel="nofollow noreferrer">pager http://clip2net.com/clip/m12007/1247389672-clip-1kb.png</a> 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PONested server side blocks in ASP.NET MVC?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USomoto
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. COWell, actually I'm trying to have only two links [previous 10, and next 10]. I'm not sure if your pager helper method can help with that. Thanks though.
 singulars
 PostPostId
 PO
 UserUserId
 USGalilyou
2. COWelcome, no problem :_)
 singulars
 PostPostId
 PO
 UserUserId
 USomoto

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.