Export (0) Print
Expand All

List.GetItems method

Returns a collection of items from the list based on the specified query.

Namespace:  Microsoft.SharePoint.Client
Assemblies:   Microsoft.SharePoint.Client.Silverlight (in Microsoft.SharePoint.Client.Silverlight.dll);  Microsoft.SharePoint.Client.Phone (in Microsoft.SharePoint.Client.Phone.dll)  Microsoft.SharePoint.Client (in Microsoft.SharePoint.Client.dll)

public ListItemCollection GetItems(
	CamlQuery query
)

Parameters

query
Type: Microsoft.SharePoint.Client.CamlQuery

A CamlQuery object that contains the query.

Return value

Type: Microsoft.SharePoint.Client.ListItemCollection
A ListItemCollection object that represents the items.

ExceptionCondition
SPException

The field specified in the query is not present in the list. Error code: -2130575340.

SPQueryThrottledException

The throttling limit is exceeded by the operation. Error code: -2147024860.Or there is a lack of resources available to process the request. Error code: -2147024749.

UnauthorizedAccessException

The user has insufficient permissions to perform the operation. Error code: -2147024891.

It must not be a null reference (Nothing in Visual Basic).

This code example gets announcements in the current site that contain the specified string.

using System;
using Microsoft.SharePoint.Client;

namespace Microsoft.SDK.SharePointFoundation.Samples
{
    class List_getItemsExample
    {
        static void Main()
        {
            string siteUrl = "http://MyServer/sites/MySiteCollection";

            ClientContext clientContext = new ClientContext(siteUrl);
            Web site = clientContext.Web;
            List targetList = site.Lists.GetByTitle("Announcements");

            CamlQuery query = new CamlQuery();
            query.ViewXml = "<View><Query><Where><Contains><FieldRef Name='Title'/><Value Type='Text'>announce</Value></Contains></Where></Query></View>";
            ListItemCollection collListItem = targetList.GetItems(query);

            clientContext.Load(collListItem);
            clientContext.ExecuteQuery();

            if (collListItem.Count == 0)
            {
               Console.WriteLine("No items containing 'announce' found.");
            }
            else
            {
               Console.WriteLine("Items containing 'announce' found:\n");
               foreach (ListItem targetListItem in collListItem)
                  Console.WriteLine(targetListItem["Title"]);
            }
        }
    }
}


Show:
© 2014 Microsoft