C# 对sharepoint 列表的一些基本操作,包括添加删除查询上传文件给sharepoint list添加数据
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
1.============================================
ing Microsoft.SharePoint;
3.
4.SPWeb site = SPControl.GetContextWeb(Context);
5.SPListItemCollection items = site.Lists["ListName"].Items;
6.
7.SPListItem item = items.Add();
8.
9.item["Field_1"] = OneValue;
10.
11.item["Field_2"] = TwoValue;
12.
13.item.Update();
14.
15.
16.删除sharepoint list数据
17.=============================================
ing Microsoft.SharePoint;
19.
20.SPWeb site = SPControl.GetContextWeb(Context);
21.
22.SPListItemCollection items = site.Lists["ListName"].Items;
23.
24.items[0].Delete();
25.
26.
27.上传文件到sharepoint
28.=============================================
ing System.IO;
30.
ing Microsoft.SharePoint;
32.
33.if( htmlInputFile1.PostedFile != null )
34.{
35.SPWeb site = new SPSite(destinationURL).OpenWeb();
36.Stream stream = htmlInputFile1.PostedFile.InputStream;
37.
38.byte[] buffer = new bytes[stream.Length];
39.
40.stream.Read(buffer, 0, (int) stream.Length);
41.
42.stream.Close();
43.
44.site.Files.Add(destinationURL, buffer);
45.}
46.
47.查询记录及更新数据
48.===============================================
ing Microsoft.SharePoint;
50.
51.SPWeb web = new SPSite("http://nick").OpenWeb("test"); //Open website
52.
53.web.AllowUnsafeUpdates = true;
54.
55.SPList list = web.Lists["ListName"];
56.
57.SPQuery query = new SPQuery();
58.
59.query.Query = "<Where>"+
60."<And><And>"+
61."<Eq><FieldRef Name=/"Filed_1/"/><Value Type=/"Text/">Test</Value></Eq>" +
62."<Eq><FieldRef Name=/"Filed_2/"/><Value Type=/"Text/">" + (string)OneValue +
"</Value></Eq>" +
63."</And>"+
64."<Eq><FieldRef Name=/"Filed_3/"/><Value Type=/"Text/">" + (string)TwoValue +
"</Value></Eq>" +
65."</And>"+
66."</Where>";
67.
68.query.RowLimit = 10;
69.
70.//查询
71.SPListItemCollection items = list.GetItems(query);
72.try
73.{
74.if (Items.Count != 0)
75.{
76.//更新sharepoint list 数据
77.foreach (SPListItem list in listItems)
78.{
79.list["Filed_1"] = TextBox1.text.ToString();
80.list["Filed_2"] = TextBox2.text.ToString();
81.list["Filed_3"] = TextBox3.text.ToString();
82.
83.listItem.Update();
84.}
85.}
86.else
87.{ //将数据记录添加进sharepoint
88.SPListItem addlist = List.Items.Add();
89.
90.addlist["Filed_1"] = TextBox1.Text.ToString();
91.addlist["Filed_2"] = TextBox2.Text.ToString();
92.addlist["Filed_3"] = TextBox3.Text.ToString();
93.
94.addlist.Update();
95.}
96.}
97.catch
98.{
99....
100.}。