转载http://www.cnblogs.com/kivenhou/archive/2013/02/22/2921954.html
操作List前请设置SPWeb的allowUnsafeUpdate true;
var site new SPSite("http://stormwind:10000").RootWeb;site.AllowUnsafeUpdates true;
添加sharepoint list数据
using Microsoft.SharePoint;SPWeb site SPControl.GetContextWeb(Context); SPListItemCollection items site.Lists["ListName"].Items;SPListItem item items.Add(); item["Field_1"] OneValue;item["Field_2"] TwoValue;item.Update();删除sharepoint list数据using Microsoft.SharePoint;SPWeb site SPControl.GetContextWeb(Context);SPListItemCollection items site.Lists["ListName"].Items;items[0].Delete();上传文件到sharepointusing System.IO;using Microsoft.SharePoint;if( htmlInputFile1.PostedFile ! null )
{
SPWeb site new SPSite(destinationURL).OpenWeb(); Stream stream htmlInputFile1.PostedFile.InputStream; byte[] buffer new bytes[stream.Length]; stream.Read(buffer, 0, (int) stream.Length); stream.Close(); site.Files.Add(destinationURL, buffer);
}查询记录及更新数据using Microsoft.SharePoint;SPWeb web new SPSite("http://nick").OpenWeb("test"); //Open websiteweb.AllowUnsafeUpdates true;SPList list web.Lists["ListName"];SPQuery query new SPQuery();query.Query "" "" "Test" "" (string)OneValue "" "" "" (string)TwoValue "" "" "";query.RowLimit 10;//查询SPListItemCollection items list.GetItems(query);try{ if (Items.Count ! 0)
{ //更新sharepoint list 数据 foreach (SPListItem list in listItems) { list["Filed_1"] TextBox1.text.ToString(); list["Filed_2"] TextBox2.text.ToString(); list["Filed_3"] TextBox3.text.ToString(); listItem.Update();
} } else { //将数据记录添加进sharepoint SPListItem addlist List.Items.Add(); addlist["Filed_1"] TextBox1.Text.ToString(); addlist["Filed_2"] TextBox2.Text.ToString(); addlist["Filed_3"] TextBox3.Text.ToString(); addlist.Update(); }}catch{ 
}