data-paging

What is the best method for paging with datagrid performance?

On a site with a high number of users, should paging be handled in code, or with a stored procedure. If you have employed caching, please include your success factors. ...

DomainDataSource DataPager with silverlight 3 DataGrid & .Net RIA Services

I have a simple datagrid example with silverlight 3, and am populating it with the .NET ria services using a DomainDataSource along with a DataPager declaratively (nothing in the code-behind), and am experiencing this problem: The LoadSize is 30, and the Page size is 15, and when the page is loaded, the 1st and 2nd page appear correctly...

Data paging in SQL Server CE (Compact Edition)

I am writing a wpf destop application, and would like to use SQL Server CE as a backend. I'm trying to come up with a good way to do efficient data paging. In SQL Server Express, I can do something like this: Select ID, FirstName, LastName From (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS Row, ID, FirstName, LastName From TestTable ...

DataServiceConfiguration is internal so I can't enable WCF data paging?

Hi again, I have a problem with my WCF Data Service, and this one is just plain weird. I'm trying to enable paging so that large collections will be handled better, which was the whole idea behind me using data services in the first place. However, all the examples I've seen are based on using DataServiceConfiguration, as shown here: ...

Help ! How do I get the total number rows from my SQL Server paging procedure ?

Ok I have a table in my SQL Server database that stores comments. My desire is to be able to page though the records using [Back],[Next], page numbers & [Last] buttons in my data list. I figured the most efficient way was to use a stored procedure that only returns a certain number of rows within a particular range. Here is what I came u...

Page navigation design question - Next Prev versus More

I have been wondering why social sites such as twitter and facebook use the concept of "More" results rather than paging, such as Next and Previous pages. Is this commonly used when paging through timelines? Or is there a performance reason? Do you have any insight as to why one technique is implemented over another? ...

SQL ce data paging possible?

Is there a way to implement data paging with sql ce? It would be for windows mobile app. Currently using the sql compact edition 3.5. Also using the Microsoft Sync Framework ADO.net v1.0 for device. ...

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...

control that has paging but supports custom format

hello everyone, i need to know what control in asp .net 2.0 to use to get this layout: i need to display 8 videos at a time using 2 rows with 4 columns, but the control should also have paging (to display 8 items per page). i've thought of using a formview but the paging for formview is per one article content / datarow only. i'm also...