Wednesday, 9 October 2013

How to Create/Update/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:111/";
            ClientContext clientContext = new ClientContext(siteUrl);
            List oList = clientContext.Web.Lists.GetByTitle("Test");
            ListItemCreationInformation listCreationInformation = newListItemCreationInformation();
            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.

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:111/";
            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:111/";
            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.

No comments:

Post a Comment