Ok if you mean show something like Prev 1 2 3 4 5 6 .. 40 41 Next Prev 1 2 .. 6 7 8 9 10 .. 40 41 Next First thing we need to is create a function that can process what we need to output the pagination. Heres a function I use … Read more
Google I/O 2010 – GWT’s UI overhaul javadocs package com.google.gwt.cell.client in 2.1 Eclipse update site for milestone 2 While the code is in bikeshed, add this line to your gwt.xml file: <inherits name=”com.google.gwt.requestfactory.RequestFactory”/> The following examples follow: CellList of TextCells with PageSizePager CellList of TextCells with a SimplePager CellList of TextCells with a SimplePager and … Read more
Excuse the verbose data setup but this works… @{ var data = Enumerable.Range(0, 10).Select(i => new { Index = i, SubItems = new object[] { new { A = “A” + i, B = “B” + (i * i) } } }).ToArray(); WebGrid topGrid = new WebGrid(data); } @topGrid.GetHtml(columns: topGrid.Columns( topGrid.Column(“Index”), topGrid.Column(“SubItems”, format: (item) => … Read more
I came across a nice solution here: Horizontal Pager this is a cleaned up GitHub version of the code found here: Real View Switcher It may seem like overkill for just using it on images, but this solution allows for infinite paging with using a little trick (ie: when on first page you can scroll … Read more
Below code should do it. I am using in my own project and tested for most cases. usage: Pageable pageable = new OffsetBasedPageRequest(offset, limit); return this.dataServices.findAllInclusive(pageable); and the source code: import org.apache.commons.lang3.builder.EqualsBuilder; import org.apache.commons.lang3.builder.HashCodeBuilder; import org.apache.commons.lang3.builder.ToStringBuilder; import org.springframework.data.domain.AbstractPageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; import java.io.Serializable; /** * Created by Ergin **/ public class OffsetBasedPageRequest implements Pageable, … Read more
The default page size is fixed by what the MMU (memory management unit) of the CPU supports. In 32-bit protected mode x86 supports two kinds of pages: normal ones, 4 KiB huge ones, 4 MiB Not all x86 processors support large pages. One needs to have a CPU with Page Size Extension (PSE) capabilities. This … Read more
I encountered some performance issues using the COUNT() OVER() method. (I’m not sure if it was the server as it took 40 seconds to return 10 records and then later didn’t have any issues.) This technique worked under all conditions without having to use COUNT() OVER() and accomplishes the same thing: DECLARE @PageSize INT = … Read more
Before I answer your questions (I hope I do), here are a few introductory remarks: Remarks The problem here is that “virtual memory” has two senses. “Virtual memory” as a technical term used by low-level programmers has (almost) nothing to do with “virtual memory” as explained to consumers. In the technical sense, “virtual memory” is … Read more
Here’s my solution – use “Logarithmic Page Navigation”: This can be achieved by having page numbers distributed logarithmically, according to distance from either the endpoints or the current page. Here’s an example of what I mean: 1 2 3 4 5 6 . 10 . 20 . 30 . 40 . 50 .. 100 .. … Read more
You can use the Row_Number() function. Its used as follows: SELECT Row_Number() OVER(ORDER BY UserName) As RowID, UserFirstName, UserLastName FROM Users From which it will yield a result set with a RowID field which you can use to page between. SELECT * FROM ( SELECT Row_Number() OVER(ORDER BY UserName) As RowID, UserFirstName, UserLastName FROM Users … Read more