Sharepoint Sharings

Find SCA in modern sites

2019-04-05T02:36:00.000-07:00

Hello Everyone,

We all are very keen to learn new features in SharePoint online. I was going to through few which I am going to post in my upcoming articles, but meanwhile I found there is no direct link to add SCA.

You will need to familiarize yourself with SharePoint Online and below is the link to get into SCA page.

https://WebURL/sites/SiteCollectionName/_layouts/15/mngsiteadmin.aspx

Cheers and happy learning.

Open with Windows Explorer in sharepoint

2015-02-16T09:27:00.000-08:00

Hi Friends,

Its a well known issue and I am writing below steps towards troubleshooting.

You can come across any of the below issues :

Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server
Internet Explorer could not open ServerName web folder. Would you like to see its default view instead?
Your client does not support opening this list with windows explorer.
Access Denied

Now lets start investigating it:

We should first check if browser type is what? It works with 32 but IE 6,7,8,9,10. Note that it will not work with 64 bit IE.
Check if webclient service is on in services.msc. Its better if we restart this service.
We should add affected site in IE trusted sites.
Check if root site collection is created. If not, create one.
SharePoint WebDAV have clash with Windows WebDAV service, so stop windows with below steps:

Open Server Manager

On the left side of the panel click on Roles
Scroll down to the “Role Services” section, and click on “Remove Role Services”
Under “web server” uncheck the box next to “WebDav Publishing”
Choose Next, then choose Remove
A reboot will be required

Above steps should resolve your issues. If you are still facing it, please post it here.

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location

2014-12-02T04:38:00.004-08:00

I just came across one of my clients excel issue. When she is trying to open excel file by clicking on it, getting "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location" error. This generally happens if given site is not added as a trusted site in SharePoint central administration. Please go to the central administrations and do the steps mentioned below:

Open Central Web Administration
Click on Manage Service Applications
Click on Excel services Application.
Click on “Trusted file locations”
Add Trusted file

Address textbox write http://
Check Children trusted box under Trust Children
Check User-defined functions allowed under Allow User-Defined Functions

Repeat step 5 with address as https://(I would like to mention here that all their sites are secured(https))

Above steps resolved my issue successfully. Please post queries or comments, if any.

Change content type hub url on managed metadata service

2014-10-28T06:15:00.002-07:00

Hi Friends,

Just come across a requirement of changing content type hub(CTH) url in managed metadata service(MMS). Initially we created a site collection and assigned it as a CTH site. Recently while working on some other stuff, one of the developer deleted the existing site.!!!! Big issue!!!

At the first glance we thought it must be a big issue but i wrote below powershell script to change my new site collection as CTH:

Set-SPMetadataServiceApplication -Identity "MyManagedMetadataService" -HubURI "http://spport01:5555/site/cth/"

Hurdle? I can be resolved!!!!

Post me for your responses and queries.

Create web application and site collection using powershell

2014-09-29T05:48:00.003-07:00

Hi Folks,

Just came across a requirement of creating web application and site collections using power shell, posting it here.

Open an empty notepad file and copy paste below code segment :

Add-PsSnapin Microsoft.SharePoint.PowerShell

#My Parameters

$WebAppName = "MyWebApplication"
$WebAppHostHeader = "http://MyWebHost"
$WebAppPort = 7575
$WebAppAppPool = "AppPool_7575"

# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = "MyDomain\hirwani"

$WebAppDatabaseName = "WSS_Content_7575"
$WebAppDatabaseServer = "MySQLServer\SharePoint"
$template = Get-SPWebTemplate "STS#0"

# Create a new Sharepoint WebApplication

New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL ("http://" + $WebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount ($WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

# Create a new Sharepoint Site Collection

New-SPSite -Name "Root" -Url "http://in-mum-tfsport1:7575/" -Template $template -OwnerAlias "MyDomain\hirwani"

Save this notepad with .ps1 extension. Now execute it, you should get a new web application and site collection created.

Note : Change above parameters as per your requirement. Post here if you have any questions/suggestions.

Adding and activating solution in solution gallery

2014-09-04T03:21:00.000-07:00

Fea days back, i came across this requirement to add solution to site solution gallery. I wrote below code segment :

ClientContext context = new ClientContext("http://in-air-eyshr2:1234/sites/ETD02");

//Activate Publishing feature
//Add wsp from file system to SP solution gallary
Folder destionationFolder = context.Web.GetFolderByServerRelativeUrl("_catalogs/solutions");
FileCreationInformation fci = new FileCreationInformation();
fci.Content = System.IO.File.ReadAllBytes("D:/WSPS/LDTest.wsp");
fci.Url = "LDTest.wsp";
fci.Overwrite = true;
Microsoft.SharePoint.Client.File fileToUpload = destionationFolder.Files.Add(fci);
context.Load(fileToUpload);
context.ExecuteQuery();

//Activate solution
DesignPackageInfo info = new DesignPackageInfo()
{
PackageGuid = Guid.Empty,
MajorVersion = 1,
MinorVersion = 1,
PackageName = "LDTest"
};
Console.WriteLine("Installing design package ");
//Relative Path of Solution Uploaded in Solution Gallery
//string fileRelativePath = "D:/WSPS/testwsp.wsp";
string fileRelativePath = "/sites/ETD02/_catalogs/solutions/LDTest.wsp";
DesignPackage.Install(context, context.Site, info, fileRelativePath);
context.ExecuteQuery();
Console.WriteLine("Applying Design Package!");
DesignPackage.Apply(context, context.Site, info);
context.ExecuteQuery();

and it gave me following output:

You can give me your suggestions or post relevant questions, if any

Learning SharePoint 2013

2013-12-17T02:50:00.003-08:00

As SharePoint 2013 hits the floor, let's start learning it as soon as possible. To start with we need to learn it's basic structure.

It's based on .Net framework 4.5. The major changes are in the development area where Microsoft has launched App model which i am going to discuss more in my coming posts. Basic look & feel will be as below:

If we go to Site Settings:

Other major enhancements are

Continuous Crawl: There has been a major upgrade to the crawling and indexing components in SharePoint Search. Now each and every document would be available to user instantly.

Cross-site Publishing: Cross-site publishing lets you store and maintain content in one or more authoring site collections, and display this content in one or more publishing site collections. When you change the content in an authoring site collection, those changes are now displayed on all site collections that are reusing this content.This feature helps ensure content is consistent when shared across several different areas and sites.

SkyDrive: Users can now share documents and files from a personal SkyDrive or keep them secured for their personal use. SkyDrive files can still be indexed and located through search if they have been shared to that user.

Add Entries in Web.Config File in SharePoint 2010

2013-09-25T06:58:00.001-07:00

It may depend on core client requirment to modify the configuration files. I came across such requirment and below is the way to modify your configuration file. Remember one thing, before doing this activity first you take a backup of your configuration file.

First add SharePoint administration namespace using below segment:
using Microsoft.Sharepoint.Administration;

Now you can write below code segment on a button's click event.

SPWebService service = SPWebService.ContentService;

SPWebConfigModification myModification = new SPWebConfigModification();
myModification.Path = "configuration/SharePoint/SafeControls";
myModification.Name = "SafeControl[@Assembly='MyCustomAssembly'][@Namespace='MyCustomNamespace'][@TypeName='*'][@Safe='True']";
myModification.Sequence = 0;
myModification.Owner = "User Name";//In my case i used System account
myModification.Type = SPWebConfigModification.SPWebConfigModificationType.EnsureChildNode;
myModification.Value = "<SafeControl Assembly='MyCustomAssembly' Namespace='MyCustomNamespace' TypeName='*' Safe='True' />";
service.WebConfigModifications.Add(myModification);

service.Update();
service.ApplyWebConfigModifications();

Content Query not visible in SharePoint 2010

2012-08-20T10:54:00.001-07:00

Content Query is a needful webpart in Sharepoint as it relates with user very smoothely.If you are not able to see this webpart in your gallary under Content, then turn on "SharePoint Server Publishing Infrastructure" in your top level site collection administration.After this step, turn on "SharePoint Server Publishing" feature in your affected site.

NOTE: No need to go to central admin for this solution.

If you are getting any error while doing any of the above activity(as i was) then lets open PoweShell(CMD) and try below stsadm commands and will do you work:

(to activate top level site collection feature)
stsadm -o activatefeature -name publishingResources -url "SiteCollectionURL" -force

(to activate publishing feature in affected site)
stsadm -o activatefeature -name PublishingWeb -url "Affected Site URL" -force

Hope this will work.

All the best

Deploy sharepoint webpart to bin

2012-03-16T02:41:00.001-07:00

Simply put, I had three web parts that I wanted to package up as features into a .wsp so I could run stsadm to deploy them to different environments, such as q/a and production. I followed the following two steps:

First, I used WSPBuilder to create my wsp, packaging the web parts into features. I also indicated at this point that I wanted it to be a bin deployment.
Once the web part assembly dll was deployed to bin, I made the required CAS policy changes, otherwise the web parts wouldn't run. This involved a policy file and the web.config.

So, as far as step 1 goes, there are few things that will need to be done:

Create an 80\bin\ folder in your solution explorer.
Change your project's Build Output Path to that new folder.
Change AssemblyInfo.vb to import System.Security and also to AllowPartiallyTrustedCallers.
Create a mirror folder structure to the 12 hive in Solution Explorer: 12/Template/Features with a folder below that for each web part/feature to be deployed. Ensure each web part/feature folder has a feature.xml, elements.xml, and .webpart.
Download WSPBuilder and install it. It will be added to the Tools menu. Click Tools -> WSPBuilder - Build WSP. The manifest.xml will be autogenerated and added to the .wsp along with the assembly's dll, and the web parts' feature.xml, elements.xml, and .webpart files.
Run stsadm on the resulting .wsp to add solution, deploy solution, then activate the features.

Finally, step 2 involves setting the proper CAS permissions:

Make a copy of wss_minimaltrust.config (in 12/CONFIG on server) and edit this copy as it will be the required custom policy file we need.
Add a reference to SharePointPermission in the <SecurityClasses> section.
Add a new custom permission set that lists the required permissions. Copy and paste the permission set SPRestricted, and in the new copy, add a line for SharePointPermission.
Next, add a code group that links the newly created permission set with your assembly, so SharePoint knows when to apply the permissions.
Finally, hop over to your web.config and make sure its using custom trust level, and that custom trust level is pointing to your new policy file.

If you want a step-by-step with code to copy/paste, you can find it here at How to deploy a SharePoint web part to bin. You will also find links to other pages that also show how to do this.

Create a SPlist and its SPView in SharePoint writing C# code against WSS object model

2012-03-14T03:08:00.000-07:00

Create a SPlist and its SPView in SharePoint writing C# code against WSS object model

How to create a SPlist and its SPView in SharePoint writing C# code against the WSS object model ?

Assume you want to create the list and its view when activating a SharePoint Feature.

public class myFeatureReceiver : Microsoft.SharePoint.SPFeatureReceiver

{

public override void FeatureActivated(SPFeatureReceiverProperties properties)

{

using (SPWeb web = properties.Feature.Parent as SPWeb)

{

System.Diagnostics.Debug.WriteLine("Creating the list");

//web.AllowUnsafeUpdates = true; //use this in an application page no need in a dll

web.Lists.Add("Customers", "Store informations about my Company Customers",SPListTemplateType.GenericList);

web.Update();

System.Diagnostics.Debug.WriteLine("Creating the Fields");

SPList myNewList = web.Lists["Customers"];

myNewList.Fields.Add("First Name", SPFieldType.Text, false);

myNewList.Fields.Add("Last Name", SPFieldType.Text, false);

myNewList.Fields.Add("Adress", SPFieldType.Text, false);

myNewList.Fields.Add("City", SPFieldType.Text, false);

myNewList.Fields.Add("Latest Purchase Date", SPFieldType.DateTime, false);

myNewList.Fields.Add("Sales Comments", SPFieldType.Note, false);

myNewList.Update();

System.Diagnostics.Debug.WriteLine("Creating the view");

System.Collections.Specialized.StringCollection strColl = newSystem.Collections.Specialized.StringCollection();

strColl.Add("Title");

strColl.Add("First Name");

strColl.Add("Last Name");

strColl.Add("Adress");

strColl.Add("City");

strColl.Add("Latest Purchase Date");

strColl.Add("Sales Comments");

myNewList.Views.Add("Summary", strColl, @"", 100, true, true, Microsoft.SharePoint.SPViewCollection.SPViewType.Html, false);

myNewList.Update();

}

References

SPViewCollection.Add Method (MSDN - Microsoft.SharePoint)

Views.AddView Method (MSDN - Views Web Services)

What are Content Type

2012-03-14T01:32:00.003-07:00

What is a Content Type then?
A content type is an object that is stored within MOSS that defines several elements of a piece of content, including:

Document Template that the content will be based on
Columns that the content will have associated with it (metadata)
Workflows that the content will use
Information Management policies that apply to the content
Conversion types for the content

This picture shows the site-wide admin interface for managing content types

Every piece of list or library content in MOSS is created from a content type. There are a load of out-of-the-box content types like ‘Blank Document’ or ‘Announcement’ and you can create your own (without any code or customisation, it is done through the admin UI).
So how do you apply them?
Content Types are created centrally and then they can be applied to lists and libraries throughout your site.
This picture shows the list-based interface for adding content types to a list or library

What does this mean for users?
This means that users can now create an expense report by simply choosing ‘expense report’ from the new item button on the library. Their new expense report will be created from the central content type with the document template and all the columns and workflow that are associated with the content type.
This pictures show the net result of content types; the ability for users to choose what type of content they wish to create
The important thing to note here is that the content will inherit all of the columns and workflow that comes with the content type – even if the library does not.
For example, if you have a standard document library that just has the ‘blank document’ content type associated with it (which is the default) it will not have any columns or workflows. However if you add the ‘expense report’ content type to the library, items created from that content type will have all of the columns and workflows that are required by the content type. These columns can be used in the same way as list-based columns.
Why should you get excited?
The easiest way to demonstrate this is to compare SharePoint Server 2007 against SharePoint Portal Server 2003 functionality.
Document Templates:

In 2003 you needed some third party or community supported code to use anything more than the single template that is defined for each library
In 2007 you can choose to include multiple content types (each with their own template) within a library using simple configuration

Metadata (Columns):

In 2003, all items in a library have to use the same metadata columns. This restricts your library design to specific types of content rather than administrative or logical libraries structures
In 2007, the content in a library can be whatever type you like without compromising the metadata of that content because each content type brings it’s own set of columns

Workflow:

OK, so 2003 did not have workflow. But it did have Document Library Event Handlers which were used for workflow. Again these event handlers applied to the entire content of a library, not specific documents
In 2007, the content brings the workflow that it needs with it, regardless of where it is stored. Work flows are included as part of the contenyt type, not the library (allthough they can also be set on thr library)

Search:

In 2003, there was no easy way of differentiating different types of content other than relying on column values being filled out
In 2007, you can search on ‘where content type = x’, i.e. ‘give me all the expense reports written by Jo Blogs’

This was only a brief summary, I hope it was useful. Please comment if you need clarification, found it usefull, good but do this different etc ….

Reinstall microsft diagnostics services

2012-03-13T09:47:00.004-07:00

Go to Start -> All program -> Microsoft Office ->Microsoft Office Tools -> Microsoft Office Diagnostics ->
Click on continue and follow the steps.

Getting Names and Email Addresses from Active Directory Groups

2012-03-13T09:34:00.000-07:00

1: public static StringDictionary GetGroupMembers(string GroupName, string UserName, string Password)

   2: {

   3:     try

   4:     {

   5:         StringDictionary ReturnArray = new StringDictionary();

   6:         DirectoryEntry deDirEntry = new DirectoryEntry("LDAP://LDAPDOMAIN",

   7:                                                            UserName,

   8:                                                            Password,

   9:                                                            AuthenticationTypes.Secure);

10:

  11:         DirectorySearcher mySearcher = new DirectorySearcher(deDirEntry);

  12:         mySearcher.PropertiesToLoad.Add("distinguishedName");

13:

  14:         string sFilter = String.Format("(&(objectcategory=group)(cn=" + GroupName + "))");

15:

  16:         mySearcher.Filter = sFilter;

  17:         mySearcher.Sort.Direction = SortDirection.Ascending;

  18:         mySearcher.Sort.PropertyName = "cn";

19:

  20:         SearchResult result;

  21:         DirectoryEntry ResultEntry;

22:

  23:         result = mySearcher.FindOne();

  24:         ResultEntry =result.GetDirectoryEntry();

25:

  26:         GroupName=ResultEntry.Properties["distinguishedName"].Value.ToString();

27:

  28:         mySearcher = new DirectorySearcher(deDirEntry);

  29:         mySearcher.PropertiesToLoad.Add("cn");

  30:         mySearcher.PropertiesToLoad.Add("mail");

31:

  32:         sFilter=String.Format("(&(memberOf={0}))", GroupName);

  33:         mySearcher.Filter = sFilter;

  34:         mySearcher.Sort.Direction = SortDirection.Ascending;

  35:         mySearcher.Sort.PropertyName = "cn";

  36:         mySearcher.PageSize = 1000;

37:

  38:         SearchResultCollection results;

  39:         results = mySearcher.FindAll();

40:

  41:         foreach (SearchResult resEnt in results)

  42:         {

43:

  44:             ResultPropertyCollection propcoll = resEnt.Properties;

  45:             string Name="";

  46:             string Email="";

  47:             foreach (string key in propcoll.PropertyNames)

  48:             {

  49:                 if (key == "cn")

  50:                 {

  51:                     foreach (object values in propcoll[key])

  52:                     {

  53:                         Name=values.ToString();

  54:                     }

  55:                 }

  56:                 else if(key=="mail")

  57:                 {

  58:                     foreach (object values in propcoll[key])

  59:                     {

  60:                         Email=values.ToString();

  61:                     }

  62:                 }

  63:             }

  64:             ReturnArray.Add(Name,Email);

  65:         }

  66:         return ReturnArray;

  67:     }

  68:     catch

  69:     {

  70:         return null;

  71:     }

  72: }

Sharepoint dll location

2012-03-13T07:53:00.000-07:00

Physical location of Sharepoint dll is :

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI

Enjoy..............

Site Defination and its component

2012-03-13T07:44:00.002-07:00

Site Definitions in SharePoint 2007

For one of our clients we need to build custom site definitions. When building SharePoint solutions the terms site template, definition and to a lesser extent site portal are often used. Each of these allows the user to create a new site with a predefined set of Content Types, Layouts, and Lists etc. In the case of the Portal, it allows the user to create a site and one or more nested child sites.

Site definitions are our preferred way to develop custom sites. A portal definition is a variation of the Site Definition except that the definition describes a series of sites to be created. An example of this is the Site Collection Publishing Template, which creates a root site collection, a News sub site, a Documents sub site and some others.

The focus of this article is on how site definitions and Portal definitions can be created and deployed. Site definitions are usually deployed as a part of a solution package, which is a compressed cabinet file made up of XML files and other resources. Solution packages are first added and then deployed to the MOSS farm. Once deployed the contents of the solution can be made available to sites, or used to create new sites.

The Solution Package can also deploy Site Features. A Site Feature can do myriad things, such as deploying a new web part, defining a new content type, site column, list type, adding a new page layout, or even a graphic image. Site Features can then be activated in a site, or automatically applied in a new site definition. We typically deploy several features as part of the new site definition, as this allows multiple developers to work together without interfering with one another. The solution and feature methodology is a powerful new model for MOSS and is used by Microsoft to build and extend MOSS.

CREATING A SITE DEFINITIONTo create a site definition the first step is to create the “WebTemp” file. The purpose of the webtemp file is to describe to SharePoint the new Site Definition or Site Portal Definition. After the WebTemp file, the Site Definition file should be created, this is known as the ONET.XML file. Each Site Definition contains one or more configurations of lists and features. A site Definition can also point to a Portal Definition. The portal definition uses one or more site definitions. The relationship of files is shown below:

WEBTEMP FILE
All the webtemp files are XML files which live in the <12-hive>\TEMPLATES\1033\XML. The webtemp file can be thought of as Meta data or a description of a Site Definition. For example, the file contains the name of the site definition, as displayed in the Create Site page in a site or the Create Site Collection page in Central Administration.

Each Site Definition description is in a <Template> node that contains one or more configuration nodes. The name assigned to a Template must match the name of a directory in the <12-hive>\TEMPLATE\SiteTemplates directory. SharePoint then looks for the ONET.XML file in a subdirectory called XML to find the actual Site Definition. The ID of the Template must be unique across the SharePoint installation. The following is a sample template definition:

<Configuration ID="0"

Title="Syrinx Root"

Description="This site is intended to be the root site collection for a Syrinx portal."

Hidden="TRUE"

ImageUrl="/_layouts/images/stsprev.png"

DisplayCategory="Syrinx"

RootWebOnly="True"/>

</Template>

The Configuration declaration can define if the site definition can be used for a site root collection only, a sub web site only or both. This provides a level control on how the site definition can be used, and provides a mechanism to control how certain features are enabled.
In the case of a Portal definition, the webtemp template configuration adds some additional attributes:

<Configuration ID="0"

Title="Syrinx Portal Site"

Type="0"

Hidden="FALSE" ImageUrl="/_layouts/1033/images/template_corp_intranet.png"

Description="This site is the definition of the Syrinx Portal collection."

ProvisionAssembly="Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

ProvisionClass="Microsoft.SharePoint.Publishing.PortalProvisioningProvider"

ProvisionData="SiteTemplates\\WebManifest\\PortalWebManifest.xml"

RootWebOnly="TRUE"

DisplayCategory="Syrinx"/></Template>

The attributes of interest are the ProvisionAssembly, ProvisionClass and ProvisionData. When creating a Portal site the class specified by the ProvisionClass attribute is called in the assembly specified by the ProvisionAssembly. The class is passed the value of the ProvisionData attribute as a parameter. Microsoft provides an implementation of a Provisioning Class. The Microsoft Provisioning Class (MPC) is used to create a Portal Site.

The MPC expects the ProvisionData value to be the path to an XML file, which contains instructions on the sites to create as part of the Portal Definition. This methodology is used to create the Publishing Site, which creates several sub sites. By looking in the PortalWebManifest.xml file specified above, it can be seen that four sites are created, News, Site Directory, Search Center, and Document center. Below is a sample Syrinx Portal Provisioning Data XML file.

<web name="Syrinx Root"

siteDefinition="SPPR#0"

displayName="Syrinx Portal Display Name"

description="Syrinx Watch Portal Description">

<webs>

<web name="NorthEast"

siteDefinition="SPRegion#0"

displayName="North East"

description="North East Site Description">

<webs>

<web name="Massachusetts"

siteDefinition="SPState#0"

displayName="Massachusetts"

description="Massachusetts Site Description"/>

</webs>

</web>

<web name="SouthEast"

siteDefinition="SPRegion#0"

displayName="South West"

description="South West Site Description"/>

</webs>

</web>

</portal>

This file declares the top-level site that is to be created, and it uses the SPPR#0 site definition. This is a reference back into the webtemp files; it is referencing a site definition template called “SPPR” and from that definition use configuration “0”, the display name and description of the root level site are overwritten by the values entered by the user when the site is created. Nested below this site, are two child sites that use configuration 0 from the SPRegion site definition, the North East and South East regional sites. Below the North East regional site is a sub site called Massachusetts, which uses configuration 0 from the SPState site definition.

ONET.XML FILEThe onet.xml file contains the actual site definition and is broken in to several sections, navigational areas, list templates, document templates, configurations, modules, components, and server e-mail footer. The MSDN documentation provides an good reference on the structure and contents of an onet.xml file (seehttp://msdn2.microsoft.com/en-us/library/ms474369.aspx). The best way to create a new onet.xml file is to copy one from the site templates directory which is close to what you need and then modify it to suit your needs. Below is an overview of the sections within the onet.xml file.

Click here for more details

The wrong way to iterate through SharePoint SPList Items

2012-03-13T07:36:00.000-07:00

Lets start by looking at a code snippet that can be used in a WebPart to access the first 100 items from the SharePoint list of the current context:

SPList activeList = SPContext.Current.List;
for(int i=0;i<100 && i<activeList.Items.Count;i++) {
  SPListItem listItem = activeList.Items[i];
  htmlWriter.Write(listItem["Title"]);
}

Assuming that there are at least 100 items in the list. How many roundtrips to the database is this code going to make in order to retrieve the 100 Title’s of the first 100 SharePoint list items? You might be surprised. Its a total of 200 database calls as you can see from the database view when analyzing the transaction executing the above code:

200 SQL Statements get executed when iterating through SPList.Items

The reason for that is because in every loop we request a new SPListItemCollectionobject when accessing the Items property. The Items property is not cached and therefore always requests all items from the database again. Here is how the first loop iterations look like in the PurePath:

Every access to the Items property executes the same SQL statement again

The CORRECT way to do it

The correct way to do it is of course to store the Items property return value in a SPListItemCollection variable. With this the database is only queried once and we will then iterate over the result set that is stored within the collection object. Here is the changed sample code:

SPListItemCollection items = SPContext.Current.List.Items;
for(int i=0;i<100 && i<items.Count;i++) {
  SPListItem listItem = items[i];
  htmlWriter.Write(listItem["Title"]);
}

Resulting in the following PurePath.

Storing the Items property in a variable elminiates 99.5% of the database calls

Conclusion

Many properties in SharePoint return new object instances every time you access them. In order to build good software based on the Microsoft SharePoint Platform its necessary to understand what is going on under the hood. This will eliminate “surprises” once your custom code is first executed with real life data.

There are additional ways to optimize access to data stored in SharePoint lists. I will cover that in my next posts.

Add item to splist

2012-03-13T07:03:00.000-07:00

Here is the code snippet:

using(SpSite site=new SPSite("Server"))
{
using(SpWeb web=site.OpenWeb())
{
SpList list=web.Lists["ListName"];
SpListItem item=list.Items.Add();

item["Title"] = "testTitle";

item["Description"]="test";

item.Update();

}
}

Enjoy

When should I use SPSecurity.RunWithElevatedPrivileges?

2012-03-13T05:36:00.000-07:00

It is very importent to understand why and when to use SPSecurity.RunwithElevatedPrivilages.When we want to retrive or update the data where a normal user don't have permission,there we use this code segment. How this exactly works is like SPSecurity.RunWithElevatedPrivileges runs current process under application pool identity and it allows users to add/update item in list,library or site.

Example

SPSecurity.RunWithElevatedPrivileges(delegate()
{
    using (SPSite site = new SPSite(web.Site.ID))
    {


      // site will be based on the rights for the system account

    }

});

For more details click here

Base class used while creating a webpart

2012-03-13T05:26:00.000-07:00

There are two base classes which are going to be consumed by sharepoint can inherit from, either the sharepoint base class or ASP.NET2.0 Webpart base class.When inheriting from sharepoint base class your derived webpart will inherit from Microsoft.Sharepoint.WebPartPages.WebPart base class. When ingeriting from ASP.Net 2.0 webpart base class, your derived webpart will use System.Web.UI.WebControls.WebParts.WebPart . It is preferable to use ASP.NET base class as old base class is meant of backward compatibility with previous version of sharepoint.However there are four exception when it is better to leaverage functionality from sharepoint webpart base class.
These are the scenarios:

Cross Page connection.
Connection between webpart that are outside webpart zone.
Client side conection.
data-cachieng infrastructure

for any further detail,you can post your query.

Sharepoint 2010 enhancements

2012-03-12T07:00:00.000-07:00

Sharepoint 2010 is very dynamic and more user friendly portal.

User interface:Microsoft has worked very hard on this control.This makes easy access to your need on List,Library or pages.For details click here

Developer view: from developer point of view also this has enlarged on very large scale.Like we have more classes,Web Parts and sevices.For more details click here.

Use the SharePoint 2010 Managed MetaData Service?

2011-12-15T04:26:00.000-08:00

In Sharepoint 2007 content type globalization was not possible.Content Type Globalization means we create content type in one site collection and we can use this content type in other site collection just by following small steps.
For detail information look This Video

Rypple Lets You Reward Employees On Big Screen

2011-09-06T07:19:00.000-07:00

Rypple Lets You Reward Employees On Big Screen