转载: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();上传文件到sharepoint=============================================using 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 = "<Where>"+ "<And><And>"+ "<Eq><FieldRef Name=/"Filed_1/"/><Value Type=/"Text/">Test</Value></Eq>" + "<Eq><FieldRef Name=/"Filed_2/"/><Value Type=/"Text/">" + (string)OneValue + "</Value></Eq>" + "</And>"+ "<Eq><FieldRef Name=/"Filed_3/"/><Value Type=/"Text/">" + (string)TwoValue + "</Value></Eq>" + "</And>"+ "</Where>";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{ }