C#操作SharePoint列表
============================================
using Microsoft.SharePoint;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPWeb site = SPControl.GetContextWeb(Context);
SPListItemCollection items = site.Lists["ListName"].Items;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPListItem item = items.Add();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
item["Field_1"] = OneValue;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
item["Field_2"] = TwoValue;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
item.Update();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
删除sharepoint list数据
=============================================
using Microsoft.SharePoint;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPWeb site = SPControl.GetContextWeb(Context);
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPListItemCollection items = site.Lists["ListName"].Items;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
items[0].Delete();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
上传文件到sharepoint
=============================================
using System.IO;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using Microsoft.SharePoint;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
if( htmlInputFile1.PostedFile != null )
{
SPWeb site = new SPSite(destinationURL).OpenWeb();
Stream stream = htmlInputFile1.PostedFile.InputStream;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
byte[] buffer = new bytes[stream.Length];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
stream.Read(buffer, 0, (int) stream.Length);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
stream.Close();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
site.Files.Add(destinationURL, buffer);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
查询记录及更新数据
===============================================
using Microsoft.SharePoint;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPWeb web = new SPSite("http://nick").OpenWeb("test"); //Open website
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
web.AllowUnsafeUpdates = true;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPList list = web.Lists["ListName"];
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SPQuery query = new SPQuery();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
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>";
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
query.RowLimit = 10;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
//查询
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();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
listItem.Update();
}
}
else
{ //将数据记录添加进sharepoint
SPListItem addlist = List.Items.Add();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
addlist["Filed_1"] = TextBox1.Text.ToString();
addlist["Filed_2"] = TextBox2.Text.ToString();
addlist["Filed_3"] = TextBox3.Text.ToString();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
addlist.Update();
}
}
catch
{
![](https://www.cnblogs.com/Images/dot.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)