Microsoft SharePoint 2007 offers the best portal, collaboration and content management for an enterprise. Teams using a SharePoint portal can collaborate using Document libraries, lists, picture libraries, discussion boards, surveys, etc. Amongst those I mentioned, document libraries are the most used allowing a team to share documents(of Office 2003/07) and stay synchronized with the latest one allowing real-time collaboration. These lists and libraries can be accessed programmatically in C# using the SharePoint Object Model(SOM). Though SOM can also be used to access different entities like Workflows, Site Features, etc; in this post I'll be focusing on accessing lists/libraries using SOM.
Following will give you a quick gist of how we can access a SharePoint list present in a SharePoint site based on the hierarchy.
In my following example, I’m trying to access images in a Picture Library named ‘PictureLibrary1’ present at the URL http://ram2003svr:8080/PictureLibrary1. The List Items existing in the ‘PictureLIbrary1’ are ‘Name’, ‘Title’. I have used an ASP.Net website for this example, so make sure you have the following three libraries added as a reference to your project.
• Microsoft.SharePoint
• Microsoft.SharePoint.Security
• Microsoft.SharePoint.intl
You can copy the DLL’s from your GAC using this link Here.
CODE Snippet:
Following will give you a quick gist of how we can access a SharePoint list present in a SharePoint site based on the hierarchy.
| Hierarchy | Class |
• SharePoint Site Collection (i.e. top-level or parent site) | SPSite |
• SharePoint Site (i.e. target or sub-site) | SPWeb |
• SharePoint List under the target site | SPList |
• List Items in the List | SPListItem |
In my following example, I’m trying to access images in a Picture Library named ‘PictureLibrary1’ present at the URL http://ram2003svr:8080/PictureLibrary1. The List Items existing in the ‘PictureLIbrary1’ are ‘Name’, ‘Title’. I have used an ASP.Net website for this example, so make sure you have the following three libraries added as a reference to your project.
• Microsoft.SharePoint
• Microsoft.SharePoint.Security
• Microsoft.SharePoint.intl
You can copy the DLL’s from your GAC using this link Here.
CODE Snippet:
- using System;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.HtmlControls;
- using System.Web.UI.WebControls;
- using Microsoft.SharePoint;
- using Microsoft.SharePoint.WebControls;
- using Microsoft.SharePoint.WebPartPages;
- public partial class Image_Library_Webpart_Default : System.Web.UI.Page
- {
- /*
- We're trying to access a 'Picture Library' located at below URL.
- URL: http://ram2003svr:8080/PictureLibrary1
- The below process is similar for accessing a Document Library or Lists like 'Tasks','Announcements', etc.
- */
- protected void Page_Load(object sender, EventArgs e)
- {
- //SPSecurity.RunWithElevatedPrivileges() is mandatory since a user might not have sufficient privileges to access this list.
- SPSecurity.RunWithElevatedPrivileges(delegate()
- {
- //SPSite returns the Site Collection object for the URL
- using (SPSite spSite = new SPSite("http://ram2003svr:8080/"))
- {
- /* Returns the object of the site (takes relative site URL after the top-site) which we want to access.
- In this case, it is BLANK since the site is a top-level site */
- using (SPWeb spWeb = spSite.AllWebs[""])
- {
- //Returns the List object for the Picture Library. Takes the List Name as an argument.
- SPList spList = spWeb.Lists["PictureLibrary1"];
- //Iterate through the SPListItems in the List.
- foreach (SPListItem spListItem in spList.Items)
- {
- //You can access the various attributes in the list like 'Name','Title'
- Response.Write("Name of image file : " + spListItem["Name"].ToString() + "<br /><br />");
- Response.Write("Title of image file : " + spListItem["Title"].ToString() + "<br /><br />");
- Response.Write("URL of image file : " + "http://ram2003svr:8080/PictureLibrary1/" + spListItem["Name"].ToString() + "<br /><br />");
- }
- }
- }
- });
- }
- }
You can download the source code Here: |  |
