paging

Nhibernate - Paging and eager loading entities

I have two entities, a team and an employee. I want get a list of employees with eager loaded teams. The list has to be paged. public PagedList<Employee> GetAllEmployeesWithEagerLoadedTeams(int page, int pageSize) { var criteria = GetSession() .CreateCriteria(typeof (Employee)) .SetFetchMode(DomainModelHelper.GetAss...

Anyone know of a good SNPP/WCTP Gateway i can use in my application?

I need my application to receive SNPP & WCTP messages from clients arround the world... and i don't won't to implement the full RFC on my own, do you know where it is possible to download some application/service that can perform as SNPP/WCTP Gateway and convert the protocol from snpp/wctp to http or something like that...which is more ...

How does paging work in asp.net?

I am curious to know how does paging work in asp.net? If my query returns 500 records, and my gridview paging limits to 25 records per page, when the gridview loads, does the recordset return 25 records or 500 records? If the recordset returns 25 records, how does ado communicate with SQL to return records for page two? If the reco...

Telerik RadGrid's paging section not refreshing

Hello All I have a problem with a telerik RadGrid where the paging section is not refreshing. If, for example, the first search returns 15 records and the second search only 5 records, I see '... page 1 of 2...' in the second search which is incorrect info caused by the paging section of the grid not refreshing. My page count is set to ...

Caching paged LINQ results without using Skip() or Take()

I am using LINQ for paging data in my website. I am currently using Skip() and Take() to perform the paging. Now I want to cache the data using cache dependencies so that the the cache will invalidate if the data changes. However SQL Server's query notifications don't support the TOP expression. Are there any alternative ways to query a ...

NHibernate - Paging with ICriteria and optional ICriteria calls

I want to do something like this... return GetSession() .ToPagedList<Employee>(page, pageSize, x=> x.SetFetchMode(DomainModelHelper.GetAssociationEntityNameAsPlural<Team>(), FetchMode.Eager)); But I don't know how to pass this Func<ICriteria,ICriteria> into the ISession or ICriteria. I have a standard paging ext...

ASP.NET GridView Paging using Linq query as datasource

I am looking for a way to do paging with a GridView when i set the datasource at run time using a linq query. here is my code: ETDataContext etdc = new ETDataContext(); var accts = from a in etdc.ACCOUNTs orderby a.account_id select new { Account = a.account_id, aType...

NHibernate query mapped collection

Dear All! In my ASP.NET web-application I use NHibernate to persist my "User"-Instances, where each of them has a "Entries" - collection. It is a typical one-to-many mapping and it works just fine. The mapping-code for the entries looks like this: <bag name="Entries" cascade="all-delete-orphan"> <key column="UserID" /> <one-to-ma...

paging with asp.net mvc c#

Hello its my code where I giving out paging of view: <div style="float: right;"> <%= Html.RouteLink("<<", new { page = 1 }, new { title = "first page" })%> <% if (this.Model.HasPreviousPage) {%> <%= Html.RouteLink("<", new { page = (Model.PageIndex - 1) }, new { title = "previous page"})%> <%}...

Drupal Paging module doesn't show the numbers of pages.

HI, I shall finish some edits on drupal projet, that was done by another programmer (i have no contact of him). I'm newbie and I try to find out how the PAging module works. There are no numbers of pages showing. I suppose he changed the code. I found a file pager.php in projet's own theme with this function, that is probably doing the ...

ASP.net: Crystal Reports - Subreport over multiple pages

I have a Crystal Report that has a header and a subreport with the height locked at a exact amount so the subreport will display a maximum of 20 rows on the page. However, this limitation has restricted the use of the system, and the users now require an unlimited number of rows in the subreport. I wish to keep the same layout as the r...

Using jqGrid with sortable columns... paging then results in a data/column mismatch.

I have a very vanilla jqGrid with "sortable: true" (which allows you to drag/drop to reorder the columns). There are 8 columns, none are hidden, none have any properties set other than name, index, and width. The column drag/drop works initially. I drag a column header, and drop it in a new location. The header and the data in the colum...

iphone uiscrollview - custom paging distance

I have a long UIScrollView that I want to page through by a variable amount (I have images of different widths that I want to center on screen as the user scrolls through with paging enabled: From the UIScrollView Class Reference for pagingEnabled: the scroll view stops on multiples of the view bounds when the user scrolls. So I guess ...

What would be the ideal way to do paging using a Infragistics WebDataGrid and SQL Server 2008

We have an application that is growing in users and the infragistics WebDataGrid and stored procedure are having performance issues. I'm looking into adding the ROW_NUMBER() function in the stored procedure, but I'm concerned with sorting. It looks like I would need to do change the procedure to have a dynamic order by case statement i...

Using rich:dataTable how do i store current sorting and current page in a managed bean variable

Using richfaces 3.3.0 we have a rich:dataTable with sortyBy's in the rich:column components and with a rich:dataScrolling component. These allow the user to sort the table in any way they want and go through the pages, all in client memory. Usually our users spend a long time looking for a certain row by sorting and browsing the pages,...

SQL sorting , paging, filtering best practices in ASP.NET

I am wondering how Google does it. I have a lot of slow queries when it comes to page count and total number of results. Google returns a count value of 250,000,00 in a fraction of a second. I am dealing with grid views. I have built a custom pager for a gridview that requires an SQL query to return a page count based on the filters s...

How to do Paging based on dynamic validation criteria?

Here is the case: I need to display a list of records on a page, and paging is necessary. The question I got is whether a record should be displayed depends on validation result computed in memory, after selected from database. for example, 50 records for one page: Select 50 records from database 30 records are left after validatio...

Send the total rows/last row, included with the resultset

I have this procedure used for getting items on the current page. I would also like the include an OUT var having the total number of items so I can calculate the total number of pages. USE [some_name] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetFilteredProductDetails] @start int, @end int AS B...

total number of rows for paging with subsonic

Hi, there! Im trying to do paging with subsonic that gets data from custom stored procedure. Im clear with everything, except how to get total number of rows, so that I could show user how many rows are there and how many pages he can go to? Im new to subsonic, maybe Im missing something. I know that it is possible to getpaged with su...

Is this how you paginate, or is there a better algorithm?

I want to be able to take a sequence like: my_sequence = ['foo', 'bar', 'baz', 'spam', 'eggs', 'cheese', 'yogurt'] Use a function like: my_paginated_sequence = get_rows(my_sequence, 3) To get: [['foo', 'bar', 'baz'], ['spam', 'eggs', 'cheese'], ['yogurt']] This is what I came up with by just thinking through it: def get_rows(se...