Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Posts Tagged ‘designer’

SharePoint 2010 – Starting Programming

Posted by Paul on May 25, 2012

In this article we can start with programming part of SharePoint 2010. Through programming we are able to get more control and flexibility over SharePoint. We can use Visual Studio to do the programming part with the support of SharePoint server side object model library.

Some of the advantages gained through programming SharePoint are:

· Server Object Model to Iterate over Lists and Libraries

· Content Type Creation

· Web Part Creation

· WorkFlow Creation

· Assembly Signing

· Business Data Connectivity Model Creation

· Site Definition Creation

· Automated Backup and Restore

Visual Studio

Here we are using Visual Studio 2010 to work with SharePoint 2010. You can use a 32 bit or 64 bit version of Visual Studio 2010.

Visual Studio 2010 Tools for SharePoint Development

After the Visual Studio 2010 is ready, you need to install the following component to start with:

· Visual Studio 2010 Tools for SharePoint

This tool helps with custom templates, automatic web part deployment to SharePoint server and other integration facilities.


You can download the tool from the following link:

According to the documentation the tool provides extensions to four core areas:

1. Environment

2. Exploration

3. Templates

4. Deployment

After installing the tool, start a New Project in Visual Studio and you will be able to see the following SharePoint project category:


For starting with select the Empty SharePoint Project template and click Ok button. The following site dialog box will be prompted.


Enter your site url, leave the other options as unchanged and click Finish button.

Now the Solution Explorer will look like below:


Try building the project and if the build succeeds your Visual Studio is ready for SharePoint 2010 development. We can explore the programming areas in the upcoming articles.



In this article we have explored the programming part of SharePoint 2010. Using Visual Studio we can gain control over the SharePoint sites and features. In the upcoming articles we can play around with the object model and features.


Posted in C#, SharePoint | Tagged: , , , | 2 Comments »

SharePoint 2010 – Creating a List Definition using SharePoint Designer

Posted by Paul on May 22, 2012

In this article we can experiment with List Definition creation using SharePoint Designer.

We can create List Definition using the following tools:

1. SharePoint

2. Visual Studio

3. SharePoint Designer

To proceed with run the SharePoint Designer application. Use the Open Site button to open the default SharePoint site. Now select the Lists and Libraries option from the left Navigation bar.


From the ribbon menu, use the Custom List button.


In the appearing dialog box enter the Name and Description for the List.


Click the OK button continue. The new List Definition will get added as shown below.


Now use the Edit Columns button from the ribbon menu.


You can see the default Title column already in the list. Add the following 2 columns using the Add New Column button from the ribbon menu.


· ContactName as Single line of Text

· Address as Multiple lines of Text

Now the Columns list look like below:


Click on the Save button from the Top menu.


Now you are ready with the new List Definition. Go back to SharePoint inside browser and you can see the new List there:


You can try adding a new item and the dialog window shows the columns we added.


Click the Save button and this concludes our List Definition creation using SharePoint Designer.


In this article we have experimented with List Definition creation using SharePoint Designer. Designer provides an easier way for Administrators.

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

SharePoint Designer 2010

Posted by Paul on May 2, 2012

In this article we are going to explore SharePoint Designer. It is another great tool to work with SharePoint. It is a free tool and can be used for editing of items inside SharePoint.


Some of the cool features of Designer are:

· It is Free

· WYSIWYG (What you see is what you get) Editor

· No Coding Required

· Useful for Administrators as well as Developers

· Workflow Creation

· Editing of Site, Styles Possible using Designer

· Branding

· Form Customizations

· Visio Integration

· InfoPath Forms Data Source Configuration

· Manage Site Permission, Site Columns etc.

· BCS (Business Connectivity Configuration)

· Create Content Types


· SOAP and REST support

· Administrator can restrict the use of Designer on sites


The version compatible with SharePoint 2010 is SharePoint Designer 2010.

The previous version of designer was SharePoint 2007. The ancestor of SharePoint Designer is Microsoft FrontPage which was a web editor of the times.

Download Link

You can use the following links to download the 32bit and 64bit version of Designer 2010:

Enabling/Disabling Designer Features

To enable/disable the features of SharePoint Designer use the following item:

Site Actions > Site Settings > Site Collection Administration > SharePoint Designer Settings


You can change the following options on the above screen:

· Enable / Disable SharePoint Designer for the Site

· Enable / Disable detaching page from the site definition

· Enable / Disable customizing master pages

· Enable / Disable managing of web site url feature

Running SharePoint Designer

After the installation you can execute SharePoint Designer using the following link:

All Programs > SharePoint > Microsoft SharePoint Designer 2010

Following is the application snapshot on executing the above link:


Use the Open Site button and you will get the following dialog:


Enter the site url and click the Open button. Enter the credentials in the appearing dialog.

You will get the site opened in the main Designer window as shown below:


The left side pane shows various features of the site like:

· Lists and Libraries

· Workflows

· Site Pages

· Site Assets

We can select the item from the left pane and the properties are displayed on the right side.

Customizing Site Pages

Now we can try customizing an existing page using SharePoint Designer. For this create a new list named contacts in the site deriving from the Contacts template.

Refresh the site in the Designer using the button on left top system menu.


Now select the Lists and Libraries item from the left pane. You will be able to see list named contacts.


Click on the contacts item and you will get the properties of it.


You can see 3 forms on the Forms pane which are described below:




Used to display the item details (View command)


Used to edit the item details (Edit command)


Used to add a new item (New command)

Now we can add a new page and apply the Display (View command) to it. Click on the New button from the Forms pane. Enter the following details in the appearing dialog.


Click the Ok button to continue. Now the new form gets added and acts as the default View form. You can try changing the color of the form labels, deleting some rows, adding a hyper link, custom formatting etc. After the changes click the Save button and you are ready to check the edited page inside SharePoint. (Use the Refresh button to get the controls)

Inside SharePoint site, add a new contact and use the View Item command for the newly added item. You can see the following screen:



Please make sure that you are editing only the new custom form. Changing the SharePoint pages may create problems and hence not advisable to new users.

Editing Master Pages and CSS

We can also edit the Master Pages using the left side link Master Pages.


Click on the v4.master item and it will get opened as shown below. Use the Edit File option from the appearing page.



You can modify the control properties in the appearing window. There is an option on the bottom of Designer to switch to the Code View from the Design View.


Editing CSS (Cascading Style Sheets)

As you might be knowing the CSS files determines the font sizes, colors and various attributes. Use the Style > Manage Style option to get the CSS properties.


You can see the Manage Styles properties window in the right end bottom of the designer.


Right click on the item, and use the Edit Item menu item. There you can change the style of the particular item. Any changes will get reflected in the SharePoint site on saving.

Working with Controls

We can add / edit controls to the custom pages or master page. Use the Insert menu option to add controls. You can choose from HTML, ASP.NET, SharePoint controls as shown below:




In this article we have explored about SharePoint Designer. The Page Customization, Master Page Editing facilities using the Designer were explored.

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

SharePoint 2010 – Web Parts

Posted by Paul on May 2, 2012

Web Parts are rectangular areas of HTML content. We can provide information to the users using Web Parts. The history of Web Parts starts from year 2000 in the name Digital Dashboard. Later it evolved as Web Parts and includes support in SharePoint Designer and Visual Studio. We can use the existing web parts or build custom web parts for SharePoint.

SharePoint 2010 contains inbuilt web parts and provides custom web part integration facilities. Web Parts provides set of controls to display, modify, and configure the contents.

Example of Web Part


Adding a WebPart

For starting with open our site collection using the url.


We can start by adding an image WebPart to the main page. Click on the left top menu Site Actions > Edit Page option.


On the appearing screen below, click on the first Add a Web Part button.


The following options appears:


Select Media and Content from the first pane and Image Viewer from the second pane and click the Add button. Now the Web Parts gets added into the page.


Use the open the tool pane option and enter an image url inside it, then click the Apply button.


Now click the Stop Editiong button from the ribbon menu.


Now you are ready with the main page with an image as shown below.


Editing a Web Part

We can edit a web part by logging in as a user with permissions to edit and using the Edit Web Part option from the right side context menu of the web part.


Deleting a Web Part

To delete an existing Web Part, use the Edit Web Part option from the context menu.


Then use the Delete option again from the Web Part context menu.


Now the Web Part gets deleted.

Using List Web Parts

We can use List Web Parts to show the custom Lists made inside SharePoint. Use the Add web part option to locate the Lists and Libraries category as shown below:


There we can locate the custom List created inside SharePoint. The List Web Part allows us to add the List to other sites through web parts.

Silverlight Web Part

Another notable feature in SharePoint 2010 is the Silverlight web part. Using the Silverlight web part we can now host silverlight applications inside SharePoint. The XAP files needed to be located for the web part.

To add a silverlight web part use the Media and Content category from the Add Web Part dialog as shown below:


Web Part Galleries

The Web Part Gallery provides a view on the installed web parts for a site collection. You can access this window from Site Settings > Galleries > Web Parts.


On clicking the above link you can see the page as shown below:


We can create our custom web part and deploy it to the SharePoint server. These topics are discussed in advanced chapters. The web parts will be having extension .dwp expanding as Dashboard Web Part.



In this article we have explored the Web Part feature, Adding/Editing/Deleting Web Parts, Silverlight Web Part, Web Part Galleries etc.

The key points of web parts would be:

· A rectangular area of HTML content

· Flexible piece of Functionality

· Users can manage adding/deleting web parts

· Custom web part creation is possible

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

SharePoint 2010 – Using Libraries

Posted by Paul on May 2, 2012

In this article we can focus on Libraries which are the document management repositories in SharePoint 2010. The previous article should have given a good overview of the Document Management features of SharePoint.

Creating a Library

Now we can create a library. A library represents a collection of documents. For example a Document library, PDF library etc.

Click on the Libraries item from the left pane.


You will get the following screen:


Click the Create button to get the following dialog.


Select the Library option from the left pane, then choose Document Library from the middle pane and enter the name on the right pane. Click the Create button to continue.

You will get the progress screen as shown below:


Now you are ready with the document library created:


Click the Add document button to start adding documents to the library.


Choose a document and click the Ok button. Your new file will be listed in the document library as shown below.


So this concludes our Library creation.

Deleting a Library

For deleting a particular library, the steps are similar to deleting a list. Open the library, click the Library Settings option and use the Delete the document library option as shown below.



In this article we have explored Libraries in SharePoint. There are many more templates to explore in the Library section.

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

TFS :: Programmatically get folder content

Posted by Paul on April 20, 2012

In this small article, I would like to show you how to get the contents of the folder from TFS server.

The post could be useful while creating deployment tools.

1. Create a new Console Application

2. Add references to following assemblies

You can get those from the references assembly or from folder 
C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\ReferenceAssemblies\v2.0
3. Get the TFS server url 
Use Team Explorer to connect to a TFS server and use Properties window to the get the url.
4. Get the path to required folder
Get the folder path from Source Control Explorer
Eg: $/Projects/MyApplication
5. Use the following code to retrieve all folders
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.TeamFoundation.Client;
using Microsoft.TeamFoundation.VersionControl.Client;
namespace MyConsoleApp
{     class Program     {         static void Main(string[] args)         {             RegisteredProjectCollection server = RegisteredTfsConnections.GetProjectCollection(new Uri("URLHER"));             TfsTeamProjectCollection projects = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(server);             VersionControlServer versionControl = (VersionControlServer)projects.GetService(typeof(VersionControlServer));             Workspace workspace = versionControl.CreateWorkspace(AppDomain.CurrentDomain.FriendlyName + "-installer", versionControl.AuthorizedUser);             WorkingFolder folder = new WorkingFolder("$PATH", "c:\\output");             workspace.CreateMapping(folder);             workspace.Get(); // Receive all the files             workspace.Delete();         }     }
6. Execute the application
Now you can see the c:\output folder to view the files.
var dzone_url = ‘’;var dzone_title = ‘TFS :: Programmatically get folder content’;var dzone_blurb = ‘TFS :: Programmatically get folder content’;var dzone_style = ‘2’;

Posted in C#, SharePoint | Tagged: , , | Leave a Comment »

SharePoint 2010 – Enterprise Document Management

Posted by Paul on April 11, 2012

SharePoint provides good amount of features supporting Enterprise Document Management.


The main features supported by SharePoint 2010 are:

1. Metadata

2. Versioning

3. Alerts

4. Workflows

5. Check Out

6. Search

7. Co Authoring

8. Auditing


SharePoint supports public, major and minor versioning support. To enable versioning use the Library Settings > Versioning settings option.



We can store information about the library items as Metadata using Columns. For adding Metadata for any library item use the Library Settings > Create Column option.


Using Enterprise Keywords we can tag a particular document. As they are indexed they are searchable and provide meaningful organizational capabilities.

Types of Libraries

SharePoint 2010 provides different types of in-built document libraries.

Library Type


Document Library

For all document types

Asset Library

For images, video files

Connection Library

Storing connection files

Report Library

KPI (Key Performance Indicator), BI files

Slide Library

PowerPoint Slide files

Picture Library

Picture files

Form Library

InfoPath Form files

Document ID Service

The document ID feature creates document identifiers that can be used to retrieve items independent of their current location. The document ID service is responsible for providing the Document ID feature.

When a document is added to the collection SharePoint assigns the Document ID to it. The administrator needs to configure the Persistence setting of Document ID.

To enable this feature use Site Actions > Site Settings > Site Collection Features item.


Click on the Activate button to make the service running.

Document Set

Document Set is a new feature in SharePoint 2010. It is similar to a zip file and a good solution while working with a group of files. While working with a project, people usually needed a set of files instead of a single file. So the Document Set feature is really useful once we know how to use it.

To enable this feature use Site Actions > Site Settings > Site Collection Features item.


Click on the Activate button to make the service running.

The creation of document and document sets are discussed in the upcoming article.



In this article we have explored the Document Management Features supported by SharePoint. The versioning, check out, co authoring features provides the SharePoint end users a great tool in hand.

Posted in C#, SharePoint | Tagged: , , | Leave a Comment »

SharePoint 2010 – Views, Lookups and Validations in List

Posted by Paul on April 11, 2012


We can associate a View for a List. Views provide a different representation of the existing information. If a List has columns Name and Country we can create a View for the List with county as India. Here we are experimenting with custom column creation as well.

For this create a new List with Custom List as the template.


Add the following columns into it.

· Name

· Country

Now add the following data into the Contacts List


Now there are 2 records with India and Other as country.

From the List ribbon item and click Create View button.


In the appearing page select Standard View option.


In the appearing page, enter the name for the view as Contacts in India.

Scroll down and in the Filter section use Country as filter equal to India.


Click the Ok button to create the View. Now you can see the view only lists one record.


This concludes our View creation.

Note: Views can be used to show grouped data, filtered data etc. based on the existing Lists items. In this way it is similar to the database Views which operate on tables. In SharePoint the contents are getting stored in SQL Server database.


A column in a List can integrate with another List column. For example we have 2 lists.

Doctor List




Patient List




Doctor (Referring to Doctor.Name column)

Here the Patient List is referring to Doctor List through the Doctor column which is acting as a Lookup column.

To accomplish the same create a custom list named Doctors with Name and Qualification as columns.

Note: The Title column will be already there, renaming/deleting can be done through the List Settings screen.

Now create a new list named Patients using Custom List template. Add the properties Name, Address and Doctor. For the column Doctor choose Lookup field.


Choose the highlighted list items as shown in the screen above. The Lookup field is required to fetch data from other Lists. We need to specify the List and Column for Lookups.

After setting the Lookup properties click the Ok button.

Now add some data to the Doctors list as shown below:


Now use the Add new item for the Patients List. You will be able to see the Doctor lookup field auto populated from the Doctors List.


Enter the details and click Save button. You are ready with the Patient with Doctor as Lookup value.


So this concludes our experiment with Lookup values. In real life scenarios we will end up with multiple Lookup values and validations. The Lookup values are implemented using Relationships. It is similar to the foreign key relations of a Relational Database Management System like SQL Server.


We can add validations for the columns. Now we can start experimenting with them. Here we are starting with a List of Employees. The columns are:

· Title

· Name

· Age

Make sure that the Age column is in the range 18 to 100. Any out of range values should populate the error message “Invalid Age – Please enter a value between 18 and 100!”

Create a List from the Custom List template and name it as Employees. Add custom column Name and Age. For the Age column make the type as Number. In the Column Validation section at bottom enter the following properties.

Formula: =AND(Age>=18,Age<=100)

User Message: Invalid Age – Please enter a value between 18 and 100!


Click the Ok button to continue. Now the List is ready with Name and Agecolumns.

Try to add a new item into the list with an invalid age (age = 11 for example)


You can see that the error message is shown for invalid Age.

This concludes our experiment with validations. In real world scenarios more complex validations need to be performed. For reference on the formulas you can use the link provided in the References section of this article.



In this article we have learnt about Views, Lookups and Validations. These knowledge are needed in building real world record management systems using SharePoint 2010.

Posted in C#, SharePoint | Tagged: , , | Leave a Comment »

SharePoint 2010 – New Features

Posted by Paul on April 11, 2012

In this article we can explore the new features of SharePoint 2010. Some of the new features of SharePoint 2010 are:

· Ribbon UI

· Status Bar

· Dialogs

· Branding and Theming

· Multilingual User Interfaces

· Inline Editing

· Developer Dashboard

· Silverlight Web Part

· Service Applications

For exploring the features please open the SharePoint 2010 default web application.

Eg: http://yourmachinename

Ribbon UI

The Ribbon User Interface can be considered as a major UI change in SharePoint 2010. It makes it similar to the Microsoft Office family of products. The advantages are user friendliness, easier access, categorized menus etc.


Opening a list shows the above Ribbon UI.

Status Bar

SharePoint 2010 provides a Status Bar which is below the Ribbon UI. It is not the Browser status bar. The Status Bar is configurable through pages.

Inline Editing

SharePoint 2010 allows the List items to be edited inline. This is without the use of an additional dialog with Ok/Cancel buttons. For enabling this we have to use the Modify View option in List Settings and choose Inline Editing enable checkbox.

New Dialogs

The dialogs are enhanced in SharePoint 2010. Some of the examples are given below.

New List and Library Dialog, Status Dialog



Branding and Theming

In SharePoint a new theme engine is included. This allows the users to create a theme from PowerPoint and use it inside SharePoint 2010.

The existing themes can be found in the Theme Gallary. (Site Actions > Site Settings > Themes)


You can anytime change the Site theme using the Site Settings > Look and Feel > Site theme option.


Silverlight Web Part

New silverlight web part has been added to SharePoint 2010. This allows us to embed silverlight applicatons inside the web pages. You can access this from the Add Web Part screen.


Developer Dashboard

The developer dashboard is a new feature in SharePoint 2010 which can be used for debugging and tracing purposes. It provides the performance related information to the developers. It is by default turned off and can be enabled by using PowerShell or StsAdm tool.

Service Applications

In the older version SharePoint 2007 there exists Shared Services Providers (SSP). This feature no longer exists in the SharePoint 2010 version and only Service Applications exists. The service applications like Search, Excel Services are unboxed and run independently.



In this article we have explored the new features of SharePoint 2010.

Posted in C#, SharePoint | Tagged: , , | 2 Comments »