C# 对sharepoint 列表的一些基本操作,包括添加/删除/查询/上传文件给sharepoint list添加数据

比眉伴天荒 2022-04-03 08:43 270阅读 0赞

操作List前请设置SPWeb的allowUnsafeUpdate = true;

var site = new SPSite("http://stormwind:10000").RootWeb;
    
    site.AllowUnsafeUpdates = true;

添加sharepoint list数据

============================================  
![None.gif][]using Microsoft.SharePoint;  
![None.gif][]  
![None.gif][]SPWeb site = SPControl.GetContextWeb(Context);   
![None.gif][]SPListItemCollection items = site.Lists\["ListName"\].Items;  
![None.gif][]  
![None.gif][]SPListItem item = items.Add();   
![None.gif][]  
![None.gif][]item\["Field\_1"\] = OneValue;  
![None.gif][]  
![None.gif][]item\["Field\_2"\] = TwoValue;  
![None.gif][]  
![None.gif][]item.Update();  
![None.gif][]  
![None.gif][]  
![None.gif][]删除sharepoint list数据  
![None.gif][]=============================================  
![None.gif][]using Microsoft.SharePoint;  
![None.gif][]  
![None.gif][]SPWeb site = SPControl.GetContextWeb(Context);  
![None.gif][]  
![None.gif][]SPListItemCollection items = site.Lists\["ListName"\].Items;  
![None.gif][]  
![None.gif][]items\[0\].Delete();  
![None.gif][]  
![None.gif][]  
![None.gif][]上传文件到sharepoint  
![None.gif][]=============================================  
![None.gif][]using System.IO;  
![None.gif][]  
![None.gif][]using Microsoft.SharePoint;  
![None.gif][]  
![None.gif][]if( htmlInputFile1.PostedFile != null )  
![ExpandedBlockStart.gif][]\{  
![InBlock.gif][]          SPWeb site = new SPSite(destinationURL).OpenWeb();   
![InBlock.gif][]          Stream stream = htmlInputFile1.PostedFile.InputStream;  
![InBlock.gif][]  
![InBlock.gif][]          byte\[\] buffer = new bytes\[stream.Length\];  
![InBlock.gif][]  
![InBlock.gif][]          stream.Read(buffer, 0, (int) stream.Length);  
![InBlock.gif][]  
![InBlock.gif][]          stream.Close();  
![InBlock.gif][]  
![InBlock.gif][]          site.Files.Add(destinationURL, buffer);  
![ExpandedBlockEnd.gif][]\}  
![None.gif][]  
![None.gif][]查询记录及更新数据  
![None.gif][]===============================================  
![None.gif][]using Microsoft.SharePoint;  
![None.gif][]  
![None.gif][]SPWeb web = new SPSite("http://nick").OpenWeb("test");  //Open website  
![None.gif][]  
![None.gif][]web.AllowUnsafeUpdates = true;  
![None.gif][]  
![None.gif][]SPList list = web.Lists\["ListName"\];  
![None.gif][]  
![None.gif][]SPQuery query = new SPQuery();  
![None.gif][]  
![None.gif][]query.Query = "<Where>"+  
![None.gif][]          "<And><And>"+  
![None.gif][]          "<Eq><FieldRef Name=/"Filed\_1/"/><Value Type=/"Text/">Test</Value></Eq>" +  
![None.gif][]          "<Eq><FieldRef Name=/"Filed\_2/"/><Value Type=/"Text/">" + (string)OneValue + "</Value></Eq>" +  
![None.gif][]          "</And>"+  
![None.gif][]          "<Eq><FieldRef Name=/"Filed\_3/"/><Value Type=/"Text/">" + (string)TwoValue + "</Value></Eq>" +  
![None.gif][]          "</And>"+  
![None.gif][]          "</Where>";  
![None.gif][]  
![None.gif][]query.RowLimit = 10;  
![None.gif][]  
![None.gif][]//查询  
![None.gif][]SPListItemCollection items = list.GetItems(query);  
![None.gif][]try  
![ExpandedBlockStart.gif][]\{  
![InBlock.gif][]  if (Items.Count != 0)  
![ExpandedSubBlockStart.gif][]  \{  
![InBlock.gif][]     //更新sharepoint list 数据  
![InBlock.gif][]     foreach (SPListItem list in listItems)  
![ExpandedSubBlockStart.gif][]     \{  
![InBlock.gif][]         list\["Filed\_1"\] = TextBox1.text.ToString();  
![InBlock.gif][]         list\["Filed\_2"\] = TextBox2.text.ToString();  
![InBlock.gif][]         list\["Filed\_3"\] = TextBox3.text.ToString();  
![InBlock.gif][]  
![InBlock.gif][]         listItem.Update();  
![ExpandedSubBlockEnd.gif][]     \}                         
![ExpandedSubBlockEnd.gif][]  \}  
![InBlock.gif][]  else  
![ExpandedSubBlockStart.gif][]  \{   //将数据记录添加进sharepoint  
![InBlock.gif][]      SPListItem addlist = List.Items.Add();  
![InBlock.gif][]  
![InBlock.gif][]      addlist\["Filed\_1"\] = TextBox1.Text.ToString();  
![InBlock.gif][]      addlist\["Filed\_2"\] = TextBox2.Text.ToString();  
![InBlock.gif][]      addlist\["Filed\_3"\] = TextBox3.Text.ToString();  
![InBlock.gif][]  
![InBlock.gif][]      addlist.Update();  
![ExpandedSubBlockEnd.gif][]  \}  
![ExpandedBlockEnd.gif][]\}  
![None.gif][]catch  
![ExpandedBlockStart.gif][]\{  
![InBlock.gif][] ![dot.gif][]  
![ExpandedBlockEnd.gif][]\}

时间会记录下一切。

网站建设，SEO，软件开发 请访问：http://www.haipengsoft.com 【海鹏网络】

[None.gif]: /images/20220403/1aa8bb30b3ca420aade4b2e04b578d3e.png
[ExpandedBlockStart.gif]: /images/20220403/006e8d0154804b08937848f6aea593c8.png
[InBlock.gif]: /images/20220403/820d405eb0644757827e05a1b028d2ca.png
[ExpandedBlockEnd.gif]: /images/20220403/bc3323cc7d6448009ff9217f2b1065dd.png
[ExpandedSubBlockStart.gif]: /images/20220403/103d42168066416782ab733b04061863.png
[ExpandedSubBlockEnd.gif]: /images/20220403/c7b5e11678704d44970a7c676cf76c73.png
[dot.gif]: /images/20220403/cc95fa99c097487c9f2605fd036a2937.png