Click here to Skip to main content
15,179,246 members
Articles / Programming Languages / C#
Article
Posted 4 Feb 2009

Stats

72.7K views
443 downloads
14 bookmarked

How to create a MOSS 2007 web part that has an image and a link by using picture library

Rate me:
Please Sign up or sign in to vote.
4.33/5 (3 votes)
4 Feb 2009CPOL5 min read
This article gives step-by-step instructions on how to create the SharePoint Server 2007 web part that contains small images and links

Download ImgAndLink.zip - 430.75 KB

Introduction

Every team needs to track news and events. Basically news and events are presented
in a portal by a small image and a short description. If a user likes to read a whole article
she or he can click on a description and she or he will be redirected to an original source.
Administrator or a certain user has rights to update news and events information.

In MOSS 2007, administrator or user can create a Link list and add an Image column
to the list. Image URL is presented in this Image column. Using this list, administrator
or user can create a web part with an image and a link to the original source. We have
an image somewhere, for example in a picture library, and a link in the Link list. Every
time when a link is created it must be mapped to a picture in the picture library.
In this scenario we work with two libraries. It is obvious, that it is more productive
to work with just one library and without finding a URL for every image

Using the code

This article gives step-by-step instructions on how to create a SharePoint Server 2007 web
part that can be used to present news and events. The web part contains small images and
descriptions that are links to an original source. Images, descriptions, and links are taken from
a Picture Library.

Create a portal in which this web part will be present.

1. Click the Start button and choose Microsoft Office Server – SharePoint 3.0
Central Administration.

2. Click the Application Management on the left side and then click Create site
collection under SharePoint Site Management.

3. Give a title and description (I gave Team Information Portal), Web Site Address
(I gave tip), select Template (I selected Publishing – Collaboration Portal),
Primary Site Collection Administrator, and click the OK button.

4. Remember the portal URL (Picture 1.).

pic1.jpg

Picture 1.

5. Click View All Site Content and then click Create (Picture 2.)

pic2.jpg

Picture 2.

6. In the Create window click the Picture Library under the Libraries title (Picture 3.).

pic3.jpg

Picture 3

7. Print a Library Name in the Name text box. I called it “Pic Library”.

8. Print something in the description field, for example: “This picture Library
utilizes images, titles, and links to an original source”. Leave other settings
as default.

9. Click the Settings dropdown button and then click on the Picture Library
Settings (Picture 4.).

pic4.jpg

Picture 4.

10. In the Customize Pic Library window click the Create column under
the Columns heading (Picture 5.).

pic5.jpg

Picture 5

11. In the Create Column: Pic Library window, print a column name in the Column
name text box. I called it “Link”. Select Multiple Lines among the text radio
buttons. Fill out the Description text box. Leave other settings as default.

12. Click on the Pic Library link.

13. In the Pic Library window, click the Upload the dropdown button and then
click the Upload Multiple Pictures.

14. In the Upload Selected Pictures – Microsoft Office Picture Manager, select
pictures and then click the Upload and then Close button.

15. Click the Go Back to “Pic Library” link.

16. In the Pic Library window, click the All Pictures dropdown button,
select All Pictures, and then click the Details (Picture 6.).

pic6.jpg

Picture 6.

17. Click the dropdown button next to a picture name and then click
the Edit Properties (Picture 7.).

pic7.jpg

Picture 7.

18. Print a title or a description of external news or events in the Description
text box.

19. Print a URL of the original source in the link text box.

20. Repeat step 19 for all other images in the Pic Library.

21. Open Visual Studio 2005 and create a Web Part Project (File – New - Project).
I named it as ImgAndLink (Picture 8.).

pic8.jpg

Picture 8.

22. In the Solution Explore, right click References, and then on Add Reference (Picture 9.).

pic9.jpg

Picture 9.

23. From the Add Reference window select the.NET tab and then select System.Data.

24. Add using statements: using System.Data and using System.Web.UI.WebControles.

25. Delete Constructor.

26. Define variables:

string siteUrl = SPContext.Current.Web.Url;

WebBrowsable(true),
Personalizable(PersonalizationScope.Shared),
FriendlyName("The Site URL of Picture Library")]
public string SiteURL
{
   get
   {
       return siteUrl;
   }
   set
   {
       siteUrl = value;
   }
}

27. Recall in the item 7, the library that was created and named “Pic Library”. Assign this name to the string variable namePictureLibrary

       string namePictureLibrary = "Pic Library";

        public string NamePictureLibrary
        {
            get
            {
                return namePictureLibrary;
            }

            set
            {
                namePictureLibrary = value;
            }
        }

        string serverpath;

        SPListItemCollection imageListItems;
        DataTable imageMetaDataItems;
        DataRowCollection rows;
        DataTable imageMetaDataItemsTitle;
        DataRowCollection rowsTitle;

        Image image = new Image()

28. Create a method and insert the following code:

        protected override void CreateChildControls()
        {
           //Set image size in the web part

           image.Height = 100;
           image.Width = 100;

           //Take images from the Picture Library of SharePoint Portal 
            try
            {
                using (SPSite site = new SPSite(SiteURL))
                {
                   using (SPWeb spweb = site.OpenWeb())
                   {
                       SPList list = spweb.Lists[NamePictureLibrary];
                       SPQuery query = new SPQuery();
                       query.Query = "";

                        serverpath = site.Url.ToString() + "/";

                        imageListItems = list.GetItems(query);

                        if (imageListItems.Count <= 0)
                        {
                            this.Page.Response.Write("No image found");
                        }


                        SPWeb metaDataSite = SPContext.Current.Web;
                        SPSiteDataQuery metaDataQuery = new SPSiteDataQuery();

29. You can find all the numbers of Server Templates in the URL: http://abstractspaces.wordpress.com/tag/reference-cheat-sheet-caml-basetype-servertemplate/

                         metaDataQuery.Lists = "<Lists ServerTemplate=\"109\" />";

30. Recall the Description column in the Pic Library. Assign the column name to ViewField.

                        metaDataQuery.ViewFields = "<FieldRef Name=\"Description\" />";
                        metaDataQuery.Webs = "<Webs Scope='SiteCollection' />";

                        SPSiteDataQuery metaDataQueryTitle = new SPSiteDataQuery();
                        metaDataQueryTitle.Lists = "<Lists ServerTemplate=\"109\" />";

31. Assign the Link column name to the ViewField.

                        metaDataQueryTitle.ViewFields = "<FieldRef Name=\"Link\" />";
                        metaDataQueryTitle.Webs = "<Webs Scope='SiteCollection' />";

                        imageMetaDataItems = metaDataSite.GetSiteData(metaDataQuery);
                        rows = imageMetaDataItems.Rows;
                        imageMetaDataItems.Columns.Remove("ListId");
                        imageMetaDataItems.Columns.Remove("WebId");
                        imageMetaDataItems.Columns.Remove("ID");

                        imageMetaDataItemsTitle = metaDataSite.GetSiteData(metaDataQueryTitle);
                        rowsTitle = imageMetaDataItemsTitle.Rows;
                        imageMetaDataItemsTitle.Columns.Remove("ListId");
                        imageMetaDataItemsTitle.Columns.Remove("WebId");
                        imageMetaDataItemsTitle.Columns.Remove("ID");
                    }
                }
            }
            catch (Exception ex)
            {
                Controls.Clear();
                Label errorMessage = new Label();
                errorMessage.Text = "There was error in the code. Message: " + ex.Message;
                Controls.Add(errorMessage);
            }
            base.CreateChildControls();
        }

32. Insert the following code in the Render method (This code creates a table and uses Description column data from the SharePoint Picture Library as a link. The Link Url is taken from the Link column of the same SharePoint Picture Library):

        protected override void Render(HtmlTextWriter writer)
        {
            writer.AddAttribute("Border", "0");
            writer.AddAttribute("width", "100%");
            writer.RenderBeginTag("Table");
            int i;
            int im = imageListItems.Count;
            for (i = 0; i < im; i++)
            {
                writer.RenderBeginTag("Tr");
                writer.AddAttribute("width", "120");
                writer.RenderBeginTag("Td");
                image.ImageUrl = serverpath + imageListItems[i].Url.ToString();
                image.RenderControl(writer);
                writer.RenderEndTag();
                DataRow row = rows[i];

                foreach (DataColumn col in imageMetaDataItems.Columns)
                {                    
                    writer.RenderBeginTag("Td");

                    row = rowsTitle[i];
                    DataColumn colT = imageMetaDataItemsTitle.Columns[0];
                   

                    writer.AddAttribute(HtmlTextWriterAttribute.Href, row[colT].ToString());
                    writer.RenderBeginTag(HtmlTextWriterTag.A);
                    row = rows[i];
                    writer.WriteLine(row[col]);
                    writer.RenderEndTag();

                    writer.RenderEndTag();
                }

                row = rowsTitle[i];
              

                writer.RenderEndTag();
            }

            writer.RenderEndTag();

            // TODO: add custom rendering code here.
            // writer.Write("Output HTML");
        }

33. Right click the ImgAndLink project in the Solution Explorer and then click Properties (Picture 10.).

pic10.jpg

Picture 10.

34. In the Properties window select Debug and insert the URL of the portal we created in step 4. Click the Start Debugging or press the F5 button (Picture 11.).

pic11.jpg

Picture 11.

35. Open the Team Information Portal and click the Site Action dropdown button and then click the Edit Page (Picture 12).

pic12.jpg

Picture 12.

36. In the Top Zone click Add Web Part.

37. In the Add Web Parts – Web Page Dialog click the Advanced Web Part gallery options link.

38. Drag the ImgAndLink Web Part from Add Web Parts pane and drop it into the Top Zone Picture 13.).

pic13.jpg

Picture 13.

39. Click the Team Information Portal tab and you will see your portal with the ImgAndLink web part (Picture 14.)

pic14.jpg

Picture 14.

Now the portal has the web part containing images and links to the external source of news or events. Portal administrator or user inserts images, titles, descriptions, and links only in the Picture library.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

bnossov
Web Developer
United States United States
Boris works as a Portal Developer.
Hi is excited about SharePoint, WPF, Silverlight and trying to implement them in portal development

Comments and Discussions

 
QuestionHey do you have this on Visual Studio 2005 or better??? Pin
Kimmie800025-Mar-09 10:46
MemberKimmie800025-Mar-09 10:46 
AnswerRe: Hey do you have this on Visual Studio 2005 or better??? Pin
bnossov25-Mar-09 15:25
Memberbnossov25-Mar-09 15:25 
GeneralError : Object reference not set to an instance of an object. Pin
Nevil Gandhi13-Mar-09 23:47
MemberNevil Gandhi13-Mar-09 23:47 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
bnossov14-Mar-09 10:05
Memberbnossov14-Mar-09 10:05 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
Nevil Gandhi15-Mar-09 20:14
MemberNevil Gandhi15-Mar-09 20:14 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
bnossov17-Mar-09 6:33
Memberbnossov17-Mar-09 6:33 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
Nevil Gandhi17-Mar-09 22:39
MemberNevil Gandhi17-Mar-09 22:39 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
bnossov20-Mar-09 6:27
Memberbnossov20-Mar-09 6:27 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
Nevil Gandhi20-Mar-09 18:48
MemberNevil Gandhi20-Mar-09 18:48 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
bnossov23-Mar-09 5:08
Memberbnossov23-Mar-09 5:08 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
Nevil Gandhi23-Mar-09 19:21
MemberNevil Gandhi23-Mar-09 19:21 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
Member 42486025-Aug-09 10:11
MemberMember 42486025-Aug-09 10:11 
GeneralRe: Error : Object reference not set to an instance of an object. Pin
bnossov25-Aug-09 11:49
Memberbnossov25-Aug-09 11:49 
QuestionWhere's the code? Pin
Mike Holpuch4-Feb-09 10:27
MemberMike Holpuch4-Feb-09 10:27 
AnswerRe: Where's the code? Pin
bnossov4-Feb-09 10:44
Memberbnossov4-Feb-09 10:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.