Amit Phule

Choti choti magar moti baatein (do's and don'ts) - SharePoint Tips

2013-07-02T10:38:00.000+05:30

Hi Friends,

About ‘Choti choti magar moti baatein’ (do's and don'ts). It’s a Hindi language catchphrase for caution about something, it’s got popular when Shaktimaan – An Indian Superhero started a series educating children about the right and wrong things. (In childhood we all enjoyed it, of course bunking from school J )

In this brand new session we will discuss about SharePoint development do's and don'ts. It will improve the performance and usability of SharePoint applications.

We will also see SharePoint development tips, case studies, best practices and all about SharePoint world.

Everyone can do…

1) Share a new topic

2) Start discussion

3) Suggest solutions

4) Nothing else……………

Regards,

Amit Phule

JQuery Selectors

2013-04-20T13:00:00.000+05:30

JQuery is awesome, effective, powerful, rocking… I don’t have more word to say about JQuery.

In past I have posted some JQuery magic scripts, here I want to share some basic knowledge of JQuery selectors which will helps to target html tags.

jQuery offers a great engine for selecting html tags(elements) in the document which almost gives every filter option (tag name, attribute name, classes , properties etc.) for effective selection.

Here effective selection means, selection will not fail at any condition. Example: New html tags get added or in .Net server side controls id get change on each page load.

/* ########## Select HTML Tags ###########*/

// Get all tags by CSS class name
$(".ms-vb-user").css("display", "none");

// Get all div tags by CSS class name
$("div.ms-vb-user").css("display", "none");

// Get tag by id
var SelectedVal = $('#TDRightArea').text();

// Loop through all matching tags
$('a[href*=/_layouts/userdisp.aspx?ID=]').each(function () {
        var SelectedVal  = $(this).text();  
    });

//Get Parent Tag 
$('#TDRightArea').parent().html();

/* ########## Select and find in HTML Tags ###########*/

$('#TDRightArea').find('div.rightsubarea').each(function () { 
   $(this).css("color", "blue");
});

/* ########## Select .Net Controls ###########*/

// Get Radio Button List selected option
var SelectedVal = $('input[type=radio][id*=RBLLocation]:checked').val();

// Get TextBox entered text
var SelectedVal = $('input[type=text][id*=TxtLocation]').val();

// Get ListBox selected option
var SelectedVal = $("[id*='LBLocation'] option:selected").text();

// Get DropDown List selected option
var SelectedVal = $("[id*='DDLLocation'] option:selected").text();

// Get CheckBox List selected option
var SelectedVal = $('input[type=checkbox][id*=CBLLocation]:checked').next().text();

// Check CheckBox List option is checked, return true or false
var isChecked = $('input[type=checkbox][id*=CBLocation]').is(':checked');

/* ########## Select SharePoint Controls ###########*/

//Get PeopleEditor control value (SharePoint)
var SelectedVal = $("textarea[id*='PeopleEditorManager']").val();

More reference blogs:

http://api.jquery.com/category/selectors/
http://codylindley.com/jqueryselectors/
http://www.w3schools.com/jquery/jquery_ref_selectors.asp
http://www.w3schools.com/jquery/jquery_selectors.asp

ENJOY !!!

Change Date Format of SharePoint Date Time Column

2013-02-17T02:15:00.000+05:30

SharePoint 2010 provides a seamless, culture-specific experience that enables site owners to create sites in a specific language and configure the regional settings that are appropriate for those sites.

SharePoint Server 2010 uses the following types of regional settings: locale, time zone, sort order, calendar, and currency. You can specify the locale, sort order, time zone, and calendar settings on the Regional Settings page.

Change Date Format:

1) Go to "Site settings" from "Site Actions" Tab.

2) Under the "Site Administration" Section click on "Regional settings".

3) In "Locale" choice select desire option; example format DD/MM/YYYY you need to select "English (United Kingdom)".

Package the external DLL’s along with the SharePoint Solution (WSP)

2013-01-02T00:56:00.000+05:30

Visual Studio 2010 by default does not include external DLL in the SharePoint Package (WSP). We need to add this DLL explicitly in the package.

1. Include external DLL in the SharePoint Project.

2. Include DLL using package manager.

3. Verify DLL is included in the WSP.

Enjoy !

Custom List Form in SharePoint Designer 2010 will not render if the list columns are more then 70 : Resolved

2012-06-05T16:35:00.001+05:30

In SharePoint 2010, You can easily create custom list forms in SharePoint Designer, but some List Form will not render through error as “Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.”

Here is the resolution of problem. Follow below link.

http://social.technet.microsoft.com/Forums/en/sharepoint2010customization/thread/11a8b7c7-6bdd-485e-a8c6-083896cf6f83

Also I have copied the solution provide by Linda Chapman [MSFT]. Thanks Linda for your contribution.
Custom List Form in SharePoint Designer 2010 will not render if the list has a large number of columns.

Symptom

Custom List Form will not render if the list has a large number of columns. To reproduce this issue create a custom list and add 68 single line of text columns. The custom list form web part will not render and an error message such as this will occur in the browser:

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:

For more information about custom list forms please refer to this article:

http://office.microsoft.com/en-us/sharepoint-designer-help/create-a-custom-list-form-using-sharepoint-designer-HA010378258.aspx

Cause

This occurs when a large XSL transforms happens in a single template.

Resolution

The issue can be resolved by breaking up the offending xsl template into smaller parts to avoid a large transform.

This example is for a New Form custom list form. The Edit Form is similar in template naming convention. Please refer to the end of the article for the template names of the various form modes.

1. Open the page that contains the none working custom list form web part.
2. Switch to code for this this workaround.
3. Search for the following string:

<xsl:call-template name="dvt_1.rowedit"/>

4. Copy this line paste it 3 to 5 times. The table structure and other components that makeup this template will be divided into the other copied templates. A general guideline is to have about 20 to 40 table rows per template. There is a fair amount of give with this recommendation.

5. Rename each pasted template by adding a number to the end of it.

<xsl:call-template name="dvt_1.rowedit"/>
<xsl:call-template name="dvt_1.rowedit2"/>
<xsl:call-template name="dvt_1.rowedit3"/>
<xsl:call-template name="dvt_1.rowedit4"/>
<xsl:call-template name="dvt_1.rowedit5"/>

6. Now, press the control key and click the dvt_1.rowedit. This will highlight the template's first line which is this:

<xsl:template name="dvt_1.rowedit">

7. Place the cursor infront of the less than sigh of <xsl:template name="dvt_1.rowedit">
8. Hold down Control + Shift and then press semicolon. This will highlight the entire template.
9. Go to the bottom of the template. The following should be the last line: </xsl:template>

9. Paste the following markup after the closing xsl temlate tag from stpe 9. In this example there are 5 different dvt_1.rowedit templates calls so we'll need 5 <xsl:template> elements to match.

<xsl:template name="dvt_1.rowedit">
<xsl:param name="Pos" select="position()"/>
<tr>
<td>
<table border="0" cellspacing="0" width="100%">

</table>
</td>
</tr>
</xsl:template>

10. Rename each of the templates pasted in step 9 to match the templates from step 5.

<xsl:template name="dvt_1.rowedit">

<xsl:template name="dvt_1.rowedit2">

11. Next, the conents of <xsl:template name="dvt_1.rowedit"> needs to be divided among the new templates, <xsl:template name="dvt_1.rowedit2">, <xsl:template name="dvt_1.rowedit3"> and so forth. The easiest way to do this is to start at the end of the template and cut out the last few table rows and paste them into the last template that was created. In this example that would be <xsl:template name="dvt_1.rowedit5">

The individual table rows that represent the various SharePoint fields are stored inside of the table HTML element and that valid HTML needs to be persisted into the new templates. A good way of ensure this happens is to find <table border="0" cellspacing="0" width="100%"> in <xsl:template name="dvt_1.rowedit"> and perform a Control + Shift + Semicolon to highlight the entire table.

Once this is done scroll down to the end of the table and carefully take entire table rows, <tr>, and their contents over to the last xsl template.

By default the following is the last chunk of markup in <xsl:template name="dvt_1.rowedit">:

<tr id="idAttachmentsRow">
<td nowrap="true" valign="top" class="ms-formlabel" width="20%">
<SharePoint:FieldLabel ControlMode="New" FieldName="Attachments" runat="server"/>
</td>
<td valign="top" class="ms-formbody" width="80%">
<SharePoint:FormField runat="server" id="AttachmentsField" ControlMode="New" FieldName="Attachments" __designer:bind="{ddwrt:DataBind('i','AttachmentsField','Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Attachments')}"/>
<script>
var elm = document.getElementById('idAttachmentsTable');
if (elm == null || elm.rows.length == 0)
document.getElementById('idAttachmentsRow').style.display='none';
</script>
</td>
</tr>
<xsl:if test="$dvt_1_automode = '1'" ddwrt:cf_ignore="1">
<tr>
<td colspan="99" class="ms-vb">
<span ddwrt:amkeyfield="ID" ddwrt:amkeyvalue="ddwrt:EscapeDelims(string(@ID))" ddwrt:ammode="view"></span>
</td>
</tr>
</xsl:if>

This particular table row represents the attachment functionality inside of a custom list form. This should not be in multiple templates and makes sense to go to the last XSL template created.

All the other table rows, <tr>, should contain the various columns in your list. Again, start from the bottom and work up to keep this exercise easy.

Adjust these steps accordingly if custom HTML layout is used to display field controls.

12. Finally, here is an example of the finished product. Each template only contains 1 column and the attachment functionality in the last xsl template. Also, only <xsl:template name="dvt_1.rowedit"> and <xsl:template name="dvt_1.rowedit2"> were included.

<xsl:template name="dvt_1.rowedit">
<xsl:param name="Pos" select="position()"/>
<tr>
<td>
<table border="0" cellspacing="0" width="100%">
<tr>
<td width="190px" valign="top" class="ms-formlabel">
<H3 class="ms-standardheader">
<nobr>Title<span class="ms-formvalidation"> *</span>
</nobr>
</H3>
</td>
<td width="400px" valign="top" class="ms-formbody">
<SharePoint:FormField runat="server" id="ff1{$Pos}" ControlMode="New" FieldName="Title" __designer:bind="{ddwrt:DataBind('i',concat('ff1',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Title')}"/>
<SharePoint:FieldDescription runat="server" id="ff1description{$Pos}" FieldName="Title" ControlMode="New"/>
</td>
</tr>
</table>
</td>
</tr>
</xsl:template>

<xsl:template name="dvt_1.rowedit5">
<xsl:param name="Pos" select="position()"/>
<tr>
<td>
<table border="0" cellspacing="0" width="100%">
<tr>
<td width="190px" valign="top" class="ms-formlabel">
<H3 class="ms-standardheader">
<nobr>NewColumn90</nobr>
</H3>
</td>
<td width="400px" valign="top" class="ms-formbody">
<SharePoint:FormField runat="server" id="ff91{$Pos}" ControlMode="New" FieldName="NewColumn90" __designer:bind="{ddwrt:DataBind('i',concat('ff91',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@NewColumn90')}"/>
<SharePoint:FieldDescription runat="server" id="ff91description{$Pos}" FieldName="NewColumn90" ControlMode="New"/>
</td>
</tr>
<tr id="idAttachmentsRow">
<td nowrap="true" valign="top" class="ms-formlabel" width="20%">
<SharePoint:FieldLabel ControlMode="New" FieldName="Attachments" runat="server"/>
</td>
<td valign="top" class="ms-formbody" width="80%">
<SharePoint:FormField runat="server" id="AttachmentsField" ControlMode="New" FieldName="Attachments" __designer:bind="{ddwrt:DataBind('i','AttachmentsField','Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Attachments')}"/>
<script>
var elm = document.getElementById('idAttachmentsTable');
if (elm == null || elm.rows.length == 0)
document.getElementById('idAttachmentsRow').style.display=&apos;none&apos;;
</script>
</td>
</tr>
<xsl:if test="$dvt_1_automode = '1'" ddwrt:cf_ignore="1">
<tr>
<td colspan="99" class="ms-vb">
<span ddwrt:amkeyfield="ID" ddwrt:amkeyvalue="ddwrt:EscapeDelims(string(@ID))" ddwrt:ammode="view"></span>
</td>
</tr>
</xsl:if>
</table>
</td>
</tr>
</xsl:template>

Supplemental Information

The following are the template names for Edit Forms and Display Forms. The same concept applies to these as the New Form templates.

Display Form:

<xsl:call-template name="dvt_1.rowview"/> and <xsl:template name="dvt_1.rowview">

Edit Form, which is the same as New Form:

<xsl:call-template name="dvt_1.rowedit"/> and <xsl:template name="dvt_1.rowedit">

Enjoy !!!

SharePoint 2010 Capacity Planning

2012-05-22T14:25:00.002+05:30

This article provides an overview of how to effectively plan and manage the capacity of SharePoint 2010 environments. This article also describes how to maintain a good understanding of the capacity needs and capabilities of your deployment, by analysis of performance and volume data.

Capacity management is an ongoing process, You need to plan for growth and change, so that your SharePoint Server 2010–based environment can continue to deliver an effective business solution.

The capacity management model includes additional steps to help you validate and tune the initial architecture, and provides a feedback loop for re-planning and optimizing the production environment until it can support design goals with optimal choices of hardware, topology, and configuration.

# The following specialized terms are used in SharePoint 2010 capacity management:

RPS: Requests per second. The number of requests received by a farm or server in one second.

Peak hours: The time or times during the day when load on the farm is at its maximum.

Peak load : The average maximum daily load on the farm, measured in RPS.

Load spike: Transient load peaks that fall outside usual peak hours. These can be caused by unplanned increases in user traffic, decreased farm throughput because of administrative operations, or combinations of such factors.

Scale up: To scale up means to add resources such as processors or memory to a server.

Scale out : To scale out means to add more servers to a farm.

Throughput: Throughput is defined as the number of concurrent requests that a server or server farm can process.

# Limits and boundaries:

Web application limits

Content database size ( general usage scenarios)	200 GB per content database
Content database items	60 million items including documents and list items
Site collections per content database	2,000 recommended 5,000 maximum
Web site	250,000 per site collection
Site collection size	Maximum size of the content database
Web parts	25 per wiki or Web part page

List and library limits

The following table lists the recommended guidelines for lists and libraries.

List row size	8,000 bytes per row
File size	The default maximum file size is 50 MB and Maximum 2 GB.
Documents	30,000,000 per library
Major versions	400000
Items	30,000,000 per list
List view lookup threshold	8 join operations per query
List view threshold	5000
List view threshold for auditors and administrators	20000
Subsite	2,000 per site view

Column limits

SharePoint Server 2010 data is stored in SQL Server tables.

Single line of text	28 bytes
Multiple Lines of Text	28 bytes
Choice	28 bytes
Number	12 bytes
Date and Time	12 bytes
Lookup	4 bytes
Yes / No	5 bytes
Person or group	4 bytes
Hyperlink or picture	56 bytes
Calculated	28 bytes

Blog limits

The following table lists the recommended guidelines for blogs.

Blog posts	5,000 per site
Comments	1,000 per post

Groups limits

Number of SharePoint groups a user can belong to	5000
Users in a site collection	2 million per site collection
Active Directory Principles/Users in a SharePoint group	5,000 per SharePoint group
SharePoint groups	10,000 per site collection

References:

1. SharePoint Server 2010 capacity management: Software boundaries and limits

2. Column limits

Display Item Attachments in SharePoint List View

2012-04-25T17:11:00.004+05:30

It is very easy to display list item attachments
in List View and also manipulate the display of attachment, like if attachment is
image, we can display image not just a link.

1. Open List View in SharePoint Desinger

2. Add new column titled "Attachments".

3. Select TD tag of New column.

4. Replace selected code with below code.


 <td id="ItemAttchment" class="ms-vb">
          <xsl:element name="SharePoint:AttachmentsField">
          <xsl:attribute name="runat">server</xsl:attribute>
                    <xsl:attribute name="FieldName">Attachments</xsl:attribute>
          <xsl:attribute name="ControlMode">Display</xsl:attribute>
          <xsl:attribute name="Visible">true</xsl:attribute>
          <xsl:attribute name="ItemId">
              <xsl:value-of select="@ID"/>
          </xsl:attribute>
          </xsl:element>
</td>

5. View with Attachments

Quick Notes: Retrieving Values in Event Receivers using BeforeProperties and AfterProperties

2012-03-19T12:29:00.002+05:30

In SharePoint Portal development there are many scenarios where we need to develop event receivers.

So for accessing list item/ library item values, we need to use BeforeProperties and AfterProperties of SharePoint Event receivers. But some times they give empty or null values.

Below chart gives great understanding of which values are populated in BeforeProperties , AfterProperties and properties.ListItem objects.

For list:

List	BeforeProperties	properties.ListItem	AfterProperties
ItemAdding	Empty	Null	New Value
ItemAdded	Empty	New Value	New Value
ItemUpdating	Empty	Old Values	Updated Values
ItemUpdated	Empty	Updated Values	Updated Values
ItemDeleting	Empty	Original Values	Empty
ItemDeleted	Empty	Null	Empty

For library:

List	BeforeProperties	properties.ListItem	AfterProperties
ItemAdding	Empty	Null	Empty
ItemAdded	Empty	New Value	Empty
ItemUpdating	Old Values	Old Values	Updated Values
ItemUpdated	Old Values	Updated Values	Updated Values
ItemDeleting	Empty	Original Values	Empty
ItemDeleted	Empty	Null	Empty

The Synergy MOSS blog has explain this more clearly, please check here for more details.

http://www.synergyonline.com/Blog/Lists/Posts/Post.aspx?ID=122

Good Post on "SP 2010: How To – Event Receivers and Custom Error Pages" by Tobias Zimmergren .
http://zimmergren.net/technical/sp-2010-how-to-event-receivers-and-custom-error-pages

Quick Notes: SharePoint Solution Deployment Commands - PowerShell

2012-02-29T12:07:00.000+05:30

------------Add Snippet-------------------------

"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\CONFIG\POWERSHELL\Registration\SharePoint.ps1"

Add-PSSnapin Microsoft.SharePoint.PowerShell

------------Add Solution-------------------------

Add-SPSolution "E:\SPSolutions\SharePoint. Finance.wsp"

Install-SPSolution –Identity SharePoint.Finance.wsp –WebApplication " http://SPServer:1000/" –GACDeployment -force

------------Update Solution-------------------------

Update-SPSolution –Identity SharePoint.Finance.wsp –LiteralPath "E:\SPSolutions\SharePoint. Finance.wsp" –GacDeployment

------------Add Feature------------------------

Install-SPFeature Feature1 -force

Enable-SPFeature –Identity Feature1 –url "http://SPServer:1000/sites/Finance/"

------------Remove Feature------------------------

Uninstall-SPFeature Feature1

Disable-SPFeature –Identity Feature1 –url "http://spserver:1000/sites/Finance/"

Microsoft has provided a tool to design PowerShell commands for SharePoint
Check this...
http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html

Estimate content database storage - SharePoint 2010

2011-12-27T18:16:00.002+05:30

This article describes how to plan for and configure the storage and Microsoft SQL Server database tier in a SharePoint 2010 environment.

The capacity planning information in this article provides guidelines for you to use in your planning. It is based on testing performed at Microsoft on live properties. However, your results may vary based on the equipment you use and the features and functionality that you implement for your sites.

This article assumes that you are familiar with the concepts presented in Capacity management and sizing for SharePoint Server 2010.

Estimate content database storage

The following process describes how to approximately estimate the storage required for content databases, without considering log files:

1. Calculate the expected number of documents. This value is referred to as D in the formula.

2. Estimate the average size of the documents that you will be storing. This value is referred to as S in the formula.

3. Estimate the number of list items in the environment. This value is referred to as L in the formula. List items are more difficult to estimate than documents.

4. Determine the approximate number of versions. This value is referred to as V in the formula. The value of V must be above zero.

5. Use the following formula to estimate the size of your content databases:

Database size = ((D × V) × S) + (10 KB × (L + (V × D)))

The value of 10 KB in the formula is a constant that roughly estimates the amount of metadata required by SharePoint Server 2010. If your system requires significant use of metadata, you may want to increase this constant.

As an example, if you were to use the formula to estimate the amount of storage space required for the data files for a content database in a collaboration environment with the following characteristics, you would need approximately 105 GB.

Input	Value
Number of documents (D)	200,000 Calculated by assuming 10,000 users times 20 documents
Average size of documents (S)	250 KB
List items (L)	600,000
Number of non-current versions (V)	2 Assuming that the maximum versions allowed is 10

Database size = (((200,000 x 2)) × 250) + ((10 KB × (600,000 + (200,000 x 2))) = 110,000,000 KB or 105 GB

Download the Excel sheet for easy calculations.

Check Current User Gorup In SharePoint Object Model

2011-11-26T12:00:00.001+05:30

To manage permission we create Groups in SharePoint. In Custom SharePoint application or webpart, we have to check user permissions or may have activate different functionality.

For that We need to check Current User Group..

Here is a function that will return true/false by providing Group Name!

private bool IsCurrentUserMemberOfGroup(string GroupName)
        {
            try
            {
              return SPContext.Current.Web.IsCurrentUserMemberOfGroup(SPContext.Current.Web.Groups[GroupName].ID);               
            }
            catch (Exception)
            {
                return false;
            }
        }

You may provide web object for performance tuning.

Remove Lookup Hyperlink from SharePoint List view using JQuery

2011-11-04T17:10:00.000+05:30

When you use lookup to the list automatically SharePoint give link to the lookup item on list view.

Check it out….

Lookup column with Hyperlinks

But many times, we don’t want those Hyperlinks on the list view, as we can remove it from SharePoint Designer but it’s a hectic task.

Simply add JQuery to remove those Hyperlinks.

First, get the URL of the link using Developer tool of IE or Firebug of Firefox browser. we are going to some part of URL in the below code.

Get URL using Developer tool of IE

Then copy following JQuery code to the HTML form WebPart on list view.

Jquery For MOSS 2007/WSS 3.0:

Note: Change highlighted text as per your context.

Jquery For SharePoint 2010/SharePoint Foundation 2010:

Note: Change highlighted text as per your context.

If View is Grouped, set list view setting "By default, show groupings:" to Expanded

List View setting: Make sure that By default, show groupings: Expanded

List view with removed hyperlinks to Lookup columns:

Live simple!

How to rename the list view column name using JavaScript

2011-11-04T16:27:00.001+05:30

We can change column name from JavaScript, it will not affect your existing functionality or custom code and also no need to change column name from SharePoint Designer as it is a troublesome task.

Follow this steps….

1. Get column Id using Developer tool of IE or Firbug of Firefox.

Get Column ID using Developer tool of IE

2. Add following JavaScript in HTML form web part on the list view.

_spBodyOnLoadFunctionNames.push("ChangeColumnName"); // Call ChangeColumnName function on PageLoad

function ChangeColumnName() {

RenameColumn('diidSortAuthor', 'Author'); //Provide Column ID and New Column name

}

function RenameColumn(colID, NewHeader) {

try {

document.getElementById(colID).innerHTML = NewHeader; //Change Header Name

document.getElementById(colID).title = "Sort by " + NewHeader; // Change Tooltip value

}

catch (err) {

alert('Invalid Column ID:' + colID);

}

</script>

Old column Name:

New Column Name:

Live simple !

Hiding Group Headers from SharePoint List View

2011-10-31T21:20:00.003+05:30

We can hide the Group name in out of the box list view using JavaScript.

Grouped List View before adding JavaScript:

JavaScript (MOSS 2007/WSS 3.0):

_spBodyOnLoadFunctionNames.push("HideHeaders");

function HideHeaders() {

var elements = getElementsByClassName(document, "td", "ms-gb");

var elem;

for (var i = 0; i < elements.length; i++) {

elem = elements[i];

elem.childNodes[3].style.display = "none";

elem.childNodes[4].nodeValue = elem.childNodes[4].nodeValue.replace(':', '');

}

elements = getElementsByClassName(document, "td", "ms-gb2");

for (var i = 0; i < elements.length; i++) {

elem = elements[i];

elem.childNodes[3].style.display = "none";

elem.childNodes[4].nodeValue = elem.childNodes[4].nodeValue.replace(':', '');

}

function getElementsByClassName(oElm, strTagName, strClassName) {

var arrElements = (strTagName == "*" && oElm.all) ? oElm.all : oElm.getElementsByTagName(strTagName);

var arrReturnElements = new Array();

strClassName = strClassName.replace(/\-/g, "\\-");

var oRegExp = new RegExp("(^|\\s)" + strClassName + "(\\s|$)");

var oElement;

for (var i = 0; i < arrElements.length; i++) {

oElement = arrElements[i];

if (oRegExp.test(oElement.className)) {

arrReturnElements.push(oElement);

}

return (arrReturnElements)

}

</script>

JavaScript (SharePoint 2010/SharePoint Foundation 2010):

_spBodyOnLoadFunctionNames.push("HideHeaders");

function HideHeaders() {

var elements = getElementsByClassName(document, "td", "ms-gb");

var elem;

for (var i = 0; i < elements.length; i++) {

elem = elements[i];

elem.childNodes[0].childNodes[1].nodeValue = "";

elem.childNodes[1].nodeValue = elem.childNodes[1].nodeValue.replace(':', '');

}

elements = getElementsByClassName(document, "td", "ms-gb2");

for (var i = 0; i < elements.length; i++) {

elem = elements[i];

elem.childNodes[1].childNodes[1].nodeValue = ""; elem.childNodes[2].nodeValue = elem.childNodes[2].nodeValue.replace(':', '');

}

function getElementsByClassName(oElm, strTagName, strClassName) {

var arrElements = (strTagName == "*" && oElm.all) ? oElm.all : oElm.getElementsByTagName(strTagName);

var arrReturnElements = new Array();

strClassName = strClassName.replace(/\-/g, "\\-");

var oRegExp = new RegExp("(^|\\s)" + strClassName + "(\\s|$)");

var oElement;

for (var i = 0; i < arrElements.length; i++) {

oElement = arrElements[i];

if (oRegExp.test(oElement.className)) {

arrReturnElements.push(oElement);

}

return (arrReturnElements)

}

</script>

Grouped List View after adding JavaScript:

Enjoy!

How to show days count after created date of Item in SharePoint list View

2011-10-12T18:26:00.000+05:30

There are many posts showing date difference from today's date, but not a exactly the working solution is provided.

I have created the column that will show days count between Today's date and Created Date. and this column is update automatically.

For this I have created one calculated column and added simple JavaScript on the SharePoint List view.

Step 1:

Create new calculated column in the list and give formula as follows

="<DIV ID='CreatedDate'>"&TEXT(Created,"MM/dd/yyyy")&"</DIV>"

Step 2:

Add Form Webpart(MOSS 2007) or HTML Form webpart(SharePoint 2010) on the view and add below JavaScript in it.

// Script created by Amit Phule

// Taken reference from Christophe@PathToSharePoint.com post

var theTDs = document.getElementsByTagName("TD");

var i = 0;

var TDContent = " ";

while (i < theTDs.length) {

try {

TDContent = theTDs[i].innerText || theTDs[i].textContent;

if ((TDContent.indexOf("<DIV ID='CreatedDate'") == 0) && (TDContent.indexOf("</DIV>") >= 0)) {

theTDs[i].innerHTML = getDateDiff(TDContent.replace('</DIV>', '').replace("<DIV ID='CreatedDate'>", ''));

}

catch (err) { }

i = i + 1;

}

// ExpGroupRenderData overwrites the default SharePoint function. This part is needed for collapsed groupings

function ExpGroupRenderData(htmlToRender, groupName, isLoaded) {

var tbody = document.getElementById("tbod" + groupName + "_");

var wrapDiv = document.createElement("DIV");

wrapDiv.innerHTML = "<TABLE><TBODY id=\"tbod" + groupName + "_\" isLoaded=\"" + isLoaded + "\">" + htmlToRender + "</TBODY></TABLE>";

var theTBODYTDs = wrapDiv.getElementsByTagName("TD"); var j = 0; var TDContent = " ";

while (j < theTBODYTDs.length) {

try {

TDContent = theTBODYTDs[j].innerText || theTBODYTDs[j].textContent;

if ((TDContent.indexOf("<DIV ID='CreatedDate'") == 0) && (TDContent.indexOf("</DIV>") >= 0)) {

theTBODYTDs[j].innerHTML = TDContent;

}

catch (err) { }

j = j + 1;

}

tbody.parentNode.replaceChild(wrapDiv.firstChild.firstChild, tbody);

}

function getDateDiff(Date2) {

var days = 0;

var difference = 0;

Christmas = new Date(Date2);

today = new Date();

difference = today - Christmas;

days = Math.round(difference / (1000 * 60 * 60 * 24));

if(days!=0)

days = days - 1;

return days;

}

</script>

Screenshot:

Don't Show Missing Image Icon

2011-10-11T17:14:00.000+05:30

Suppose you have html page that will display users profile with profile images and if image is not present, automatically missing image icon is appearing, it's looks unprofessional.

We can hide this icon or replace with the default image.

Simply Hide the missing image icon using Javascript:

<img id='ProfileImage' src='/images/1234.png' />

<script type="text/javascript">
var img = document.getElementById("ProfileImage");
img.onerror = function () { this.style.display = "none"; }
</script>

Use Rich Textbox of SharePoint 2007 in a custom asp.net page or user control

2011-10-06T16:18:00.000+05:30

Many times while creating Custom SharePoint Form using ASP.net you need RichTextBox.

In SharePoint Controls there is a InputFormTextBox control that can be used as a RichTextBox. It control give same functionality and user interface as in SharePoint.

Take a look.

1. Add following tag (If you not added before) to Register the SharePoint DLL in your custom page or user control.

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

2. Add InputFormTextBox Control tag on the Page.

<SharePoint:InputFormTextBox runat="server" ID="TxtBody" ValidationGroup="CreateCase" Rows="8" Columns="140" RichText="true" RichTextMode="FullHtml" AllowHyperlink="true" TextMode="MultiLine" />

Enjoy!

Print Button on SharePoint Page

2011-09-27T19:30:00.000+05:30

We can easly add print functionality on SharePoint Page. Just add following Javascript on the page (you can use HTML Form Webpart for adding javascript).

In Javascript i have used WebPartElementID="onetIDListForm" ; which is SharePoint Default ID of the Main contents.

JavaScript:

<script type="text/javascript" language="JavaScript">
//Controls which Web Part or zone to print 'TD ID'
var WebPartElementID = "onetIDListForm"; //SharePoint Main Content ID
//Function to print Web Part
function PrintArea()
{
var bolWebPartFound = false;
if (document.getElementById != null)
{
//Create html to print in new window
var PrintingHTML = '<HTML>\n<HEAD>\n';
//Take data from Head Tag

PrintingHTML += document.getElementsByTagName('head')[0].innerHTML;
PrintingHTML += '\n</HEAD>\n<BODY class="printSQS">\n';
var WebPartData = document.getElementById(WebPartElementID);
if (WebPartData != null)
{
PrintingHTML += WebPartData.innerHTML;
bolWebPartFound = true;
}
else
{
bolWebPartFound = false;
alert ('Cannot Find Web Part');
}
}
PrintingHTML += '\n</BODY>\n</HTML>';
//Open new window to print
if (bolWebPartFound)
{
var PrintingWindow = window.open("","PrintWebPart",
"toolbar,width=800,height=600,scrollbars,resizable,menubar");
PrintingWindow.document.open();
PrintingWindow.document.write(PrintingHTML);
PrintingWindow.document.close();
// Open Print Window
PrintingWindow.print();
}
}
</script>

HTML Code:

<input type="button" value="Print" onclick="javascript:void(PrintArea());return false;__doPostBack('btPrint','')" />

<a href="#" onclick="javascript:void(PrintArea());return false;__doPostBack('btPrint','')" ><img src="/sites/aaa/PublishingImages/print.gif" border="0" complete="complete"/></a>

You can add html code any where on the page.

Quick Notes: How to Detect the Installed Edition of SharePoint 2010

2011-08-25T16:51:00.000+05:30

Many times it is required to know the current edition of SharePoint 2010 installed.

If the behavior of your custom application depends on the installed SKU of Microsoft SharePoint Server 2010, you can determine which SKU of SharePoint Server 2010 is installed locally by using the Power shell command and GUID of SharePoint 2010 Editions.

In this topic I will explain the how to get current edition of SharePoint 2010.

1. You can get GUID of installed SharePoint 2010 from registory within the registry key HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\InstalledProducts.

2. Or You can also use the PowerShell command get-spfarm | select Products to output GUIDs for the installed SKUs.

3. As you get the GUID then you can check it with following table.

SharePoint 2010 Edition	GUID
SharePoint Foundation 2010	BEED1F75-C398-4447-AEF1-E66E1F0DF91E
Search Server Express 2010	1328E89E-7EC8-4F7E-809E-7E945796E511
SharePoint Server 2010 Standard Trial	B2C0B444-3914-4ACB-A0B8-7CF50A8F7AA0
SharePoint Server 2010 Standard	3FDFBCC8-B3E4-4482-91FA-122C6432805C
SharePoint Server 2010 Enterprise Trial	88BED06D-8C6B-4E62-AB01-546D6005FE97
SharePoint Server 2010 Enterprise	D5595F62-449B-4061-B0B2-0CBAD410BB51
Search Server 2010 Trial	BC4C1C97-9013-4033-A0DD-9DC9E6D6C887
Search Server 2010	08460AA2-A176-442C-BDCA-26928704D80B
Project Server 2010 Trial	84902853-59F6-4B20-BC7C-DE4F419FEFAD
Project Server 2010	ED21638F-97FF-4A65-AD9B-6889B93065E2
Office Web Companions 2010	926E4E17-087B-47D1-8BD7-91A394BC6196

Reference Link: http://msdn.microsoft.com/en-us/library/ff721969.aspx

Digital Image Processing - Image Watermarking in C# and Asp.net

2011-08-18T12:24:00.002+05:30

In Today's internet world we see many images, photos, backgrounds etc. we can easily copy and paste them. But we don't know the actual creator of this images.

In this post i am not talking about SharePoint, it's all about C# coding. Just wanted to memorize the old things.

So lets do it....

Image Watermarking - Digital watermarking is the process of embedding information into a digital signal which may be used to verify its authenticity or the identity of its owners, in the same manner as paper bearing a watermark for visible identification. (Thank you wikipedia for this definition.)

I have created a web application that will demonstrate how to create a watermarked image with Text and Logo.

1. Create a Web Application Project in Visual Studio

2.Create layout in Aspx page.

3. Create function called GenerateWatermarkedImage() and add following code in it.

  
Web.config file AppSettings

  
<appSettings >

    <add key="WatermarkImagePath" value="\Images\watermark.gif"/>

    <add key="SampleImagePath" value="\Images\SampleImage.jpg"/>

    <add key="TragetImagePath" value="\Images\TragetImage.jpg"/>

</appSettings>

  
Namespaces used

  
using System;

using System.Configuration;

using System.Drawing;

using System.Drawing.Drawing2D;

using System.Drawing.Imaging;

using System.Web;

  
GenerateWatermarkedImage() Function

  
public void GenerateWatermarkedImage()

{

            // Load
  Source Image

            String
  strSourceImagePath = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["SourceImagePath"]);

            Image
  imgSource = Image.FromFile(strSourceImagePath);

            //Create
  New Bitmap Image

            int
  socWidth = imgSource.Width;

            int
  socHeight = imgSource.Height;

            Bitmap
  bmPhoto = new Bitmap(socWidth,
  socHeight, PixelFormat.Format24bppRgb);

            bmPhoto.SetResolution(72, 72);

            Graphics
  grPhoto = Graphics.FromImage(bmPhoto);

            //Load
  Logo Image

            String
  strLogoImagePath = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["LogoImagePath"]);

            Image
  imgLogo = new Bitmap(strLogoImagePath);

            int
  logoWidth = imgLogo.Width;

            int
  logoHeight = imgLogo.Height;

            //#####################################

            //Step
  #1 - Watermark Text

            grPhoto.SmoothingMode = SmoothingMode.AntiAlias;

            grPhoto.DrawImage(

                imgSource,

                new
  Rectangle(0, 0, socWidth, socHeight),

                0,

                0,

                socWidth,

                socHeight,

                GraphicsUnit.Pixel);

            //Determine
  the largest possible size for WaterMark Text Message

            int[]
  sizes = new int[]
  { 16, 14, 12, 10, 8, 6, 4 };

            Font
  crFont = null;

            SizeF
  crSize = new SizeF();

            string
  strWaterMarkText = TxtWatermark.Text;

            for
  (int i = 0; i < 7; i++)

            {

                crFont = new Font("arial", sizes[i], FontStyle.Bold);

                crSize =
  grPhoto.MeasureString(strWaterMarkText, crFont);

                if
  ((ushort)crSize.Width < (ushort)socWidth)

                    break;

            }

            //String
  Alignment to Center

            int
  yPixlesFromBottom = (int)(socHeight * .05);

            float
  yPosFromBottom = ((socHeight -

                       yPixlesFromBottom) -
  (crSize.Height / 2));

            float
  xCenterOfImg = (socWidth / 2);

            StringFormat
  StrFormat = new StringFormat();

            StrFormat.Alignment = StringAlignment.Center;

            //Draw
  the WaterMark string at the appropriate position

            SolidBrush
  semiTransBrush2 = new SolidBrush(Color.FromArgb(153,
  0, 0, 0));

            grPhoto.DrawString(

                strWaterMarkText,

                crFont,

                semiTransBrush2,

                new
  PointF(xCenterOfImg + 1, yPosFromBottom +
  1),

                StrFormat);

            SolidBrush
  semiTransBrush = new SolidBrush(Color.FromArgb(153, 255, 255, 255));

            grPhoto.DrawString(

                strWaterMarkText,

                crFont,

                semiTransBrush,

                new
  PointF(xCenterOfImg, yPosFromBottom),

                StrFormat);

            //#####################################

            //Step
  #2 - Watermark Logo

            Bitmap
  bmWatermark = new Bitmap(bmPhoto);

  bmWatermark.SetResolution(imgSource.HorizontalResolution,
  imgSource.VerticalResolution);

            Graphics
  grWatermark = Graphics.FromImage(bmWatermark);

            //Translucent
  watermark 

            ImageAttributes
  imageAttributes = new ImageAttributes();

            ColorMap
  colorMap = new ColorMap();

            colorMap.OldColor = Color.FromArgb(255, 0, 255, 0);

            colorMap.NewColor = Color.FromArgb(0, 0, 0, 0);

            ColorMap[]
  remapTable = { colorMap };

  imageAttributes.SetRemapTable(remapTable, ColorAdjustType.Bitmap);

            //Change
  the opacity of the watermark

            float[][]
  colorMatrixElements = { 

                        new float[]
  {1.0f,  0.0f,  0.0f, 
  0.0f, 0.0f},

                        new float[]
  {0.0f,  1.0f,  0.0f, 
  0.0f, 0.0f},

                        new float[]
  {0.0f,  0.0f,  1.0f, 
  0.0f, 0.0f},

                        new float[]
  {0.0f,  0.0f,  0.0f, 
  0.3f, 0.0f},

                        new float[]
  {0.0f,  0.0f,  0.0f, 
  0.0f, 1.0f}

  };

            ColorMatrix
  wmColorMatrix = new ColorMatrix(colorMatrixElements);

  imageAttributes.SetColorMatrix(wmColorMatrix, ColorMatrixFlag.Default,
  ColorAdjustType.Bitmap);

            //Draw
  the watermark

            int
  xPosOfWm = ((socWidth - logoWidth) - 10);

            int
  yPosOfWm = 10;

            grWatermark.DrawImage(imgLogo,

                new
  Rectangle(xPosOfWm, yPosOfWm, logoWidth,

  logoHeight),

                0,

                0,

                logoWidth,

                logoHeight,

                GraphicsUnit.Pixel,

                imageAttributes);

            //Replace
  the original Image with the new Bitmap

            imgSource = bmWatermark;

            grPhoto.Dispose();

            grWatermark.Dispose();

            //Save
  Watermarked Image

            String
  TragetImagePath = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["TragetImagePath"]);

            imgSource.Save(TragetImagePath);

            imgSource.Dispose();

            imgLogo.Dispose();

            ImgWatermarked.ImageUrl = ConfigurationManager.AppSettings["TragetImagePath"]; 

}

4. Watermarked Image

Very good article: http://www.codeproject.com/KB/GDI-plus/watermark.aspx

SharePoint 2010 jQuery: List Scrolling View with Frozen Header

2011-08-17T12:31:00.001+05:30

Problem:

Many times SharePoint List has huge amount of records (Number of items) and it’s hard to scroll out the view. Also while scrolling the page we cannot determine which information is from which column.

Solution:

By simple applying CSS we can achieve the Frozen Headers like Excel Sheet. And for achieving the same we use JQuery.

Implementation:

1. Go to List View Page and Html Form Webpart on the same page.

2. Copy Following code in Html Form Webpart. Just replace the LISTID and VIEWID (Highlighted in yellow color).

<!--

.DataGridFixedHeader { position: relative; top: expression (this.offsetParent.scrollTop); background-color: gray;}

-->

</style>

$(function(){

var $table = $("TABLE[ID^='{F1D2645C-4CC3-458C-BC93-CBCFECD12171}-{5AB46E0C-D38F-4FF2-BBE0-0D485CC351E9}']:first","#MSO_ContentTable");

$table.wrap("<DIV style='OVERFLOW: auto; HEIGHT: " + (screen.height-400) + "px'></DIV>");

$("TR.ms-viewheadertr:first", $table).addClass("DataGridFixedHeader");

});

</script>

Note:
For IE8 and IE9 browsers, require change in CSS class .DataGridFixedHeader as follows.
position: absolute;

Output:

Change look and feel of SharePoint Page using JQuery or Apply business logic to SharePoint List Forms using JQuery

2011-08-09T16:47:00.002+05:30

As SharePoint 2010 gets popular, more and more scenarios are coming which most of required customization.
As we know SharePoint 2010 provides many options to customize the SharePoint Website, some of listed below…

1.   Visual Studio Development
2.   SilverLight Devlopment
3.   ECMA Script Development
4.   JQuery

In this post I am exploring the JQuery Development possibilities in SharePoint 2010.
As jQuery is a fast and concise JavaScript Library. We can easily give dynamic look to SharePoint Website and can also add custom business logic.
Let start the demonstration….

Take a scenario that we have to create Employee Registration Form with Tabular look and also enable disable tabs according to check box or radio button selection.

1.    First of all Download JQuery from jqueryui.com

2. Extract downloaded zip file and Copy all files into SharePoint Site (You can copy all files to Document Library or Can do Drag and drop using SharePoint Designer)

3. Add following JQuery References to master page before </head> tag.

4. Create SharePoint List.
For demo purpose I have created Employees List and added 5-8 columns.

5. Create a new list Form of type New Item.(You can set it as default)

6. Edit List form in Advanced Mode.

7. As we want to display form in tabular, so we have to add JQuery Tab schema as follows ..

<h2 class="demoHeaders"> Employee Registration Form</h2>
<div id="tabs">
    <ul>
        <li><a href="#tabs-1">Personal</a></li>
        <li><a href="#tabs-2">Contact</a></li>
        <li><a href="#tabs-3">Office</a></li>
        <li><a href="#tabs-4">New Hire</a></li>
        <li><a href="#tabs-5">Contractor</a></li>
        <li><a href="#tabs-6">Desktop</a></li>
        <li><a href="#tabs-7">Laptop</a></li>
              </ul>
    <div id="tabs-1">
                   <table border="0" cellspacing="0" width="100%">

                   </table>
              </div>
    <div id="tabs-2">
                   <table border="0" cellspacing="0" width="100%">

                   </table>
              </div>
    <div id="tabs-3">
                   <table border="0" cellspacing="0" width="100%">

                   </table>
              </div>
</div>

8. Modify JQuery Schema, Add columns to respective tab DIV;

9. Open newly create list form in browser; Select edit page from Page Tab.
Add "HTML Form Web Part", go to WebPart properties; add following code using "Source Editor".

10. Output

Conclusion: We can use JQuery in SharePoint 2010; And it takes less time to use JQuery in SharePoint but more time to post a blog on it.

Deploy SharePoint Solutions (WSP) using PowerShell

2011-07-14T14:38:00.000+05:30

PowerShell offers some great advantages while Deploying Solution (WSP) on SharePoint 2010 farm. Microsoft has already created the PowerShell script that is needed, located at:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Config\PowerShell\ Registration\SharePoint.ps1.

You could include this script in your scripts to be run first, or just include the command that registers the snapin:

Add-PSSnapin Microsoft.SharePoint.PowerShell

This article covers one of the most basic tasks one would do when administrating SharePoint: Deploy SharePoint solutions (WSP) and enable/disable features.

Working with Solutions

In the ‘old’ days (let us not forget that the stsadm is still there and we have a lot of SharePoint 2007 installations across the globe), the following stsadm command could be used to add a SharePoint solution to SharePoint:

stsadm –o addsolution –filename “D:\Deploy\MySPSolution.wsp“

We used the following command to deploy the solution once installed to a specific web application:

stsadm –o deploysolution –name MySPSolution.wsp –url http://myspwebappp –allowgacdeployment –immediate

If we would upgrade an existing solution, we would use the following:

stsadm –o upgradesolution –name MySPSolution.wsp –filename “D:\Deploy\MySPSolution.wsp” -immediate

And finally, we used the following commands to retract and delete a specific solution from the web application:

stsadm –o retractsolution –name MySPSolution.wsp –url http://myspwebapp –immediate
stsadm –o deletesolution –name MySPSolution.wsp

Now, let us see how we could do above operations with PowerShell. For this, we use the following PowerShell commands:

Add-SPSolution “D:\Deploy\MySPSolution.wsp“
Install-SPSolution –Identity MySPSolution.wsp –WebApplication http://myspwebapp –GACDeployment

If you would like to add the solution as sandboxed, you would use the Install-SPUserSolution command instead. To upgrade a solution, we specify which solution is to be updated and with which new solution file:

Update-SPSolution –Identity MySPSolution.wsp –LiteralPath “D:\Deploy\MySPSolution.wsp” –GacDeployment

To retract and remove a solution, we use the following commands:

Uninstall-SPSolution –Identity MySPSolution.wsp –WebApplication http://myspwebapp
Remove-SPSolution–Identity MySPSolution.wsp

Working with features

Similarly, commands exist for working with features. The stsadm equivalents:

stsadm –o activatefeature –name MyFeatureName –url http://myspwebapp
stsadm –o deactivatefeature –name MyFeatureName –url http://myspwebapp

Needless to say, there are easy equivalents in PowerShell:

Enable-SPFeature –Identity MyFeatureNameOrGuid –url http://myspwebapp
Disable-SPFeature –Identity MyFeatureNameOrGuid –url http://myspwebapp

As you can see, PowerShell will completely replace stsadm as the administrative command line tool for SharePoint.

Customizing the Office 365 Public Facing Website

2011-05-30T16:25:00.000+05:30

For Customizing the public-facing Website that is available with SharePoint Online for Microsoft Office 365 you should go for following options:

Option 1: Out-of-Box Editing

Option 2: Apply Minimal Master Page and customize it using SharePoint Designer

For customizing website through Out-of-Box you can refer this Article : http://office.microsoft.com/en-us/sharepoint-online-small-business-help/step-3-customize-the-public-facing-website-HA102029499.aspx

When you try to customize the website master page through SharePoint Designer 2010 it will gives you different errors. So to avoid these errors firstly copy Minimal Master Page (Create duplicate file) which is located to /_catalogs/masterpage/minimal.master, then customize it in SharePoint Designer 2010. Apply this customized Master Page to all pages.

This is my 50^th Post On SharePoint Development and may be this will be helpful as pervious 49….

SharePoint 2010 ECMAScript/Javascript IntelliSense in Visual Studio 2010

2011-05-25T12:42:00.001+05:30

Visual studio 2010 provides great IntelliSense for .Net. But for JavaScript and ECMAScript its required some configuration like adding some references.

We need to reference the debug files in our JS library in Visual Studio. Simply type the following four lines at the top of our JS library.

JS File:

/// <reference name="MicrosoftAjax.js" />

/// <reference path="file://C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/TEMPLATE/LAYOUTS/SP.core.debug.js" />

/// <reference path="file://C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/TEMPLATE/LAYOUTS/SP.debug.js" />

/// <reference path="file://C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/TEMPLATE/LAYOUTS/SP.Runtime.Debug.js" />

Application Page:

<% #if SOME_UNDEFINED_CONSTANT %>

<% #endif %>

Note: by using an undefined constant, Visual Studio will provide IntelliSense while the <script> element is omitted from the actual page rendering

Important Note: Use for Development Purpose only, remove these statements when going for production environment deployment.

Hint: If it’s not appearing, press CTRL + Shift + J together to update Jscript IntelliSense.

You can add different debug js files reference and you will find it in LAYOUTS or ISAPI folder of SharePoint 14 Hive.

For more information you can refer this MSDN Articles:

1. Here is the official documentation by Microsoft on how to enable IntelliSense for the ECMAScript object model - How to: Enable ECMA Client Object Model IntelliSense in Visual Studio 2010

2. This will get you most of the IntelliSense that you care about. If something looks like its missing… you will get a list for the appropriate ones by class/namespace can be found here - ECMAScript Class Library - SharePoint 2010

Screen Cast:

Search debug.js files in 14 Hive