如何从asp.net站点的共享点列表中读取数据 [英] how read data from sharepoint list in asp.net site

问题描述

我在共享点列表中有一些数据，我想从列表中读取特定数据并在我的asp.net网站上显示它们，我该怎么办?

I have some data in sharepoint lists,I want to read particular data from the list and show them in my asp.net website,what should i do ?

推荐答案

步骤1:-添加要访问列表的Web参考，这些参考通过位于_vt_bin文件夹中的服务公开.

步骤2:-创建Webreference_name.Lists的对象obj = new Webreference_name.Lists()
obj.Credentials = System.Net.CredentialCache.DefaultCredentials;

步骤3:-字符串listName ="list_name";
字符串viewName =";
字符串rowLimit ="150";
XmlElement query = xmlDoc.CreateElement("Query");
XmlElement viewFields = xmlDoc.CreateElement("ViewFields");
XmlElement queryOptions = xmlDoc.CreateElement("QueryOptions");

步骤4:-

Step 1:-Add a web reference of the list that you want to access the lists are exposed through services that reside in _vt_bin folder.

step 2:-Create object of Webreference_name.Lists obj=new Webreference_name.Lists()
obj.Credentials = System.Net.CredentialCache.DefaultCredentials;

step 3:- string listName = "list_name";
string viewName = "";
string rowLimit = "150";
XmlElement query = xmlDoc.CreateElement("Query");
XmlElement viewFields = xmlDoc.CreateElement("ViewFields");
XmlElement queryOptions = xmlDoc.CreateElement("QueryOptions");

step 4:-

query.InnerXml = "<Where><Gt><FieldRef Name=\"ID\" />" +
                    "<Value Type=\"Counter\">1</Value></Gt></Where>";

StringBuilder fieldRef = new StringBuilder();
fieldRef.Append("<FieldRef Name=\"Field_Name\" />");

viewFields.InnerXml = fieldRef.ToString();



               queryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>";


               System.Xml.XmlNode nodeListItems =
                   objListService.GetListItems
                   (listName, viewName, query, viewFields, rowLimit, queryOptions, null);

XmlDataDocument xmlDocResult =新的XmlDataDocument();
xmlDocResult.LoadXml(nodeListItems.InnerXml);
XmlNodeList行= xmlDocResult.GetElementsByTagName("z:row"); //以行为基础从xmlnodelist获取数据
foreach(行中的XmlNode attr)
{
//逻辑
}

XmlDataDocument xmlDocResult = new XmlDataDocument();
xmlDocResult.LoadXml(nodeListItems.InnerXml);
XmlNodeList rows = xmlDocResult.GetElementsByTagName("z:row"); //fetching data from xmlnodelist on row basis
foreach(XmlNode attr in rows)
{
//logic
}

http://msdn .microsoft.com/en-us/library/hh134614(v = office.14).aspx [

http://msdn.microsoft.com/en-us/library/hh134614(v=office.14).aspx[^]
this link helped me !

我发现这是最简单的方法.注意:它要求将Microsoft.sharepoint.dll添加到您的项目参考中

使用(SPSite网站=新的SPSite("http://abc.com/project/"))
{
使用(SPWeb网站= site.OpenWeb())
{
SPList列表= web.Lists ["Country"];
ddlCountry.DataSource = list.Items;
ddlCountry.DataValueField =标题";
ddlCountry.DataTextField =标题";
ddlCountry.DataBind();
}
}

I found this one as the Easiest approach. NOTE: it requires Microsoft.sharepoint.dll to be added in your project reference

using (SPSite site = new SPSite("http://abc.com/project/"))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists["Country"];
ddlCountry.DataSource = list.Items;
ddlCountry.DataValueField = "Title";
ddlCountry.DataTextField = "Title";
ddlCountry.DataBind();
}
}

这篇关于如何从asp.net站点的共享点列表中读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！