在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
添加数据
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();
删除数据
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 website web.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 { }
|
2023-10-27
2022-08-15
2022-08-17
2022-09-23
2022-08-13
请发表评论