Musings on SharePoint, Adobe CQ, ECM, and more…

Programmatically Delete all items from a SharePoint List

At times we want to delete all the items from a SharePoint List. Here are some excellent solutions to delete all the SharePoint list items efficiently.

Below is the PurgeList method from Keith Richie which does an excellent job of Purging items in a list. Here is a CodePlex tool and  one more solution to deal with the same problem.

/// <summary>
/// Purges items and folders from a list
/// Define WSSV3 to remove list folders
/// </summary>
/// The SPList you want to
/// purge items from
private static void PurgeList(SPList list)
{
Console.WriteLine("Purging list: " + list.Title);
Console.WriteLine("Base Type: " + list.BaseType.ToString());

// ===========================================================
// list.ItemCount returns a count that includes all items
// "AND" folders.
// You can't use list.Items.DeleteItemById() to remove a
// folder
// ===========================================================
System.Collections.Hashtable hItems =
new System.Collections.Hashtable(list.ItemCount);

// ===========================================================
// SPList.Items returns all list items in the entire list
// regardless of folder containment
// Note, just because list.ItemCount includes folders,
// list.Items does not.
// ===========================================================
foreach (SPListItem item in list.Items)
hItems.Add(item.ID,null);

// Remove the list items
foreach (int ID in hItems.Keys)
list.Items.DeleteItemById(ID);
// Clear the hashtable
hItems.Clear();
// ===========================================================
// SPList.Folders returns all folder items in the entire list
// regardless of parent folder containment
// ===========================================================
foreach (SPListItem item in list.Folders)
hItems.Add(item.ID,null);

// Remove the folder items
foreach (int ID in hItems.Keys)
{
list.Folders.DeleteItemById(ID);
}
}

Praveen Modi

Praveen works at Razorfish which is one of the largest digital advertising agency in the world. His mantra for life is "You are never too old to set another goal or to dream a new dream". He lives in sunny Austin, TX with his beautiful wife Nidhi and son Aariv.

9 Comments

  1. pankaj

    hi,
    i need to delete list from sharepoint using asp.net gridview.please help me if possible.

  2. pankaj

    Thanks a lot.Though i m already done with it.will try this too.

  3. sanjeev

    Hello i want to upadate all the items of a column.I need to apply one formula for upadating the items.suppose column SUM need to be upadated based on other value of particular item.like A is one column and B is one Column the sum column should be upadated based on A and B

  4. Mohammed Al-Shobani

    thanks alot it helped me 🙂

  5. Praveen Modi

    @Mohammed Al-Shobani – Glad that it was help to you.

    -Praveen

  6. Praveen Modi

    Sasi Reddy – Thanks for sharing the link to your blog.

    I checked your code and seems that its for deleting the list and not for purging the list items. I’m missing something?

    -Praveen

Leave a Reply

This blog is kept spam free by WP-SpamFree.