c# sharepoint get list item query

using System;
using Microsoft.SharePoint.Client;
using SP = Microsoft.SharePoint.Client;

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

            ClientContext clientContext = new ClientContext(siteUrl);
            SP.List oList = clientContext.Web.Lists.GetByTitle("Announcements");

            CamlQuery camlQuery = new CamlQuery();
            camlQuery.ViewXml = "<View><Query><Where><Geq><FieldRef Name='ID'/>" +
                "<Value Type='Number'>10</Value></Geq></Where></Query><RowLimit>100</RowLimit></View>";
            ListItemCollection collListItem = oList.GetItems(camlQuery);

            clientContext.Load(collListItem);

            clientContext.ExecuteQuery();

            foreach (ListItem oListItem in collListItem)
            {
                Console.WriteLine("ID: {0} \nTitle: {1} \nBody: {2}", oListItem.Id, oListItem["Title"], oListItem["Body"]);
            }
        }
    }
}

Posted by: Guest on April-13-2021

Source

using System; using Microsoft.SharePoint.Client; namespace Microsoft.SDK.SharePointFoundation.Samples { class List_getItemByIdExample { static void Main() { string siteUrl = "http://MyServer/sites/MySiteCollection"; ClientContext clientContext = new ClientContext(siteUrl); Web site = clientContext.Web; List targetList = site.Lists.GetByTitle("Announcements"); // Get the list item from the Announcements list whose Id is 4. // Note that this is the ID of the item in the list, not a reference to its position. ListItem targetListItem = targetList.GetItemById(4); // Load only the title. clientContext.Load(targetListItem, item => item["Title"]); clientContext.ExecuteQuery(); Console.WriteLine("Request succeeded. \n\n"); Console.WriteLine("Retrieved item is: {0}", targetListItem["Title"]); } } }

Code answers related to "c# sharepoint get list item query"

Code answers related to "C#"

Browse Popular Code Answers by Language

Answers for "c# sharepoint get list item query"

Code answers related to "c# sharepoint get list item query"

Code answers related to "C#"

C# Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us