How to Create/Update/Delete SharePoint 2010 list items using Client Object Model


In this article we are going to see how to create, update and delete SharePoint 2010 list items using Client Object Model.

I have created one list named as Test in the SharePoint 2010 site with one column "Title". I will be creating Console Application using Visual Studio 2010 to do create, update and delete methods.

Create List Item:
  • Go to Visual Studio 2010.
  • Go to File => New => Project.
  • Select Console Application and name it as CreateListItem.
  • Click Add.
  • Add the references Microsoft.SharePoint.dll and Microsoft.SharePoint.Client.dll.

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using Microsoft.SharePoint;
    using Microsoft.SharePoint.Client;
    namespace CreateListItem
    {
        class Program
        {
            static void Main(string[] args)
            {
                string siteUrl = "http://servername:39130/";
                ClientContext clientContext = new ClientContext(siteUrl);
                List oList = clientContext.Web.Lists.GetByTitle("Test");
                ListItemCreationInformation listCreationInformation = new ListItemCreationInformation();
                ListItem oListItem = oList.AddItem(listCreationInformation);
                oListItem["Title"] = "Item1";
                oListItem.Update();
                clientContext.ExecuteQuery();
            }
        }
    }

  • Hit F5.
  • Go to the SharePoint list "Test" and you could see a new item is added.

    1.gif
Update List Item:
  • Go to Visual Studio 2010.
  • Go to File => New => Project.
  • Select Console Application and name it as UpdateListItem.
  • Click Add.
  • Add the references Microsoft.SharePoint.dll and Microsoft.SharePoint.Client.dll.

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using Microsoft.SharePoint;
    using Microsoft.SharePoint.Client;

    namespace
    UpdateListItem
    {
        class Program
        {
            static void Main(string[] args)
            {
                string siteUrl = "http://servername:39130/";
                ClientContext clientContext = new ClientContext(siteUrl);
                List oList = clientContext.Web.Lists.GetByTitle("Test");
                ListItem oListItem = oList.GetItemById(5);
                oListItem["Title"] = "My Updated Item.";
                oListItem.Update();
                clientContext.ExecuteQuery();
            }
        }
    }
  • Hit F5.
  • Go to the SharePoint list "Test" and you could see a item is updated.
Delete List Item:
  • Go to Visual Studio 2010.
  • Go to File => New => Project.
  • Select Console Application and name it as DeleteListItem.
  • Click Add.
  • Add the references Microsoft.SharePoint.dll and Microsoft.SharePoint.Client.dll.

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using Microsoft.SharePoint;
    using Microsoft.SharePoint.Client;

    namespace
    UpdateListItem
    {
        class Program
        {
            static void Main(string[] args)
            {
                string siteUrl = "http://servername:39130/";
                ClientContext clientContext = new ClientContext(siteUrl);
                List oList = clientContext.Web.Lists.GetByTitle("Test");
                ListItem oListItem = oList.GetItemById(5);         
                oListItem.DeleteObject();
                clientContext.ExecuteQuery();
            }
        }
    }
  • Hit F5.
  • Go to the SharePoint list "Test" and you could see a new item is added.

Up Next
    Ebook Download
    View all
    Learn
    View all