This topic has not yet been rated - Rate this topic

List.GetItems Method

SharePoint 2010

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

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

Syntax

Copy

[RemoteAttribute]
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.

Exceptions

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

Remarks

It must not be null.

Examples

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

Copy

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"]);
            }
        }
    }
}

Reference

List Class

List Members

Microsoft.SharePoint.Client Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ