Tuesday 3 February 2015

Add, Update and Delete List Items Programmatically in Sharepoint

Using Microsoft Sharepoint APIs we can easily Add, Update and Delete list items programmatically. Provided below is a code snippet in C# .Net demonstrating all the three operations..

using (SPSite oSPsite = new SPSite("http://website url/"))
using (SPWeb oSPWeb = oSPsite.OpenWeb())
            oSPWeb.AllowUnsafeUpdates = true;

            // Fetch the List
            SPList list = oSPWeb.Lists.TryGetList("MyList");
            if(list !=null && list.Items.Count>0)
//Add a new item in the List
SPListItem itemToAdd = list.Items.Add();
itemToAdd["Title"] = "Test Title";
itemToAdd["Description"] = "Test Description";

// Get the Item ID
listItemId = itemToAdd.ID;

// Update the List item by ID
SPListItem itemToUpdate = list.GetItemById(listItemId);
itemToUpdate["Description"] = "Changed Description";

// Delete List item
SPListItem itemToDelete = list.GetItemById(listItemId);
            oSPWeb.AllowUnsafeUpdates = false;

No comments:

Post a Comment