sharepoint 中对splist的基本操作（新增item,修改，删除）

一、向list中新增数据

 

using (SPSite site = new SPSite(strDashListRoot)) //strDashListRoot:sharepoint站点地址

{

using (SPWeb web = site.OpenWeb())

{

web.AllowUnsafeUpdates = true;

SPList list = web.Lists["FY 09 Sales"]; // listName

SPListItem Item = list.Items.Add();

Item["Title"] = productName; //listfiled

Item["ProductNum"] = productNumber;listfiled

Item["Sales"] = FY08Sales;//listfiled

Item.Update(); //更新保存数据

web.AllowUnsafeUpdates = false;

}

}

 

二、修改记录

using (SPSite site = new SPSite(strDashListRoot)) //strDashListRoot:sharepoint站点地址

{

using (SPWeb web = site.OpenWeb())

{

SPList list = web.Lists["FY 09 Sales"]; // listName

 SPQuery query = new SPQuery();

 query.Query = @"
                            <Where>
                               <Eq>
                                <FieldRef Name=Title/>
                                <Value Type='Text'>computer</Value>
                               </Eq>
                            </Where>
                          ";

 SPListItemCollection listcollection = mylist.GetItems(query); //返回查询结果

SPListItem item;

if(listcollection.Count > 0 )
      {

web.AllowUnsafeUpdates = true;

          for (int i = listcollection.Count - 1; i >= 0; i--)
             {
              item = listcollection[i];
              // make some changes to this item
               item["ProductNum"]="11-00-22"//更新字段
                }
         item.Update();

web.AllowUnsafeUpdates = false;
      }

}

}

 

三、删除记录

 

using (SPSite site = new SPSite(strDashListRoot)) //strDashListRoot:sharepoint站点地址

{

using (SPWeb web = site.OpenWeb())

{

SPList list = web.Lists["FY 09 Sales"]; // listName

 SPQuery query = new SPQuery();

 query.Query = @"
                            <Where>
                               <Eq>
                                <FieldRef Name=‘Title’/>
                                <Value Type='Text'>computer</Value>
                               </Eq>
                            </Where>
                          ";

 SPListItemCollection listcollection = mylist.GetItems(query); //返回查询结果

if(listcollection.Count > 0 )
      {

          //删除所有
         for (int i = listcollection.Count - 1; i >= 0; i--)
         {
           listcollection[i].Delete();
          }

 web.Update();
      }

}

}