StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8929078
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2012-01-19T15:53:03.407
FavoriteCount
0
LastActivityDate
2012-01-23T13:00:44.597
LastEditDate
2012-01-23T13:00:44.597
LastEditorUserId
1158522
OwnerUserId
1158522
ParentId
8899240
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<h3>Use SharePoint web services instead of the object model</h3> If you need to work with a remote sharepoint server, you can use the web services instead of the object model. Assuming you have added a reference to the lists webservice (/_vti_bin/lists.asmx), and called it "Lists", you can get a list of visible lists like this: <pre><code>Lists.Lists proxy = new Lists.Lists(); // Use logged on users credentials to authenticate with SharePoint proxy.Credentials = CredentialCache.DefaultNetworkCredentials; XmlNode listCollection = proxy.GetListCollection(); foreach (XmlNode node in listCollection.ChildNodes) { bool hidden = bool.Parse(node.Attributes["Hidden"].Value); if (!hidden) { Console.WriteLine(node.Attributes["Title"].Value); } } </code></pre> You can find more details on the lists web service here: <a href="http://msdn.microsoft.com/en-us/library/lists.lists_methods.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/lists.lists_methods.aspx</a> Most of the things you can do with object model code can also be achieved using web services. <h3>Adding a reference to the web service</h3> To add a web reference in VS2010: <ol> <li>Right click on the project node in Solution Explorer, and select Add Service Reference</li> <li>In the Add Service Reference dialog, click on Advanced...</li> <li>In the Service Reference Settings dialog, click on Add Web Reference...</li> <li>In the Add Web Reference dialog: a. For Url, enter the site collection url followed by _vti_bin/lists.asmx. For example: <a href="http://sharepoint/sites/mySiteCollection/_vti_bin/lists.asmx">http://sharepoint/sites/mySiteCollection/_vti_bin/lists.asmx</a> b. For Web reference name, enter Lists c. Click Add Reference</li> </ol> The reference will now be added to the project, and you can use the code above to access it. To get lists from sub-site, change the services URL property to point to the web service for that sub-site by adding _vti_bin/lists.asmx to the sub-site's url as above.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBogus (?) File Not Found error when trying to do client SharePoint coding
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USsga101
UserOwnerUserId
1. USsga101
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POBogus (?) File Not Found error when trying to do client SharePoint coding
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.