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

Archive for March, 2012

100 Answers reached in MSDN Forums :)

Posted by Paul on March 30, 2012


Friends.. I am very much happy to share a news that: Today I reached 100 Answers in MSDN Forums.  That was a tremendous effort for last 2 months which started 1 year back.  I have been supporting:

  • Visual C#
  • Visual C# Language
  • Windows Forms
  • .Net Base Class Library
  • Visual C# IDE

It is really good to see a milestone of 100 reached.  It was an interesting Journey.

After all fixing problems over Forums, will make us more sharp, increase our knowledge and help others who need support immediately.  Together, I found great community members whose spirit and aptitude inspired me.  It is really great to be with those talented people.

I would like to recommend you all to try the same.  Initially it will be difficult, but surely you will learn the ropes.  After all I find it really good to give back to the community which helped us in our need times.  Help, Support, Improvize, Adapt, Overcome… 🙂

You can find the updated points/status here: My Profile


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

TFS 2010 – How to set Check-in Policy

Posted by Paul on March 23, 2012

This article demonstrate how to enable Source Code Check-in Policy inside TFS 2010.


Following are the default policies available with TFS:

Policy Description
Builds This policy requires that the last build was successful for each affected continuous integration build definition.
Code Analysis This policy requires that Code Analysis is run before check-in.
Testing Policy Ensures that tests from specific test lists are successfully run before checking in.
Work Items This policy requires that one or more work items be associated with every check-in.



Step 1) Install New Policy

We can try adding a new policy that ensures Comments are associated with public methods/properties.

This is a third party plugin and you can download it from CodePlex using the following link:

Use the Download link to download and install the policy executable.  You need to restart Visual Studio after the installation.


Step 2) Open Team Explorer inside Visual Studio


Step 3) Open Source Control Dialog


Step 4) Click add button from the Check-in Policy tab


Step 5: Select Check for Comments item


Click Ok button


Please note that the above dialog says we have selected only Public Methods for comment requirement.

Step 6: Test the Check-in

Now we can try creating a file with comment missing for a public method.


Try checking in the file:


On checking in the above file we will get the following error dialog.


This makes sure that the Policy was Installed Successfully.


In this article we have explore the source code policy feature of Team Foundation Server and installing a custom Check-in policy.

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

TFS 2010 Installation

Posted by Paul on March 23, 2012

Team Foundation Server is more than of a Source Control:

TFS provides the following features:

  1. Source Control
  2. Build Management
  3. Project Tracking

Download Trial

Installation is possible on:

  • Windows 7
  • Windows Vista
  • Windows 2003
  • Windows 2008

Visual Studio Power Tools for TFS

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

Windows Authentication Missing / Blank Page on installing SharePoint 2010 on Windows 7 Home Premium?

Posted by Paul on March 23, 2012

SharePoint 2010 requires at least the Professional edition of Windows 7.

If you encountered the following issues with Windows 7 Home Premium:

  • Blank Page on visiting SharePoint site or Central Administration Site
  • Windows Authentication missing in IIS


Following are the solutions available. You can choose one of it.

1) Installing Windows Authentication Manually

Please see reply by AntonioCosta


2) Disabling Windows Authentication and using Basic Authentication (not the best way)

3) More Links

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

SQL Server–Create User / Domain User using SQL

Posted by Paul on March 23, 2012

            USE TheDbName CREATE USER user1 FOR LOGIN [Domain\user1]

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

eBook on SharePoint 2010

Posted by Paul on March 12, 2012

I am very much happy to compile my third eBook: SharePoint 2010 Administration & Development. This book provides developers a good start with SharePoint 2010 Development.  Additionally, chapters on SharePoint Installation, Basics of Administration are included.


Download eBook
You can download the eBook here

Download Source
You can download the source code of examples in the book here

Pages: 253
Size: 10 MB

Full Edition Launched!

You can find the Full Edition of the book in hard cover from Amazon.


New Additions:  625+ Pages (triple content), Real Life Scenarios for Thinking in the SharePoint Way, Interview Questions

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

DataGridView set boolean cell to true in Runtime. How?

Posted by Paul on March 10, 2012

(dataGridView1.Rows[0].Cells[0] as DataGridViewCheckBoxCell).Value = true;
var dzone_url = ‘’;var dzone_title = ‘DataGridView set boolean cell to true in Runtime. How?’;var dzone_blurb = ‘DataGridView set boolean cell to true in Runtime. How?’;var dzone_style = ‘2’;

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

SharePoint 2010 – Creating Web Application

Posted by Paul on March 8, 2012

SharePoint 2010 – Creating Web Application

In the previous article we have seen how to view the existing web applications using Central Administration.

IIS Manager

Each web application inside SharePoint are configured along with IIS (Internet Information Services). Use the inetmgr command to view the IIS Manager as shown below:


The above highlighted applications represent the SharePoint port 80 web application and Central Application web application.

Steps in creating Web Application

Now we can create the web application inside our SharePoint instance. New web application can be used to support a new set of users. For creating please follow the following steps.

Open the Central Administration from Start Menu and click on Manage Web Applications item.


In the appearing window you can see 2 items. The default web site and Central Administration site. The default web site is created on SharePoint installation. The Central Administration is the website which is used by Administrators – it contains items to manage existing web sites, create new website and other tasks. Click on the New button from Ribbon UI.

Here you can set the following options:

· IIS Web site

· Application Pool

· Security

· Database Name

Leave the default values except in the Security Account in Application Pool.

Press the Ok button and you will see following busy screen. Web Application creation is a time consuming process and may take several minutes.

Waiting for a while you can see that the new web application is created.

Please note the port number of our new web application.


In this article we have seen how to create a new web application using Central Administration. Please note that each web application created are created inside IIS for the machine.

Posted in SharePoint | Tagged: , , | 1 Comment »

SharePoint 2010 – Central Administration

Posted by Paul on March 8, 2012

In this article I would like to experiment with Central Administration web application.

About Central Administration

The SharePoint Central Administration is a website used for:

· Application Management (Web Application, Sites, Lists, Services etc.)

· Monitoring (Job Status, Problems etc.)

· Security

· Application Settings, System Settings

· Performing Backup/Restore

· Configure Search, Services, Migration Assisting etc.

In summary the Central Administration is the Administrator/Developer tool. It is used to manage the websites for other users.

Opening Central Administration

We can access central administration from the start menu item:


On executing the command you can see the following screen in browser (ensure you provided the credentials properly – by default it will be system username and password)


Now we are ready to explore web applications. Before that we need to go through the hierarchy of web application, sites etc.


Following is the hierarchy of SharePoint Farm, Web Application, Site Collection, Site, Lists and Documents.


Following is the description of the items in the above image:

Server Farm: Server Farm contains multiple components like SharePoint server, Database server providing multiple Web Applications spanned over multiple machines. For development machines one single machine can support all the components.

Web Application: Web Application contains multiple Site Collections. This could be equivalent to an ASP.NET application.

Site Collection: Site Collection contains multiple Sites

Site: Site contains Lists, Documents etc.

Viewing existing Web Applications

On installation, there are 2 web applications by default:

1. SharePoint Port 80 which is the user facing one

2. SharePoint Central Administration meant for Administrators

To view the web applications, click on the Manage web applications link under Applications Management category. You can see the following screen:


Please note the URLs for each web applications.



In this article we have seen the hierarchy of SharePoint and creation of WebSite and SiteCollection.

Posted in SharePoint | Tagged: , , | 5 Comments »

SharePoint 2010 – Using Lists

Posted by Paul on March 5, 2012

In this article we can focus on Lists in SharePoint. We can create multiple lists in SharePoint 2010. The limit can be configured through Central Administration.

For starting with use our site collection url to open the page.


Creating a List

Now we can start by creating a List. As mentioned in the previous article a SharePoint List is a collection of items. We can specify columns as metadata for the List. We can create List based on existing templates or from scratch.

Click on the Lists option from the left side and click the Create button. The following dialog box appears.


Choose one of the template for example Announcements. Enter the name for your list and Click the Create button. The new List will be created as shown below.


You can use the Items or List ribbons to add item, or modify the view.

Adding items to a List

Click on the Add new Announcement link from the List and you will get the following screen.


Enter the details for Announcement and click the Save button. Your new item will get displayed as below.


Deleting a List

We might be requiring deleting an existing entire List. In this case do the following steps.

1. Open the List

2. Click the List ribbon menu item


3. Click List Settings


4. Use Delete this List link


Now the list will get deleted from the site.

Note: In a list there is always an ID column which is hidden. So while creating custom columns for the list, the name ID will be reserved. It is case-sensitive too.

Indexes on List

SharePoint allows us to manage large amounts of data. The data are actually stored inside SQL Server database tables. So we can suggest the Indexing feature of tables to allow faster fetching of records. We can use the Indexed Columns feature of any List to provide Indexing.

Click on the List Settings > Indexed Columns link to pen Indexed Columns page.


Use the Create a new Index in the upcoming page. Choose the column for Indexing and click the Ok button to create Index.


Now the Index will be successfully created and shown in the Index details of List.


In real world scenarios Indexes provide high leverage in data loading and manipulations.



In this article we have explored Lists and Indexes in SharePoint. The list provides an interface to store related entities and library provides document storage facility. There are many more templates to explore in the List section.

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