How to delete a large number of data in SharePoint for List when refreshing data?

最新推荐文章于 2025-12-01 21:00:22 发布

最新推荐文章于 2025-12-01 21:00:22 发布 · 109 阅读

文章标签：

#c#

本文介绍了一种使用C#和特定CAML格式批量快速删除SharePoint列表或文档库中大量项目的有效方法。此方法通过避免调用API实现更快的数据处理速度。

Preface

Recently thequestion was asked in the newsgroups about deleting a large number of itemsfrom SharePoint (WSS) in the fastest way. I had, inone ifmyprojects,needed to remove a large number of items from SharePoint and the best way Ifound were to use 'ProcessBatchData' as it avoided the API and was considerablyfaster.

1. Delete Common List

1.1 CAML format

<?xml version="1.0"encoding="UTF-8"?>
<Batch>
<Method>
<SetListScope="Request">3010913d-9373-44ec-a799-0bf564cb0d66</SetList>
<SetVar Name="Cmd">DELETE</SetVar>
<SetVar Name="ID">1</SetVar>
</Method>
</Batch>

1.2 C# source code implementation

StringBuilder sbDelete = new StringBuilder();
sbDelete.Append("<?xml version=\"1.0\"encoding=\"UTF-8\"?><Batch>");

foreach (SPListItem item in CurrentList.Items)
{
sbDelete.Append("<Method>");
sbDelete.Append("<SetListScope=\"Request\">" + CurrentList.ID +"</SetList>");
sbDelete.Append("<SetVarName=\"ID\">" + Convert.ToString(item.ID) +"</SetVar>");
sbDelete.Append("<SetVarName=\"Cmd\">Delete</SetVar>");
sbDelete.Append("</Method>");
}

sbDelete.Append("</Batch>");

try
{
SPContext.Current.Site.RootWeb.ProcessBatchData(sbDelete.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Delete failed: " +ex.Message);
throw;
}

2. Delete Documentlibrary list

2.1 CAML （Collaborative Application Markup Languageformat

<?xml version="1.0"encoding="UTF-8"?>
<Batch>
<Method ID='1' Cmd='Delete'>
<Field Name='ID'>1</Field>
<Field Name='FileRef'>http://basesmcdev/sites/tester1/myfile.bmp</Field>
</Method>
</Batch>

2.2 C# source code implementation

SPSecurity.RunWithElevatedPrivileges(delegate()
{
using(SPSitesite=newSPSite("http://virus/sites/intranet"))
{

using(SPWebweb=site.OpenWeb("team"))
{
site.AllowUnsafeUpdates=true;
web.AllowUnsafeUpdates=true;

SPListlist=web.Lists["documentExample"];
StringBuildersbDelete=newStringBuilder();
sbDelete.Append("<?xmlversion=\"1.0\"encoding=\"UTF-8\"?><Batch>");

foreach(SPListItemiteminlist.Items)
{
sbDelete.Append("<Method>");
sbDelete.Append("<SetListScope=\"Request\">"+list.ID+"</SetList>");
sbDelete.Append("<SetVarName=\"ID\">"+Convert.ToString(item.ID)+"</SetVar>");
sbDelete.Append("<SetVarName=\"Cmd\">Delete</SetVar>");
sbDelete.Append("<SetVarName=\"owsfileref\">"+item.GetFormattedValue("FileRef")+"</SetVar>");
sbDelete.Append("</Method>");
}

sbDelete.Append("</Batch>");

try
{
Console.WriteLine(web.ProcessBatchData(sbDelete.ToString()));
}
catch
{

throw;
}
site.AllowUnsafeUpdates=false;
web.AllowUnsafeUpdates=false;
}
}
});