InfoPath Dev

Hi all
I want to get the data from a SharePoint List.Is there any web service from SharePoint can do the job?
For example, I want to get the data from a SharePoint List,and then put them into a datatable(coding by C#)

How can I do this?

Hi

depending on what exactly you want to achieve you can approach this in two ways:

if you just want to retrieve meta data from lists (eg tasks or similar) to populate a dropdown in a form, you can add the list as a secondary data source ( tools > data connections > add > recieve data > sharepoint library or list).

These data can then be used either in the gui or programmatically using XDocument.DataAdapters("YourListName").DOM.xml (DataObject of type SharepointListAdapter )

If this isnt enough (for example if you need to access the documents in a list as binary arrays) you can use the standard sharepoint Lists web service methods. The one you need is most likely GetListItems.http://yourPortal/yoursubarea/_vti_bin/lists.asmx <- notice that the vti_bin must be called from the site or area where the list is located!

more info:
http://msdn.microsoft.com/library/en-us/spptsdk/html/soapmlistsgetlistitems.asp

hth
//AndersR

//AndersR

Hi AndersR
I think the first way is good for me,but I want to know How can I fetch all the data from the a list,and then put them in a datatable.
Can you give me example about this?

Hi V-luchen and welcome to our forum!
Matt Faus's new HowTo will help you. Should be release today or tomorrow. Go tohttp://www.infopathdev.com and look for it. It's titled "Add SharePoint List Items with InfoPath". Cheers!

Patrick Halstead [InfoPath MVP]
InfoPathDev

Thanks for your help,
I want to an example,how to retrieve all items of SPS list at one time(basic C# code,don't use SPS web service)

Hi again,

I recommend reading the SPPT or WSS SDK or check the article section of MSDN for relevant info.

In basic what you need to do is
1. in VS.NET add a web reference pointing tohttp://yourportal/subarea/_vti_bin/lists.asmx
2. use the method GetListItems("listname/listguid",null,null,null,null,null) <- here you can define special views, queries, fields, rows and options
3. what youll get back is an XML node containing a soap envelope wich you can parse/query as needed using xpath.

(untested from the top of my head)
XmlNode returnXml = myListService.GetListItems("myList","myView",null,null,null,null);
System.Diagnostics.Debug.WriteLine(returnXml.xml,"returnXml");

hth
//AndersR

links to MSDN SPPT articles and SDK:
http://msdn.microsoft.com/library/?url=/library/en-us/odc_2003_ta/html/odc_landsppt03_ta.asp?frame=true


//AndersR

Hi AndersR:
Thanks for your help!
I can do this by using SPS web service
Now,I want to do it by using sencondary data connection
My secondary data connection was not setup to “automatically retrieve data when the form is opened”

The secondary data connection is setup when I click a button. My code is as follows:

[InfoPathEventHandler(MatchPath="Recieve", EventType=InfoPathEventType.OnClick)]

public void Recieve_OnClick(DocActionEvent e)

{

thisXDocument.DataObjects["ProjectsStatus"].Query();//”ProjectsStatus” is my secondary data connection name

}

NOW, I want to retrieve all the data of the SPS list, and put them in a datatable.

How can do this by using C# code?

Can you give me a sample about use
"programmatically using XDocument.DataAdapters("YourListName").DOM.xml (DataObject of type SharepointListAdapter )
"

Hi

i dont have specific code for that, but ill give you a hint (untested):

youll need a

XmlDocument document = new XmlDocument();
document.LoadXml(yourDataAdapter.DOM.xml); //there could be more clever methods to do this so check DataAdapter DOM property
//also you should check for errors in return xml. i think i recall its in "//sp:errorCode"

//Before you can select nodelists from XML dom, you need to add namespaces from return xml in your document. below i just add them all since i dont recall wich is needed:

//define SPS namespaces
const string SharePointNamespacePrefix = "sp";
const string SharePointNamespaceURI = "http://schemas.microsoft.com/sharepoint/soap/";
const string ListItemsNamespacePrefix = "z";
const string ListItemsNamespaceURI = "#RowsetSchema";
const string PictureLibrariesNamespacePrefix = "y";
const string PictureLibrariesNamespaceURI = "http://schemas.microsoft.com/sharepoint/soap/ois/";
const string WebPartsNamespacePrefix = "w";
const string WebPartsNamespaceURI = "http://schemas.microsoft.com/WebPart/v2";
const string DirectoryNamespacePrefix = "d";
const string DirectoryNamespaceURI = "http://schemas.microsoft.com/sharepoint/soap/directory/";
const string RowSetNamespaceURI = "urn:schemas-microsoft-com:rowset";
const string RowSetNamespacePrefix = "rs";

// associate with the xmlns namespaces
XmlNamespaceManager nsmgr = new XmlNamespaceManager(document.NameTable);
nsmgr.AddNamespace(SharePointNamespacePrefix,SharePointNamespaceURI);
nsmgr.AddNamespace(ListItemsNamespacePrefix,ListItemsNamespaceURI);
nsmgr.AddNamespace(PictureLibrariesNamespacePrefix,PictureLibrariesNamespaceURI);
nsmgr.AddNamespace(WebPartsNamespacePrefix,WebPartsNamespaceURI);
nsmgr.AddNamespace(DirectoryNamespacePrefix,DirectoryNamespaceURI);

//now select the nodelist you want to iterate
XmlNodeList listItems = document.SelectNodes("//rs:data",nsmgr);//im not sure about the return xml syntax but think its rs:data

for ( int c=0; c < listItems.Count; c++ )
{
//here you add data to your dropdown or whatever in InfoPath
}

hope this intermistic code sample helps -anyways its all i have time for ;-)

//AndersR

//AndersR

Hi,

 Go through this article you will get the one file and if you change in your search value contains then you can use the instead on using <Eq> use <Contains>. It will give the node list which contains the value of given search value.

http://www.infopathdev.com/blogs/agni/archive/2006/05/15/Query-for-Items-in-SharePoint-Form-Library-Using-GetListItems-Web-Method.aspx