A class of the Microsoft.SharePoint namespace, SPListItemCollection represents a collection of SPListItem objects.

learn more… | top users | synonyms

17
votes
2answers
11k views

SPList.Add() vs SPList.AddItem() SharePoint 2010

Using some test code i found out that SPList.AddItem() executes slight faster then SPList.Add() - does anyone know why is it so ? DateTime start = DateTime.Now; SPList ...
7
votes
2answers
12k views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> ...
3
votes
3answers
3k views

GridView lookups displaying as “id;#value”

I am using an ASP.net gridview. The datasource is SPList.Items.GetDataTable(). The gridview is working fine; however, lookup and multilookup columns display as "id;#value". Is there any way to just ...
0
votes
1answer
532 views

SPListItemCollection slow

I have a list with over 150k records. I'm doing a filter to get only 1 record via CAML, only sort by a particular column, and this is it takes at least 15 seconds for me to have this return, which is ...
0
votes
2answers
4k views

How to get SPListItemCollection from a SPFolder?

I am making a SharePoint 2010 visual web part, and I want to recursively iterate through all files in a document library which has nested folders. I can get a SPListItemCollection for all items and ...
0
votes
2answers
10k views

SPListItemCollection Get ItemCount with rowlimit

I am filtering a list in caml SPQuery oQuery = new SPQuery(); oQuery.Query = "<OrderBy><FieldRef Name='FullName' /></OrderBy><Where><Contains><FieldRef ...