Interview Questions and Answers of SharePoint for Developers - Part IIII

Part 1 Part 2 Part 3 Part 4

Q. How would you
pass user credentials while using SharePoint WebService from your Web Part or

The web service needs credentials to be set
before making calls.


listService.UseDefaultCredentials =
true; // use currently logged on user

listService.Credentials = new
System.Net.NetworkCredential("user", "pass", "domain"); // use specified

Q. How would you remove a
webapart from the WebPart gallery? Does it get removed with Webpart

No, Webpart does not get removed from the WebPart
gallery on retraction. You can write a feature receiver on Featuredeactivating
method to remove the empty webpart from the gallery.

Q. What
is a SharePoint Feature? Features are installed at what scope

Ans. A SharePoint Feature is a functional
component that can be activated and deactivate at various scopes throughout a
SharePoint instances, scope of which are defined as
1. Farm level 2. Web
Application level 3. Site level 4. Web level
Features have their own receiver
architecture, which allow you to trap events such as when a feature is
Installing, Uninstalling, Activated, or Deactivated.

Q. What type of components can be created or
deployed as a feature?

We can create menu commands, Custom
Actions,page templates, page instances, list definitions, list instances,event
handlers,webparts and workflows as feature.

Q. How Do you bind a Drop-Down Listbox with a Column
in SharePoint List ?

Method 1
You can get a datatable for all items in the list and add that table
to a data set. Finally, specify the dataset table as datasource for dropdown

Method 2 : You can also use SPDatasource in
your aspx or design page.
See Code example Binding Drop-Down with Sharepoint List data

Q. How Does SharePoint work?

browser sends a DAV packet to IIS asking to perform a document check in.
PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it has the
proprietary INVOKE command. Because of the existence of this command, the packet
is passed off to msdmserv.exe, who in turn processes the packet and uses EXOLEDB
to access the WSS, perform the operation and send the results back to the user
in the form of XML.

Q. What is

Ans. CAML stands for
Collaborative Application Markup Language and is an XML-based languagethat is
used in Microsoft Windows SharePoint
Services to define sites and lists, including, for Eg, fields, views, or forms,
but CAML is also used to define tables in the Windows SharePoint Servies
database during site provisioning. Developers mostly use CAML Queries to
retrieve data from Lists\libraries.

Q. Can you
display\add a Custom aspx or WebApplication Page in SharePoint Context

You need to make some modification in the aspx file to
display it in SharePoint Context. Firstly, add the references for various
sharepoint assemblies on the Page. Then wrap the Code in PlaceHolderMain
contentPlaceholder, so that it gets displayed as a content page. Lastly, add a
reference to SharePoint Master Page in aspx file and swicth it in Code behind if
needed. See Code Example at Display aspx Page in SharePoint context

Part 1 Part 2 Part 3 Part 4

How To Add Custom aspx Page in Sharepoint 2010

Add Custom aspx Page in Sharepoint 2010

Adding aspx Page in SharePoint
2010 is much easier than what it was in SharePoint 2007.

You will start
with Creating a Empty Project in VS 2010 and then will add a aspx page as a new
Item. VS 2010, as you may know will automatically create all the required
solution package files (along with feature files) for easy deployment of our
aspx page.

You would however, would need to modify the aspx page to add
Contentplaceholders so that the Page can be displayed in sharePoint context( I
mean with SharePoint master Page and left nav and ribbion and stuff.. not sure
if ribbon will work though) and also will have to create a folder structure i.e
Templates\Layouts\ for the correct deployment of our aspx page.

to begin with

1. Open VS 2010 and create a empy Project

2. Create
a folder structure in your project as Template\Layouts\MyCustomFolder

Now, Right Click on the Project and add a New Item

Now, to add a new aspx page in our MyCustomFolder click on General tab on the
left navigation of the window and choose Text File. Rename the Text file to
MyCustomPage.aspx. Alternatively, you can click on Web and that will add aspx

Since, we have created a aspx page from a text file you will have to add all the
markup tags for the Page. The tags should also include sharePoint assemblies and
some content Place holders are need so that the page is displayed in sharePoint
context i.e like other content pages with master page and left amd top
naviagtion. See the Post : Deploy
Custom aspx page in SharePoint

:If you are using some code behind with your aspx page, then change the Inherit
tag in the aspx page to inherit
from the assembly of the project.

For e.g. change the tag

Inherits="NameSpace.Class, NameSpace, Version=,
Culture=neutral, PublicKeyToken=2ef8d0c4bab8980b" Debug="true".

You dont
need to deploy .cs file with the Project. The code is accessed via its .dll

6. Now you are all set to deploy the Project so build the project and
Also, make sure the manifest file do contain an entry for your custom
page in its tag.

Test your new custom page in sharePoint by
using the below url
http://SP server/_layouts/Custompage.aspx.

Posts :
and Deploying Custom aspx Page in SharePoint 2007

Adding a Custom aspx Page to Sharepoint 2007

To Create and add the custom.aspx Page in sharePoint 2007 as Solution Package
see the Post : Create and Deploy Custom aspx Page as Feature and Solution Package of SharePoint 2007

To Create
and Add Custom aspx Page in SharePoint 2010 see : Add
Custom aspx Page in Sharepoint 2010

To display your custom aspx page
in SharePoint Context i.e with SharePoint master Page and left navigation ...
you need to make below changes in your aspx page.

Steps are :

Add the references for various sharepoint assemblies.

2. wrap the
code(javascript,controls..) in PlaceHolderMain so that it gets displayed as a
content page.

3. Switch the master page in pageinit() method in code
behind. // if you need to switch it to your own custom master

See the image below for aspx changes

addition to the the PlaceHolderMain, add two more placeholders with the id as
PlaceHolderPageTitle and PlaceHolderPageTitleInTitleArea

To swicth
the master page in code behind see below

To Create and add the custom.aspx Page in
SharePoint 2007 as Solution Package see the Post below

Create and Deploy Custom aspx Page as Feature and Solution Package of SharePoint 2007

Binding Drop-Down with Sharepoint 2007 List data

Method 1:

DataSet ds = new DataSet();

SPSite mySite =
SPWeb myWeb = mySite.OpenWeb();

SPList list =
DataTable DTable_List =
DTable_List.TableName =

DropDownList.DataSource =
DropDownList.DataTextField =
DropDownList.DataValueField =
DropDownList.SelectedIndex =


Method 2: Using

Interview Questions and Answers of SharePoint for Developers - Part III

Part 1 Part 2 Part 3 Part

Q. What files gets
created on a file system, when a Site collection is created

SharePoint Services does not create any files or folders on the file system when
the site collection or sites are created; everything is created in the content
database. The Pages for the site collection are created as instances in the
content database. These instances refer to the actual file on the file

Q. What are Customized and Uncustomized Files in
SharePoint ?

are two types of Pages in SharePoint; site pages (also known as content pages)
and application pages.

Uncustomized :

When you create a new
SharePoint site in a site collection, Windows SharePoint Services provisions
instances of files into the content database that resides on the file system.
That means if you create a new Site "xyz" of type Team Site(or Team sIte Definition), an instance
of the Team Site Definition( Which
resides on the File System), i.e. "xyz" gets created in the Content database.
So, When ASP.NET receives a request for the file, it first finds the file in the
content database. This entry in the content database tells ASP.NET that the file
is actually based on a file on the file system and therefore, ASP.NET retrieves
the source of the file on the file system when it constructs the

Customized :

A customized file is one in which the source of
the file lives exclusively in the site collection's content database. This
happens When you modify the file in any way through the SharePoint API, or by
SharePoint Designer 2007,which uses the SharePoint API via RPC and Web service
calls to change files in sites. So, When the file is requested, ASP.NET first
finds the file in the content database. The entry in the database tells ASP.NET
whether the file is customized or uncustomized. If it is customized, it contains
the source of the file, which is used by ASP.NET in the page contraction

Q. What are event

Event receivers are classes that inherit from
the SpItemEventReciever or SPListEventReciever base class (both of which derive
out of the abstract base class SPEventRecieverBase), and provide the option of
responding to events as they occur within SharePoint, such as adding an item or
deleting an item.

Q. When would
you use an event receiver?

Since event receivers respond
to events, you could use a receiver for something as simple as canceling an
action, such as deleting a document library by using the Cancel property. This
would essentially prevent users from deleting any documents if you wanted to
maintain retention of stored data.

Q. If I wanted to restrict the deletion of the
documents from a document library, how would I go about it?


You would create a event receiver for that list/library and implement the
ItemDeleting method. Simply, set: properties.Cancel= true and display a friendly
message using Properties.Message("How can u delete this... Its not your

Q. What is the difference between an asynchronous and
synchronous event receivers?

An asynchronous event occurs after
an action has taken place, and a synchronous event occurs before an action has
take place. For example, an asynchronous event is ItemAdded, and its sister
synchronous event is ItemAdding

How do you Increase trust level for a single WebPart in the WebConfig

To list a Web Part with Full Permissions within
your Web Application while still retaining a WSS_Minimal permission set for all
other Web Parts, You need to create a Custom policy file. This file will be then
referenced in SharePoint Web.config file and will allow your specific webpart to
be of Full trust.
Steps :
1. Make a copy of the WSS_Minimal.Config file
from the 12\Config folder and paste it into the same folder renaming it to
Custom_WSS_Minimal.Config. Now, edit the Custom_WSS_Minimal.Config file using
NotePad. Obtain the Public Key Token for the Web Part assembly that you want to
deploy, using the following command: sn –Tp filename.dll. Create a new entry in
your Custom_WSS_Minimal.Config file for your WebPart. Save the File.
Create a new TrustLevel element for your config file in the Web.Config called
Custom_WSS_Minimal that points to your custom file in the 12\config folder.
Recycle the Application Pool and You're Done.

Q. How does Windows SharePoint Services help render
the Webapplictaion in ShrePoint?

When a new web applictaion is created
via Central Admin, Windows SharePoint Services creates a new Web application in
IIS. Then the WSS, loads the custom HTTP application and replaces all installed
HTTP handlers and modules with Windows SharePoint Services–specific ones. These
handlers and modules essentially tell IIS to route all file requests through the
ASP.NET 2.0 pipeline. This is because most files in a SharePoint site are stored
in a Microsoft SQL Server

Part 1 Part 2 Part 3 Part

Interview Questions and Answers of SharePoint for Developers - Part II

Part 1 Part 2 Part

Q. When do you use
SPSiteDataQuery ?

Ans. You
can use SPSiteDataQuery when you need to extract data from more than one
list\library in your site colletcion. The data is extracted on the basis of the
query you write and is
returened as a Datatable. You can also specify the
GUID for the lists\libraries you want to query against.

Q. How do you create a Custom action for an item in a
list ?

Ans. This can be
done by adding a new feature into SharePoint. You would need to use customaction
tag in your elements.xml file and will have to set various properties like
imageurl or UrlAction for your customaction. You can later add this feature into
sharepoint using stsadm install feature command.

Q. How would you bind this CustomAction to a specific
list ?

Ans. To do this you
can either create a new list type(again a feature) and use the listtype number
for the new list in your RegistrationType property of the Customaction. The
CustomAction will then show up only for the items of this list type. or You can
create a new content type and then use that content type's id in your
cutsomaction to bind the custom action to items of just that content type. Add
the new content type to the list where you need this customaction.

Q. How will you deploy an existing webapplication or website in SharePoint?

You would
need to wrap the web application in a solution package in order to deploy it in
12 hive or say ShraePoint. It is recommended to create a feature first, and then
wrap everything in a Solution package. See example Create and Deploy Custom aspx Page as Feature and Solution Package of SharePoint 2007

Q. How will you cancel a deployment from central admin
-> solution managment, if its stuck at "deploying" or "Error".

You can either try to force execute timer jobs using
execadmsvcjobs command or can cancel the dpeloyment using stsadm command stsadm
–o cancaldeployment –id {GUID} command. The Id here would be GUID of the timer
or deployment job. You can get the Id from stsadm enumdeployment command. This
will display all the deployments which are process or are stuck with Error.

Q. How do make an existing
non-publishing site Publishing?

You can simply activate the
SharePoint Publishing Feature for the Site, you want to make publishing.

Q. Can you name some of the tools
used for SharePoint Administration?

What Tools Are Used for SharePoint Administration?

Q. What are Application Pages in SharePoint?

Unlike site pages (for example, default.aspx), a
custom application page is deployed once per Web server and cannot be customized
on a site-by-site basis. Application pages are based in the virtual _layouts
directory. In addition, they are compiled into a single assembly DLL.
A good
example of an Application Page is the default Site Settings page: every site has
one, and it's not customizable on a per site basis (although the contents can be
different for sites).
With application pages, you can also add inline code.
With site pages, you cannot add inline code.

Q. What is Authentication and

Ans .
An authentication system is how you
identify yourself to the computer. The goal behind an authentication system is
to verify that the user is actually who they say they are.
Once the system
knows who the user is through authentication, authorization is how the system
decides what the user can do.

Q. How do you deploy a User Control
in SharePoint ?

You deploy your User Control
either by a Custom webpart, which will simply load the control on the page or
can use tools like SmartPart, which is again a webpart to load user control on
the page. User Control can be deployed using a custom solution package for the
webapplication or you can also the control in the webpart solution package so
that it gets deployed in _controlstemplate folder.

Q. Which
is faster a WebPart or a User Control?

WebPart renders faster than a User Control. A User Control in SharePoint is
usually loaded by a webpart which adds an overhead. User Controls however, gives
you an Interface to add controls and styles.

What SharePoint Databases are Created during the standard Install?

Ans. During standard
install, the following databases are created :





Q. What are content types?

A content type is a flexible and reusable WSS type
definition (or we can a template) that defines the columns and behavior for an
item in a list or a document in a document library. For example, you can create
a content type for a leave approval document with a unique set of columns, an
event handler, and its own document template and attach it with a document

Q. Can a
content type have receivers associated with it?

Yes, a
content type can have an event receiver associated with it, either inheriting
from the SPListEventReciever base class for list level events, or inheriting
from the SPItemEventReciever base class. Whenever the content type is
instantiated, it will be subject to the event receivers that are associated with

Q. Can you add a Cutsom Http Handler in SharePoint

Yes, a Custom httphandler can be deployed in
_layouts folder in SharePoint. Also, we need to be register the handler in the
webapp's webconfig file.

Q. While creating a Web part, which is the ideal
location to Initialize my new controls?
Override the
CreateChildControls method to include your new controls. You can control the
exact rendering of your controls by calling the .Render method in the web parts
Render method.

Q. How do you
return SharePoint List items using SharePoint web services?

In order to retrieve list items from a SharePoint list through
Web Services, you should use the lists.asmx web service by establishing a web
reference in Visual Studio. The lists.asmx exposes the GetListItems method,
which will allow the return of the full content of the list in an XML node. It
will take parameters like the GUID of the name of the list you are querying
against, the GUID of the view you are going to query, etc.

Q. How Do you deploy Files in 12 hive when using
wspbuilder or vsewss?

Typically, you can add these
files in the 12 hive folder structure
in your project. In Vsewss
however, you will have to create this structure manually.

Part 1 Part 2 Part

What Tools Are Used for SharePoint Administration?

Tool for SharePoint Administration

Axceler's ControlPoint

Version : ContolPoint 3.5

Description : ControlPoint 3.5 helps
enterprises adopt and embrace Microsoft SharePoint more
than ever before. ControlPoint 3.5 boasts powerful new capabilities that give
enterprises more control over their configuration and deployment of SharePoint
while strengthening their SharePoint security.

Key Features: Moving
sites, site collections, list, library, documents and items accross the


Version : DocAve Software Platform v5.3

Description : DocAve Software
Platform v5.3, is considered the industry's most comprehensive software solution
for SharePoint backup and recovery, administration, archiving, auditing,
replication, reporting, compliance, and migration. This latest release
introduces the DocAve Storage Optimization Suite, comprised of an enhanced
DocAve Archiver module, and the new DocAve Connector and DocAve Extender modules
- each delivering features that enable the efficient management of SharePoint

Key Features : Used as a good SharePoint archiving solution. It
has a great UI and performs good reporting and auditing.

Nintex Workflow 2007

Latest Version

Description : Nintex Workflow 2007 enables organizations to build
complex workflow processes quickly and easily using a web browser interface.
Nintex Workflow 2007 empowers users across the organization to automate business
processes, review workflow activities and automate common SharePoint
administrative tasks.

Key Features : Easy to Use, and well intergrates
with Active Directory.

Well, There might be a lot of useful tools out
there, but these are the three that I have personaly used.

Create and Deploy Custom aspx Page as Feature and Solution Package of SharePoint 2007

There are two ways to deploy a custom aspx page in SharePoint.

1. Using
VseWss extensions project. Here you won't need to create a solution package
manually. All the files need to create a solution package are created by the VS
extensions itself. See the related Post Deploy Custom Css file in 12 hive. You can use same method to deploy your Custom
aspx page.

2. The second way is creating a solution package around your webapplication so that the pages in the webapplictaion can be deployed
in sharepoint. This requires you to manually create all the solution related
files (I mean manifest.xml, feature.xml, elements.xml and .ddf

In this Post, we will create a solution package manually for a webapplication project, so that the custom aspx page created in
web application can be deployed in SharePoint's Layouts folder.

Below are
the Steps that you can follow :

1. Create a New WebApplication

2. Create a new folder "MyCustomFolder" in the solution explorer
and Add your custom aspx page (along with cs file) under it.

3. Add two
more xml files in the same folder with names as elements.xml and

The Elements.xml File
should look like below -

<elements xmlns="<a
name="Pages" url="_layouts">
<file url="CustomPage.aspx"
name="CustomPage.aspx" type="GhostableInLibrary">

: Add Module name as "Pages" and url as " _Layouts "

The Feature.xml File should look like below

<feature id="79DD53E7-8719-45b0-8E25-C2450B3E3F14"
title="Project.CustomPage" description="Custom Page" scope="Web"
version="" hidden="false" xmlns="">
<elementfile location="CustomPage.aspx">

Now, Create another xml file in the Project and name it as

The manifest.xml
should look like below -

<solution xmlns="<a

<safecontrol assembly="Project.CustomPage Version=,
Culture=neutral, PublicKeyToken=a28586c97e90b41f" namespace="
Project.CustomPage" typename="*" safe="True"> </safecontrol>


: If you are using some code behind with your aspx page, then change the Inherit
tag in the aspx page to inherit
from the assembly of the project.

For e.g. change the tag

Inherits="NameSpace.Class, NameSpace, Version=,
Culture=neutral, PublicKeyToken=2ef8d0c4bab8980b" Debug="true"

You dont
need to deploy .cs file with the Project. The code is accessed via its .dll

5. Finally Create the .ddf file ( its simply a text file with name as

.ddf file would be something like below -

.OPTION Explicit ;
Generate errors.Set CompressionType=MSZIP







;sets the feature

Set DestinationDir=CustomPageFolder

;adds the feature
to the feature directory


;adds the
element to the feature


I have created
an empty folder in the Project with a name as "Package" to save the .wsp file in

6. Sign the project with a key (Project Properties -> "signing
tab" and browse your .snk key) and Build the Project.

7. Now, Add and
deploy the .wsp solution which is under Package Folder in SharePoint using
stsadm commands.

Questions and Answers of SharePoint Interview for Developers - Part 1

Q. What Do you know about SharePoint Object

Ans. In Sharepoint Object model there are
two Important namespaces.

The Microsoft.Office.Server
namespace is the root namespace of all Office Server objects and Microsoft.SharePoint
is the root namespace for all WSS objects.
Read More at SharePoint 2007 Object Model

Q. Can you
develop webparts and other SharePoint solutions at your local

In order to run and debug sharePoint solutions, the
project must reside on the server which has Windows sharePoint services
installed. However, you can reference the Microsoft.SharePoint dll in
your project at your local, but you won't be able to run it.

Q. How do you debug SharePoint

To debug SharePoint webpart (or any solution) you
can simply drag and drop your complied .dll in GAC and recycle the app pool. You
can also run upgrade solution command from stsadm.

Q. How would you retrieve large number of Items form
the list ?

Ans. To retrieve
large number of items with a better performance we can either use SPQuery or
PortalSiteMapProvider Class. Read More with Examples
Retrieving large number of Items from sharepoint 2007 list

Q. How Do you implement Impersonation in ShrePoint.

Ans. By Using RunWithElevatedPrivileges method provided by
SPSecurity class.
See e.g Impersonation in Sharepoint

Q: What is the
performance impact of

RunWithElevatedPrivileges creates a new thread with the App Pool's credentials,
blocking your current thread until it finishes.

Q. How will you add Code behind to a Custom
Applictaion Page or a Layout Page in SharePoint?

You do not
deploy a code behind file with your custom Layouts page. Instead, you can have
the page inherit from the complied dll of the solution to access the code

Q. What is the difference between a Site Definition
and a Site Template?

Ans. Site Definitions are
stored on the hard drive of the SharePoint front end servers. They are used by
the SharePoint application to generate the sites users can create. Site
Templates are created by users as a copy of a site they have configured and
modified so that they do not have to recreate lists, libraries, views and
columns every time they need a new instance of a site.

Q. Why do you use Feature Receivers

Feature Receivers are used to execute any code on
Activation\Deactivation of a Feature. You can use it for various

Q. Can you give a example
where feature receivers are used.

. You can use it to assign an
event receiver feature to a specific type of list or can write a code in a
feature receivers Deactivate method to remove a webpart from webpart

Q. Where do you deploy the additional files used in
your webpart, like css or javascript files, and how do you use them in your

Ans. You can deploy the css or
javascript files in _layouts folder in SharePoint's 12 hive. To use them in your
webpart, you need to first register them to your webpart page and then specify a
virtual path for the file for e.g. _layouts\MyCSS.css See Code examples at Using External Javascript, CSS or Image File in a WebPart.

When should you dispose SPWeb and SPSite objects?

Ans. According to the best Practices you
should always dispose them if you have created them in your code. You can
dispose them in Finally block or you can use the "Using" clause, so that they
gets disposed when not required. If you are using SPContext then you need not
dispose the spsite or spweb objects.

Q. What are the best practices for SharePoint

Some of the best practices are:

1. You
should always dispose SPsite and SPWeb objects, once you refer them in your
code. Using the "Using" clause is recommended.

2. Use
RunwithelevatePrivilages to avoid errors for end users.

3. Try writing
your errors to SharePoint error logs (ULS Logs). Since it's a bad idea to
fill-up event log for your production environment.

4. Use SPQuery instead
of foreach loop while retrieving Items from the list.

5. Deploy
additional files used in your webpart to 12 hive. Use your solution package to
drop the files in 12 hive. Also, make sure that all the references (for e.g. Css
or .js files) get removed when the solution is retracted.
Also See : Best Practices to Improve Site Performance

Q.What is the main
difference between using SPListItem.Update() and

Ans. Using
SystemUpdate() will not create a new version and will also retain

See :
Part 1 Part

Related Posts :

The Tutorial of Sharepoint 2007 for beginners

Interview Questions and Answers of SharePoint 2007 for Administrator

Interview Questions and Answers of SharePoint 2007 for Administrator

Q. Can you personalize Shared Services for a single Web

. You
cannot assign or un-assign few services to a web application. If the web
application is using a perticular SSP, it has to bear the burden of all the
services configured in that SSP.

How will you move or separate a Site Collection which stays in a shared
WebApplication content database, into its own
separate database.

You can create a
new Content database in the target webapplication (which
will contain the new site collection). Then adjust the maximum number of sites
allowed for the content database currently being used. Then use stsadm command
to backup and restore the site colletcion. For Details see How to Create or Move Site Collections into Separate Databases of SharePoint

Q. What are Security
methods(Authentication methods) available in sharepoint 2007.

Ans :
Out of the box", SharePoint 2007 supports nine authentication
methods. NTLM (short for NT Lan Manager, which is simply the Windows
authentication that everyone is familiar with) and Kerberos (also a Windows
"standard" authentication) are offered during installation.

Q.How Does SharePoint work?

The browser sends a DAV packet to IIS asking to perform a document
check in. PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it has the
proprietary INVOKE command. Because of the existence of this command, the packet
is passed off to msdmserv.exe, who in turn processes the packet and uses EXOLEDB
to access the WSS, perform the operation and send the results back to the user
in the form of XML.

Q. What is
the difference between a site and a web?

A site in
sharePoint is a site collection. It is an object of SPsite class in sharepoint.
While a Web is simply a blank site within that site collection. Web is a Part of
SPweb class, thus represents a site within a site

Q. How will you
backup and restore entire farm ?

There are various
methods to backup and restore SharePoint entire farm in SharePoint. Two main
methods that you can use to back up and restore are:

* Using SharePoint
Central Administration Web site - This tool enables you to perform
backups and restorations from the user interface. When you use this method, you
can back up the server farm, Web applications, and any or all of the content
databases in your server farm. You can use the Stsadm command-line
tool to view backup and recovery
history and to view backup and recovery job status.

* Stsadm command-line
tool - Stsadm command-line
tool offers a faster and more
flexible command-line-based approach to farm backup and recovery. This method
for backing up and restoring data does not require SQL Server 2000 tools or SQL
Server 2005 tools. However, to perform this method of backup and recovery, you
must be a member of the administrators group on a computer on which SharePoint
Server or WSS 3.0 is installed.

Other methods to Backup are :

Backup Farm by using SQL server Tools - You can perform Full,
Differential and Transaction baclups from SQL server

* Third Party Tools - You can also use
other Backup and Restore tools such as DocAve for taking daily

Q. When to use
Diffrent Site Collections?

An Individual Site
collection offers following :

For the Users:

Dedicated Recycle
Dedicated usage Reports
Distributed administration (site collection
Dedicated search scopes, keywords, and best-bets
feature deployments
Dedicated language translation maintenance
galleries for web parts, master pages, content types, site columns, site
templates, and list templates
Dedicated shared libraries, such as site
collection images and site collection styles
Dedicated real estate (Self

For the IT Administrators:

Site quota
Distributed administration
Site locking
Database maintenance
Backup / Restore abilities
Content Deployments
InfoPath forms
services global template targeting

How to Create or Move Site Collections into Separate Databases of SharePoint

I had a requirenment to split\move a bunch of site colletcions using same
content databse into their own respective content databases.

Here are the
steps i followed :

1. Create a New Content Database -
Goto Central Admin site -> Application managment
-> Content databases.
Choose your destination web application from the left top corner.( the one which
will carry all the content databases) and Click on "Add a Content database". See
the screen below.

2. Now give this database an appropriate name (according to your site
colletcion) and hit Ok. The Database server should already be listed, if not
then please enter the database server name too.

3. Now, on the "Manage
Content Databases" screen click on the previously used content database. I mean
the one with "Site Level Warning" and "Maximum Number of Sites" set to 9000 and
15000. (In most cases).

4. Adjust Site Level Warning and Maximum
Number of Sites -
Once you open the previously used content database,
Set the "Site Level Warning" to the current number of sites in the content
database and the "Maximum Number of Sites" to one Plus the current sites in this
content database. For e.g. in the screen below I had "2" "Current number of
Sites" in my old database so I will adjust

Site Level Warning - 2 and
Maximum Number of Sites - 3.

5. Now you all all set with your database configuration. Now you can simply
backup your site collection from the source web application (could be same as
destination web application) and restore it in this webapplication (the one
which has the new content database). I used stsadm command for this.

The New site collection will get created in the new content database.

The Tutorial of Sharepoint 2007 for beginners

To begin with, lets look upon some things that you do need to know before you
start with the Microsoft Product called

1. Microsoft Windows SharePoint
Services 3.0
- An extentions build on Windows Server 2003, which Provides
the infrastructure for collaboration and a foundation for building Web-based
applications with this versatile technology. In short, it
provides the base for SharePoint Server 2007.

2. SharePoint and .Net
- SharePoint
development stack is build upon .Net Framework 2.0 so, it pretty much uses all
the .Net Framework 2.0 classes as its base classes. IT however, has its own
SharePoint API model, which is commonly used for development.

3. SharePoint and SQL - SharePoint definitely
uses SQL server to store the data which is uploaded into it. So be ready with a
big SQl space to accommodate SharePoint data.

Now lets Start with the basic definition of
SharePoint Server 2007 -
Its a Collaboration software or a Content
management Portal which effectively manage and repurpose the content to gain
increased business value. In simple words, SharePoint's main purpose is to allow
various departments\teams in the company to upload,manage and share documents
using SharePoint sites. In addition to Sharing documents,it also allows you to
create and manage web sites, use workflows and various other options to
implement the business process.For more info see What are the sharepoint used for

Administration -
As it a server, you would definitely need to learn its
administartion. SharePoint has two options avaiable for administration.
Central admin - A website available to you immediately after you install
SharePoint (and after you ran its Config wizard). This website pretty much
allows you to perform and function in SharePoint like Creating\Deleting
Websites, Backup\Restore Sites,Set up Users\accounts, Install Custom components
and a lot more.

2. Stsadm Tool -
This is a command
line tool available in SharePoint,
which allows you to perform all the administrative tasks that you can do with
Central admin site.

12 Hive - SharePoint stores a lot its Pages and
resources on the file system itself for fast retrieval. These Pages or Files
which make SharePoint Interface, are arranged in a Folder structure which we
call as 12 Hive. The 12 hive gets created at location
"C:\ProgramFiles\CommonFiles\Web Server Extentions\12" when you install the
SharePoint sever initially. To Know more about 12 hive and SharePoint solution
structure see Developer: 12 hive folder structure in sharepoint 2007

Development -
SharePoint is also looked upon as a development platform,
since all the components in SharePoint, right from a small hyperlink to a fancy
button is customizable. You can add your links, buttons , pages and even whole application SharePoint using its deployment architecture.For more
details see :Sharepoint 2007 development Tutorial

Object Model -

In Sharepoint Object model there are two Important
Microsoft.Office.Server -
This is a root namespace of all Office Server objects. This means all the
components or services available in Offiice SharePoint Server like BDC,
enterprise search etc can be accesed programmatically using this

Microsoft.SharePoint -
This is the root namespace for all WSS 3.0 objects. Remember, Wss 3.0 is
the base platform used by Office SharePoint server. For all namespaces see SharePoint 2007 Object model

What is SharePoint
made of? -
SharePoint Portal is a made of Web applications (WebSites in
.Net), Site Collections (a top level Site of the Web application) Web Site
Pages,Subsites(or child sites of Site collectons),Webparts,features and more ...
See the basic defination for all SharePoint Components that you will use during
development SharePoint Interview Questions:Important Definations

SharePoint Interview Questions:Important Definations

Definitions :

Web Parts are componentized,
self-contained packages of user interface that can be dropped into place on
SharePoint Web Part pages to provide discrete sets of functionality to
It can be incredibly easy to get confused between sites, webs, web
applications, and site collections. The farm is the topmost level in the
hierarchy. Below the farm, you have web applications represented by the
SPWebApplication class, which typically correspond to an IIS application pool.
Below that, you have a collection of site collections contained in the
SPSiteCollection class. Finally, you have site collections represented by the
SPSite class and individual websites represented by the SPWeb

Features allow reusable pieces of functionality
to be created and deployed to other sites,without modifying site templates.It is
always better to deploy a feature in new site instead ofdirectly embedding
mountains of complex XML.Using Features, you can do everything from adding a
link to the Site Settings page to creating a complete, fully functioning Project
Management suite that can be added to any SharePoint site.Features are organized
in folders under the Features directory located under 12 hives; Where SharePoint
Server 2007 puts all of its system files, at the following path:
%SystemDrive%\Program Files\Common Files\Microsoft Shared\web server
extensions\12. The two files that are used to define a feature are the
feature.xml and Elements.xml .The feature XML file defines the actual feature
and will make SharePoint aware of the installed feature. It usually identifies
the Feature itself and its element manifest file and sets the Feature scope to
Web site.
Elements.xml file identifies the assembly, class, and method to
implement in feature.

You can directly deploy a feature in sharepoint
site with

stsadm -o installfeature -filename

stsadm -o activatefeature -filename
DeletingEventHandler\Feature.xml -url


To Deploy it as solution package you need a solution manifest

Solutions allow you to package
Features in a cabinet (.cab) file and define important metadata about those
Features. After a Solution is installed on a server in the farm, you can then
use SharePoint's Solution management features to automate the deployment of that
Solution to other sites within the farm.

The solution manifest (always
called manifest.xml) is stored at the root of a solution file. This file defines
the list of features, site definitions, resource files, Web Part files, and
assemblies to process. It does not define the file structure—if files are
included in a solution but not listed in the manifest XML file, they are not
processed in any way.

Because the solution file is essentially a .cab
file, use the makecab.exe tool to create the solution package. The makecab.exe
tool takes a pointer to a .ddf file, which describes the structure of the .cab
file. The format of a .ddf file is, declare a standard header and then
enumerate, one file per line, the set of files by where they live on disk,
separated by where they should live in the .cab

Features & Solutions:
The Feature
Framework has been extended to allow developers to create custom Features.
Features can be deployed by using SharePoint Portal Server 2007 new form of
deployment, namely Solution Deployment. Solutions as you know, are custom
packages (e.g. WSP file) or redistributable CAB files, created by developers and
deployed by SharePoint Administrators. Administrator can deploy Features to the
individual site or to all Web front End Servers.

Features are a method
for developers to package customisations and deploy them to the SharePoint
portal. They can then be activated and deactivated at the Site Collection level.
Solutions are a way to bundle features together for

Custom action :
Represents a link, toolbar button, menu item, or any control that can be added
to a toolbar or menu that appears in the UI. You define custom actions by using
a custom action element within a feature definition file. You can bind custom
actions to a list type, content type, file type, or programmatic identifier
(ProgID). For more information, see Custom Action

Event receiver: Evaluator of an event
and definer of the behavior of an application. Windows SharePoint Services 3.0
allows you to define event handlers within libraries, lists, and sites. Event
receivers can be defined by using a receiver element within a feature definition
file. For more information, see Event

Master page:
that provide a consistent layout and appearance (look and feel) for SharePoint
sites. They allow you to factor out layout, structure, and interface elements
such as headers, footers, navigation bars, and content placeholders. Master
pages in ASP.NET 2.0 and master pages in Windows SharePoint Services work in the
same way. For more information, see Building Simple Master Pages for Windows
SharePoint Services 3.0.

Module :
A file or
collection of file instances that define the location where the files are
installed during site creation. Modules are frequently used to implement a Web
Part Page in the site. You can define modules by using a module element within a
feature definition file. For more information, see

SharePoint site:
A Web site hosted in a
virtual URL. A SharePoint site is a place for collaboration, communication, or
content storage. Depending on your business needs, you can create sites such as
team sites, blog sites, wiki sites, and others. You can customize a site's
appearance, users, user permissions, galleries, and site administration by using
the Site Settings administration pages.

SharePoint site
A collection of SharePoint sites that share common
administration pages and site settings. Site collections allow you to share
content types, site columns, templates, and Web Parts within a group of
SharePoint sites.

SharePoint Web farm:
A group of
Office SharePoint 2007 servers that share the same configuration database. All
site content and all configuration data is shared for all front-end Web servers
in a server farm.

Site definition.:
A set of files
that includes a master XML configuration file that is stored on all front-end
Web servers. A site definition provides the basic blueprint for how sites look,
what lists they include, their default navigational structures, and so on. For
more information, see Working with Site Templates and

A group of files (CSS, images)
that allow you to define the appearance (look and feel) of Web pages. Themes in
ASP.NET 2.0 and themes in SharePoint Products and Technologies work in the same
way. Themes are used to help organizations to brand their portals and team
sites. Office SharePoint Server 2007 includes a set of predefined themes.
However, as a developer, you can create custom themes for your company. For more
information, see How to: Customize Themes.


Sharepoint 2007 development Tutorial

Lets Start with what do you need for your development machine

1. First
and foremost, you need Windows Server 2003 R2 with Windows SharePoint Services
3.0 Installed. Then you need to verify that you have Microsoft SQL Server
2005\2008 Developer Edition installed, before you began installing Microsoft
Office SharePoint Server 2007 also Known as "MOSS".

Other quick way to
start with development is to download SharePoint 2007 VHD from Here
and run it with a software called Microsoft Virtual PC. This VHD Contains
Microsoft Office SharePoint Server 2007 and Microsoft Office SharePoint Server
2007, you will however need to install VS 2005\2008 to get started.

you are all set with the machine you should consider installing Visual Studio
Extensions for Windows SharePoint Services 3.0 from Here.
This will provide you with various SharePoint Templates to get

Let's discuss the knowledge Part - First you need to be familiar
with 12 Hive and the Solution structure of SharePoint.

12 hive - SharePoint 2007 have a 12 hive
structure which basically contains various files and folders that make
SharePoint Interface. The files\components that you will develop will also be
deployed under this folder structure.

Solution Package and Feature - Every component
that you will develop for SharePoint should be in the form of a Solution
Package. These packages are nothing but a .cab files which contain other files
that needed to be deployed on the SharePoint server. These Solutions packages
represented in SharePoint as .wsp files, also allows you to package Features and
defines important metadata about those Features. Besides, Solution Package
"Features" is also an important concept in SharePoint development.
Feature is
a functional component that can be activated and deactivated at various scopes
throughout a SharePoint instances. Almost, every link, button or functional
components in SharePoint is a Feature. Take it as a component that can be turned
on\off when required. To understand the relation between 12 hive and the .wsp
Developer: 12 hive folder structure in sharepoint 2007

Now, lets discuss about SharePoint 2007 Object
Model - In SharePoint 2007 Object Model there are two important namespaces

1. Microsoft.SharePoint
- This is the root namespace for all WSS objects. A developer
would always use Micorsoft.SharePoint.dll namespace for creating WSS compatible
components like webparts,features and solution packages.

2. Microsoft.Office.Server namespace - This is the
root namespace of all Office Server 2007 (i.e. MOSS) objects. A developer will
use the Microsoft.Office.Server namespace
while accessing SharePoint 2007 server (or MOSS) specific components like
BDC,Enterprise search etc.

WebParts -
Lets Start with creating a very basic webpart using VseWss.
This webpart will display some data from a SharePoint list using GridView
control on a SharePoint Site Page. The webpart is created as a feature, that
means you can activate\deactivate this webpart in your SharePoint site and is
deployed in the SharePoint environment as a solution package.
See detail
Step-by-Step example How to Deploy Webpart as Solution Package and Feature of SharePoint 2007


How to Deploy Webpart as Solution Package and Feature of SharePoint 2007

In this example we will create a SharePoint WebPart using VseWss, which will
display data from a SharePoint list in a gridview control. After creating the
webpart we will deploy the solution file i.e. .wsp file in our SharePoint site
using stsadm.

OutPut :

begin with you need to install the Visual studio extensions for Windows
SharePoint Services 3.0 (VseWss) for your appropriate Visual Studio version. You
can download the latest one from Here.

thing that you have to keep in mind is that you are developing this solution on
the server or machine which has WSS 3.0 installed in it.

Lastly, a Cutsom
list named "Clients" should exist in your SharePoint site. Since I am using a
Custom list called "Clients" and also a Custom column "Clients" in that list in
my webpart.

Lets begin with the steps

1. Create a SharePoint
WebPart Project. See the Screen below.

Now in your soluiotn explorer you would see a folder named "WebPart1". Letse
just rename it to "MyCustomWebPart". Make sure you also rename all the files in
the folder. Also, don't forget to change the url path in MyCustomWebPart.xml.
So, we have somthing like below .

Now lets write some code in our MyCustomWebPart.cs . In this webpart we will
create a Gridview control and will bind it to one of the columns in the
SharePoint list. We have also used RunWithElevatedPrivileges so that the code
runs under Application Pools identity and should not cause errors for the end
users. The list we have used is called "Clients" and the Column in the list is
also called "Clients".

Code :

class MyCustomWebPart :

public MyCustomWebPart()

protected override void
SPDataSource SPDataSource1 = new
SPSite mySite = SPContext.Current.Site;
myWeb = mySite.OpenWeb();

(SPSite siteCollection = new SPSite(mySite.ID))
using (SPWeb web =
myGrid = new
myGrid.AutoGenerateColumns = false;

BoundField ClientName
= new BoundField();
ClientName.HeaderText = "Our
ClientName.DataField =

SPList List =
SPDataSource1.List =

myGrid.DataSource =


{ }

In above Code we have also used SPDatasource which
will define the Source for Gridview control as SharePoint list.

Now lets
just build the project. Please Note that building the project will not create a
.wsp or solution package . To create a Solution file or .wsp file we will have
to virtually Deploy the project. So, to do that just right click on the Project
"MyCustomWebPart" and click on Depoly. See the screen below.

will likely get an error at this point. Since, we have not specified the
deployment target. Just ignore the error
and grab the .wsp file. To see awhat all files are created click on "Show all
Files" button on top the solution explorer.

you will see your .wsp file along with files like feature.xml and manifest.xml

: At this point we have two options for deploying this wsp or solution package
in our sharePoint site.

1. Deploy using Visual Studio - This is quick and
easy deployment. Just right click on you project and goto Properties. Goto the
"Debug" tab and enter you SharePoint site's url . Save it and again hit the
Deploy button. See the screen below.

We will deploy the wsp file using stsadm . To do this open a command prompt and
navigate to the below path
C:\Program Files\Common Files\Microsoft Shared\web server

Open this path in your windows explorer and drap and
drop your wsp in here. See Screen below.

write the command to deploy the webpart.

this case you will just add the solution package in SharePoint's Solution store.
You would then need to goto CentralAdmin->Operations->Solution Management
and deploy the webpart. Just click on the webpart title in Solution management
screen and you will see the below. Click on Deploy Solution and Choose the

you deploy : After yo deploy the webpart you will need to add it into webpart
gallery. To do this Open your site and goto "SiteActions->Site Settings
->Modify All Site Settings ->WebParts. Click on New and select the webpart
from the Screen. See below

you are all set to add the webpart in your webpart page.

If you wish to deploy some files like css, .js or images along with
this webpart solution refer to my post below:
Deploy files to 12 hive with webpart solution using VSewss of SharePoint 2007


Deploy files to 12 hive with webpart solution using VSewss of SharePoint 2007

You can deploy various files like .jpg, gif, css, javascript etc along with
your WebPart solution package using <Templatefiles< tag, avilable in your
solution's manifest.xml file.
You however, do not modify the
<TemplatesFile> tag directly, instead you would mimic the 12 hive folder
structure in your webpart and will add the files that you want to deploy under
the structure. The Template files tag in manifest file will automatically be
created by Vsewss once you build the solution. See the detailed example below.

Please Note : If you want to create a solution package for just
deploying some files in 12 hive, for e.g. deploying custom aspx page or layouts
page or Custom css or javascript file then see the Related Post Deploy Custom Css file in SharePoint 2007 with Solution Package

Below are the Steps
to deploy some additional files in SharePoint's 12 hive with your webpart
solution package. Also, note that the WebPart used in the below example was
created using WebPart template available with VSeWSS.

Step 1: Create the Template Directory structure
in your webpart Project. For e.g to deploy your css or Image files in 12 hive's
STYLES library, Create a folder structure as

Templates->LAYOUTS->1033->STYLES->Your custom Folder. Now, add
your files under your Custom Folder.

See the screen below

Step 2: Build the WebPart.

Now, open manifest.xml and look
at the tag <TemplateFiles>. You will
notice that VSeWSS has added entries for all the files in your custom folder as
TemplateFiles. This defines the Path where these files will be deployed. See the
Image below.

Step 3: Now, deploy the Solution.

Step 4 : Verify that the
Folder "MyCustomWebPart"(your custom folder name) is available in the Styles

If you want to use the deployed Images in your WebPart, you can
simply use it with below url


For details on
how to register and use Css and Javascript files in your webpart,see the post

Using External Javascript, CSS or Image File in a WebPart of SharePoint

Below Code is to ensure that your webpart gets removed
from WebPart gallery during retraction.
This is done by adding a Feature receiver in your
webpart solution file.

Step 4: Create a FeatureReceiver.cs class
file. Add the below code for feature deactivating.

public override void
FeatureDeactivating(SPFeatureReceiverProperties properties)
site = null;
site = properties.Feature.Parent as SPSite;

using (SPWeb web = site.RootWeb)
SPList list = web.Lists["Web Part
// go through the items in reverse
int count =

for(int i = count -1 ;i>= 0; i--)

// format name to look like a feature name

string webpartName
= list.Items[i].Name;

webpartName = webpartName.Substring(0,

// delete web parts that have been added

if (properties.Feature.Definition.DisplayName == webpartName)




if (site != null)

A Detailed article is Here

Now, add an entry for Feature receiver in your feature.xml.
Specify the ReceiverAssembly and the receiver class. Build the Project. see fig
below :

Step 4 : Retract the solution from central Admin -> operations
-> solution managment.
Verify that the Custom folder in STYLES library is

Note : If you custom folder with Images is deployed in
Templates->LAYOUTS->1033->IMAGES folder,It wont get removed on

retracting the solution. The Images which are deployed directly in the
Templates->LAYOUTS->1033->IMAGES folder gets retracted. For more on
Template files and other options in manifest.xml please see wsp


Deploy Custom Css file in SharePoint 2007 with Solution Package

In this Post we will use VSewss extentions for deploy our Custom css file in
sharePoint as Feature and solution package. Using Vsewss empty project is the
easist and quick way to deploy your files with a solution package and a

Note : You can use this method to deploy various other files
like custom aspx page, Custom Layout page, master page, Images, javascript files
etc in 12 hive.

Before you start make sure that you have latest version
of VseWSS extentions installed for your appropriate Visual Studio Version

Steps are :

1. Open the Vs and Create a SharePoint Type empty

Next we will add a SharePoint object called "Templates". Once you hit add you
will notice that a folder named "Templates" is created in our project along with
a text file called TempleFile.txt. We will however, delete the
"TemplateFile.txt" file since we dont need it, and will create a 12 hive folder
structure under the added "Templates" folder to deploy for custom file. See the
screens below.

Adding Templates object:

Folder structure Layouts->1033->STYLES under Templates folder :

Now add your Custom Css file under STYLES folder. You can also create new one as
i did in the below screen :

It added some Css classes ( just for testing) and Built the webpart.

After a succesful build. Lets hit Deploy. Once you hit deploy the Vsewss will
create all the necessary solution and feature files for your deployment ( See
the status bar - Says Creating Solution). At this time you would probbaly get an
error like "No SharePoint Site exist at this url" this is because we have not
specified the url of any SharePoint site for the deployment. You can however,
get the .wsp file or soltuion file from your project folder on your local
machine and deploy it using stsadm.

modify the solution package and feature related files created by Vsewss, click
on a little icon "show all Files" in the solution explorer bar.

6. Open
Manifest.xml and verify the <Templefile> path.

What are the sharepoint used for

Sharepoint as we know is a Content Management System developed by Microsoft that allows users
to share the data (like word documents and stuff) in a web-based collaborative

SharePoint is mostaly used to create Companies Intranet
Portal, where people can upload and Share documents they work on.

brief, SharePoint is Used to perform following functions in a company(Common

1. Share Documents( like Word docs, excel sheets or simply some
data values).
2. Start a Workflow on Document\Data.
3. Display Companies
Announcements ( You are given a template to write and publish announcements on a
aspx Page)
4. Display RSS feeds from various sources including SharePoint
5. Display Data from other sources like SQL server, Access and other
on companies Intranet Page.
6. Send E-mails (Automatic Alerts) for anything
or everything happening in the companies portal.
7. Create aspx Pages and add
data to them without writing code.
8. Make the intranet Portal Site Public (
It will behave like any other site on the web.)

Best Practices to Improve Performance for SharePoint 2007 Sites

Some of the best practices for using Publishing Site are:

1. Keep Files UnCustomized - Try to keep your
files UnCustomized or on the server. Avoid editing them in SharePoint designer
or by using SharePoint API if not needed. Customizing the files can cost you
alot in terms of Performance and space as every Customized or Unghosted file in
is subjected to safe mode parser.Its basically, a little Check to see that
everything on the Page is allowed to run in SharePoint.

2. Avoid adding lot of WebParts on a single Page
Check the closed webparts on your page and make sure you delete

3. Memory Management-
Always, Dispose SPSIte and SPWeb Objects if you have created them in your code.
You can employ certain coding techniques to ensure object disposal. These
techniques include using the following in your code:

* Dispose

* using clause

* try, catch, and finally blocks

: SPContext objects are managed by the SharePoint framework and should not be
explicitly disposed in your code. This is true also for the SPSite and SPWeb
objects returned by SPContext.Site, SPContext.Current.Site, SPContext.Web, and

4. Reduce the
Page Payload
- SharePoint Page loads a lot of images from _layouts or
other various paths which can make the Page load a slow process. To avoid this
Payload you can use clustering or stitching, which combines multiple images into
a single image file. You can then use CSS to clip parts of the image, giving
users the impression that multiple images are being used.

5. Enable output caching for a site collection
For each page request for which an output cached version of a page is
served, the server does not have to:
* Make a round trip to the database to
fetch the source code for the .aspx page and any .ascx controls on the
* Reload and re-render the controls.
* Requery any data sources that
the controls rely on for data.
However, Output caching consumes additional
memory. Each version of a page consumes memory on the Web client.When used with
two or more front-end Web servers, output caching may affect consistency.

Using External Javascript, CSS or Image File in a WebPart of SharePoint

Button Testbutton;
Image img;
string imagePath;

Referring External Javascript

ClientScriptManager cs =
// Include the required javascript file.
"jsfile", "/_wpresources/MyWP/");

Testbutton= new Button();
Testbutton.Text = "Click
Testbutton.OnClientClick = "jsfile_Function()"; // specify function name

// Refering External CSS

Microsoft.SharePoint.WebControls.CssLink cssLink = new
cssLink.DefaultUrl =

Using External Image

imagePath =
img.ImageUrl =
img.ID = "image1";




The Impersonation in Sharepoint 2007 (RunWithElevatedPrivileges)

Although not recommended, there may be times when you need your code to
perform certain functions that the current user does not have the necessary
permissions to perform.

The SPSecurity class provides a method
(RunWithElevatedPrivileges) that allows you to run a subset of code in the
context of an account with higher privileges than the current user.
premise is that you wrap the RunWithElevatedPrivileges method around your code.
And also In certain circumstances, such as when working with Web forms, you may
also need to set the AllowSafeUpdates method to true to temporarily turn off
security validation within your code. If you use this technique, it is
imperative that you set the AllowSafeUpdates method back to false to avoid any
potential security risks.

Code example

SPSite mySite = SPContext.Current.Site;
myWeb = mySite.OpenWeb();


Get references to the site collection and site for the current context.
The using statement makes sures these references are disposed

using (SPSite siteCollection = new

using (SPWeb web =

web.AllowUnsafeUpdates =

//Your code

web.AllowUnsafeUpdates =

//siteCollection = null;
//web = null;


Retrieving large number of Items from sharepoint 2007 list

If you have to reterive a large number of Items and also need a better
performance then you should use one of the methods below :

1. Using SPQuery

2. Using PortalSiteMapProvider Class

Lets see the examples for both the methods :

Our Query - Query to get all the Items in a list where Category is "Sp2007"

SPQuery -

// Get SiteColl
SPSite curSite = new

//Get Web Application
SPWeb curWeb = curSite.OpenWeb();

// Create a SPQuery Object
SPQuery curQry = new SPQuery();

// Write the query
curQry.Query = "<Where><Eq><FieldRef
<Value Type='Text'>SP2007

// Set the Row Limit
curQry.RowLimit = 100;

//Get the List
SPList curList = curWeb.Lists(new Guid("myListGUID"));

//Get the Items using Query
SPListItemCollection curItems = curList.GetItems(curQry);

// Enumerate the resulting items

foreach (SPListItem curItem in curItems)

string ResultItemTitle =


PortalSiteMapProvider class -

The class includes a method called GetCachedListItemsByQuery that retrieves data from a list based on an SPQuery object that is provided as a parameter to the method call.
The method then looks in its cache to see if the items already exist. If they do, the method returns the cached results, and if not, it queries the list, stores the results in cache and returns them from the method call.

// Get Current Web
SPWeb curWeb = SPControl.GetContextWeb(HttpContext.Current);

//Create the Query
SPQuery curQry = new SPQuery();
curQry.Query = "<Where><Eq><FieldRef Name=\'Category\'/><Value Type=\'Text\'>SP2007</Value></Eq></Where>";

// Get Portal Map Provider

PortalSiteMapProvider ps = PortalSiteMapProvider.WebSiteMapProvider;

PortalWebSiteMapNode pNode = TryCast (ps.FindSiteMapNode (curWeb.ServerRelativeUrl), PortalWebSiteMapNode);

// Get the items
pItems = ps.GetCachedListItemsByQuery(pNode, "myListName_NotID", curQry, curWeb);

// Enumerate all resulting Items
foreach (PortalListItemSiteMapNode curItem in pItems)
string ResultItemTitle = curItem["Title"].ToString();