Wednesday, December 1, 2010

To delete all the list items in a SharePoint list

  1. private void DeleteAllItemsUsingBatch()  
  2.     {  
  3.         using (SPSite site = new SPSite("http://mySharePointServer"))  
  4.         {  
  5.             SPWeb web = site.OpenWeb("/");  
  6.             SPList list = web.Lists["Links"];  
  7.             StringBuilder sb = new StringBuilder();  
  8.             sb.Append("<batch>");  
  9.             string batchCommand = "<method><setlist scope=\"Request\">" + list.ID + "</setlist><setvar name=\"ID\">{0}</setvar><setvar name=\"Cmd\">DELETE</setvar></method>";  
  10.             foreach (SPListItem item in list.Items)  
  11.             {  
  12.                 sb.Append(string.Format(batchCommand, item.ID.ToString()));  
  13.             }  
  14.             sb.Append("</batch>");  
  15.             web.AllowUnsafeUpdates = true;  
  16.             site.RootWeb.ProcessBatchData(sb.ToString());  
  17.             web.AllowUnsafeUpdates = false;  
  18.             web.Close();  
  19.         }  
  20.     } 

No comments:

Post a Comment