List.GetItems method

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

Namespace:  Microsoft.SharePoint.Client
Assembly:  Microsoft.SharePoint.Client (in Microsoft.SharePoint.Client.dll)

'Declaration
Public Function GetItems ( _
	query As CamlQuery _
) As ListItemCollection
'Usage
Dim instance As List
Dim query As CamlQuery
Dim returnValue As ListItemCollection

returnValue = instance.GetItems(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: