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 the Client Object Model.

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

Create List Item

1. Go to Visual Studio 2010.
2. Go to File => New => Project.
3. Select Console Application and name it as CreateListItem.
4. Click Add.
5. 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();
           }
       }
   }

6. Hit F5.
7. Go to the SharePoint list "Test" and you can see a new item is added.
   

Update List Item

1. Go to Visual Studio 2010.
2. Go to File => New => Project.
3. Select Console Application and name it as UpdateListItem.
4. Click Add.
5. 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();
           }
       }
   }

6. Hit F5.
7. Go to the SharePoint list "Test" and you can see an item is updated.

Delete List Item

1. Go to Visual Studio 2010.
2. Go to File => New => Project.
3. Select Console Application and name it as DeleteListItem.
4. Click Add.
5. 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();
           }
       }
   }

6. Hit F5.
7. Go to the SharePoint list "Test" and you can see a new item is added.