Skip to Content
Professional SharePoint® 2010 Field Guide
book

Professional SharePoint® 2010 Field Guide

by Steve Mann, Colin Murphy, Pablo Gazmuri, Chris Caravajal, Christina Wheeler
February 2012
Intermediate to advanced
456 pages
14h 54m
English
Wrox
Content preview from Professional SharePoint® 2010 Field Guide
Managing Large Lists
327
Unless the object model override is enabled, the two preceding code snippets have no effect.
If the object model override is disabled, there is a simple way to get around the query limit
by coding around the problem. By making use of the
RowLimit property on the SPQuery and
SPSiteDataQuery objects, you can limit the number of rows returned from the query and avoid
triggering throttling limits.
In addition, you can then page through the entire result set for your query beyond the initial
RowLimit by making use of the ListItemCollectionPosition property. When retrieved from an
SPListItemCollection that was returned from a query, this property indicates the location of the
next set of data in the results set that couldn’t be returned due to the
RowLimit. When set for a query,
this property indicates the position of items in the result set that should be retrieved when the query
executes. This is useful because you can simply pass the
ListItemCollectionPosition from the
results of one query into the call for the next query, until the item is null. The following code demon-
strates how easy it is to page through results using the most common implementation:
using(SPSite site = new SPSite(“http://yoursite”)){
SPList list = site.RootWeb.Lists[“SomeList”];
SPQuery query = new SPQuery();
//set the RowLimit, or page size
Query.RowLimit = 10;
Query.Query = @“<OrderBy><FieldRef ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® SharePoint® Designer 2010 Unleashed

Microsoft® SharePoint® Designer 2010 Unleashed

Kathy Hughes
How to Develop a Great Digital Strategy

How to Develop a Great Digital Strategy

Jeanne W. Ross, Cynthia M. Beath, Ina M. Sebastian

Publisher Resources

ISBN: 9781118105054Purchase book