Update MOSS 2007 Skills

Accessing Custom Aspx Page in MOSS 2007 Site

2012-01-09T01:49:00.002-08:00

Hi,

There would be requirement where we could have developed our custom aspx page and we have to deploy the same on SharePoint site. To do this first we need to paste that folder which consists of aspx page in the below path of the machine
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS

Now we can access our custom aspx page by accessing in the below format of the site
http://servername:portno/_layouts/foldername/customaspxpagename.aspx

For the example through Visual studio I have created a folder Custom and aspx page name would be custompage.So I can access the page with the following url
http://servername:portno/_layouts/ Custom /custompage.aspx

SharePoint Tools

2011-10-27T06:57:00.000-07:00

There are n number of tools for SharePoint,but below are the list of the tools that i used in my career for better understanding while dealing with MOSS 2007/WSS sites.Glance the list of SharePoint tools as below

SharePoint tools- The list is growing 
1. App Pool Manager (http://www.harbar.net/apm/apm2.zip)
2. U2U CAML Query Builder (http://www.u2u.info/SharePoint/U2U%20Community%20Tools/U2U%20Caml%20Query%20Builder%202007%20v3.1.0.0%20(windows%20version).zip)
3. .NET Reflector (http://reflector.red-gate.com/download.aspx)
4. SharePoint Explorer for WSS 3.0 ( )
5. SharePoint Log Reader (http://www.blogaboutsharepoint.com/wp-content/plugins/download-monitor/download.php?id=1)
6. BDC Meta Man Tool (http://www.lightningtools.com/pages/service/customerdownloads.aspx)
7. SharePoint Inspector 1.0.0.0 (http://spi.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=1652#DownloadId=5854)
8. SharePoint Explorer for WSS 3.0 (http://download.mondosoft.com/Ontolica/SharePointExplorer_V1_5_1_For_WSS3.zip)
9. SharePoint Dispose Checker Tool (http://download.microsoft.com/download/B/4/D/B4D279A0-E159-40BF-A5E8-F49ABDBE95C7/SPDisposeCheck.msi)
10. Windows SharePoint Services 3.0 SDK (http://www.microsoft.com/downloads/details.aspx?familyid=05E0DD12-8394-402B-8936-A07FE8AFAFFD&displaylang=en)
11. Microsoft Office SharePoint Server 2007 SDK (http://www.microsoft.com/downloads/details.aspx?familyid=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en)
12. Microsoft InfoPath 2007
13. Microsoft SharePoint Designer 2007
14. Microsoft Office 2007
15. WSP Builder for SharePoint (http://www.codeplex.com/wspbuilder)
16. Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensions (http://www.microsoft.com/downloads/details.aspx?FamilyID=3e1dcccd-1cca-433a-bb4d-97b96bf7ab63&DisplayLang=en)
17. Windows SharePoint Services 3.0 Tools: Visual Studio 2008 Extensions (http://www.microsoft.com/downloads/details.aspx?familyid=7BF65B28-06E2-4E87-9BAD-086E32185E68&displaylang=en)
18. SharePoint Administration Toolkit v2.0
x64: http://www.microsoft.com/downloads/details.aspx?FamilyId=F8EEA8F0-FA30-4C10-ABC9-217EEACEC9CE&displaylang=en
x86: http://www.microsoft.com/downloads/details.aspx?FamilyId=263CD480-F6EB-4FA3-9F2E-2D47618505F2&displaylang=en
19. SmartPart (http://www.codeplex.com/smartpart)
20. SharePoint Installer (http://www.codeplex.com/sharepointinstaller)
21. SOAP calls to the SharePoint web services (http://www.soapui.org/)
22. Microsoft Network Monitor 3.2 (http://www.microsoft.com/downloads/details.aspx?FamilyID=f4db40af-1e08-4a21-a26b-ec2f4dc4190d&DisplayLang=en#filelist ) Thanks to Patel for providing me this link.
23. SharePoint Work Acceleration Toolkit 2007 aka (SWAT) (http://www.idevfactory.com/products/swat/)
24. MetaVis Architect for SharePoint (www.metavistech.com/architect)
25. SharePoint 2007 Test Data Population Tool (http://www.codeplex.com/sptdatapop) Capacity planning and performance testing tool that populates data for testing SharePoint deployments
26. Imtech Test Content Generator v1.3.0.0
(http://blog.mastykarz.nl/imtech-test-content-generator-v1300-free-sharepoint-2007-tool/)
Creating a given number of publishing pages with the desired page layout and content
27. SharePoint Tips Utility Pack
(http://www.codeplex.com/spstipsUtilityPack)
Collection of tools including recursively delete sites, create and modify lists in multiple sites at once, and push a web part to multiple sites at once.
28. SharePoint Cross-site Configurator
(http://www.codeplex.com/SPConfigurator)
Automates the process of deploying MOSS site settings in all or selected sites in a server farm. Includes applying master pages, web titles, audit controls and expiration policies.
29. SharePoint Content Deployment Wizard
(http://www.codeplex.com/SPDeploymentWizard)
Allow a granular selection of content to be exported from site collections, webs, lists, folders, and list items to a .cmp file (Content Migration Package) which can be copied to other servers for import.
30. Sushi Tool for SharePoint
(http://www.codeplex.com/sushi)
Performs common administrative tasks. Can backup sites, copy views between sites, bulk create sites, apply themes just to name a few functions
31. SharePoint Developer Bookmarklets
(http://blog.mastykarz.nl/go/bookmarklets)
Great set of bookmarks to make navigating a SharePoint Web Site easier.
32. LINQ to SharePoint
(http://www.codeplex.com/LINQtoSharePoint)
Provides a custom query provider for LINQ that allows the querying of SharePoint lists using LINQ syntax
33. SharePoint config store
(http://www.codeplex.com/SPConfigStore)
Provides the framework for using a SharePoint list for application configuration values
34. SharePoint Dispose Checker Tool
(http://code.msdn.microsoft.com/SPDisposeCheck)
Helps to check that unmanaged SharePoint objects are correctly disposed of in code
35. PowerShell Extensions for SharePoint
(http://www.codeplex.com/SPPSExtensions)
Provides functionality for working with the SPWeb object.
36. SharePoint Automation
(http://stsadm.blogspot.com)
Extensions that assist in the use of working with the SharePoint object model from PowerShell.
37. The SharePoint PowerShell Module (SPoshMod)
(http://www.codeplex.com/SPoshMod)
Framework for SharePoint PowerShell scripts.
38. AC's WCM Custom Commands for STSADM.EXE
(http://www.andrewconnell.com/blog/articles/MossStsadmWcmCommands.aspx)
STSADM extensions for publishing sites and generating content type and column features.
39. Imtech OCD Export
(http://blog.mastykarz.nl/export-publishing-pages-features-imtech-ocd-export-page/)
Simplifies the process of provisioning Publishing Pages by extracting existing pages to XML. The files generated allow you to wrap your Publishing Pages in a Feature.
40. SharePoint Automation
(http://stsadm.blogspot.com)
List of almost 100 STSADM extensions that cover a variety of development and administrative tasks.
41. stsadmWin 2007
(http://blogs.msdn.com/ronalus/archive/2007/01/04/stsadmwin-has-an-2007-version.aspx)
Provides a Windows UI version of the STSADM tool
42. SharePoint 2007 Features
(http://www.codeplex.com/features)
Large collection of SharePoint features designed for developers and administrators. Provides assistance for debugging, logs, field and content type development, publishing sites, event receivers, and many more.
43. SmartTools for SharePoint
(http://www.codeplex.com/smarttools)
Collection of SharePoint features such as What's New, Auto complete Text Field, Enhanced Site Actions, and more
44. Yet Another CAML Query Tool
(http://www.ideseg.com/SharePointYetAnotherCAMLQueryTool2.aspx)
Converts SQL-like queries into CAML.
45. Imtech ListInstance Generator
(http://blog.mastykarz.nl/generating-list-instances-xml-imtech-listinstance-generator/)
Generates the ListInstance based on the List Template from a particular Feature
46. CAML.NET
(http://www.codeplex.com/camldotnet)
Set of .NET language-based tools for creating dynamic, reusable CAML query components. Build CAML queries dynamically in code while preserving the syntactic structure of the native CAML language.
47. SharePoint Manager
(http://www.codeplex.com/spm)
SharePoint object model explorer for inspecting your SharePoint environment. Can browse every site on the local farm and view every web, list, event receiver, etc... Enables the changing of properties
48. RedGate Reflector
(http://www.red-gate.com/products/reflector/)
Allows exploration of any .NET assembly, including those provided by SharePoint. Shows where and how methods and objects are used. Find feature for fields, properties, and methods.
49. Search Community Toolkit
(http://www.codeplex.com/sct)
A number of tools and code samples that have been contributed to enhance the Microsoft search experience (Microsoft Office SharePoint Server 2007 (MOSS) Search, Search Server 2008 and Search Server 2008 Express).
50. SharePoint Search Service Tool
(http://www.codeplex.com/SharePointSearchServ)
Web service client that can explore the scopes and managed properties of a given SharePoint Search SSP, build queries in either Keyword or SQL Syntax, submit queries, and examine the raw web service results.
51. zevenseas SharePoint Search Coder
(http://www.codeplex.com/MOSSSearchCoder)
Allows graphical building of queries and examination and testing of the SQL generated by the object model.
52. SharePoint Query Web Service Test Tool
(http://www.wsssearch.com/querywebservice.html)
Test tool for WSS V3's Query web service. Allows you to generate the request XML and send it to the web service.
53. STORM
(http://storm.codeplex.com/)
Tests any web service (including SharePoint)
54. Fiddler
(http://www.fiddlertool.com/fiddler/)
Examines the network traffic of pages as they load. Check the size of pages. Recommended for deploying public facing websites.
55. Firebug for Firefox
(http://getfirebug.com/)
Net console provides network statistics.
56. YSlow for Firebug for Firefox
(http://developer.yahoo.com/yslow/)
Analyses page performance and provides network statistics
57. SharePoint Development Environment Modifications (SPDevMod)
(http://www.codeplex.com/SPDevMod)
Collection of STSADM extensions and plugins for Visual Studio
58. Code Rush/Refractor Tools for SharePoint Developers
(http://andrewconnell.com/blog/articles/ProductivityToolsForSharePointDevelopers.aspx)
Extensions to Code Rush/Refractor to assist SharePoint development.
59. Imtech Fields Explorer Visual Studio 2008 plug-in
(http://blog.mastykarz.nl/imtech-fields-explorer-visual-studio-2008-plugin/)
Quickly find the field names needed for CAML queries and controls
60. Microsoft - BDC Definition Editor
(http://blogs.msdn.com/sharepoint/archive/2007/08/22/announcing-the-microsoft-business-data-catalog-definition-editor-for-microsoft-office-sharepoint-server-2007.aspx)
61. ARF is a FREE development framework for SharePoint
(http://www.spworks.co.uk/downloads/latest.aspx)
62. CSS Friendly Adapters
(http://www.sharepointblogs.com/mossman/archive/2007/03/08/css-friendly-control-adapters-in-sharepoint-2007-a-walk-through.aspx)
63. Mobile Entrée(TM) is the first ever SharePoint mobile application framework (http://www.mobileentree.com/default.aspx)
64. The SharePoint branding tool for easy configuration of themes, logos, etc. (http://download.codeplex.com/Project/Download/FileDownload.aspx?ProjectName=BrandingTool&DownloadId=66138&FileTime=128847754111100000&Build=15896)
65. SharePoint Deployment tool / Capacity planning tool (http://www.microsoft.com/downloads/details.aspx?FamilyId=DBEE0227-D4F7-48F8-85F0-E71493B2FD87&displaylang=en) with instructions on how to use it (http://technet.microsoft.com/en-us/library/bb961988.aspx)
66. SharePoint Site Manager 2007 (http://spm.codeplex.com/releases/view/22762)
67. Debug View for windows (An excellent tool for tracing/debugging) (http://download.sysinternals.com/Files/DebugView.zip)

Creating windows service for creating sites

2011-05-12T07:29:00.000-07:00

Hi,
I am posting three ways of approaches that I followed to create windows service for creating sites
First Approach: In this approach I created a xml where I have saved the process names, owner login, owner name. From this xml I am taking process names and creating the sites in Console Application
Here through code I have taken care of displaying the message if site already exists
o Deployment : Xml file, Console Application exe and Console Application exe config files to be moved from test server to dev/production server
o Solution file : CreateSiteCA.zip

Second Approach : In second approach I created a bat file and I have written stsadm commands to create the sites
o Deployment : Bat file needs to be moved from test server to dev/production server
o Solution file : createsite.bat

Third Approach : In this approach I have created list in which I have saved process names, owner login, owner names. From this list I am fetching the process names and creating the sites
Here through code I have taken care of displaying the message if site already exists
o Deployment : List template, Console Application exe and Console Application exe config files to be moved from test server to dev/production server
o Solution file : CreateSitefromListCA.zip
----------------------------CreateSiteCA.zip--------------------

// App.config, Configurations.xml can be found as below

//Program.cs
using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

using System.Configuration;
using System.Xml;

namespace CreateSiteCA
{
class Program
{
static void Main(string[] args)
{
using (SPSite site = new SPSite(ConfigurationSettings.AppSettings["SiteCollectionURL"]))
{
SPWebApplication webApp = site.WebApplication;
//Random rand = new Random();
//int index= rand.Next(1000);
//SPSite newSite= webApp.Sites.Add("/sites/TestSite" + index, "This is my Test Site",
// "This is the First Site Added Programmatically", 1033,
// "STS#0", @"domain\username", "username", "username@domain.com");

XmlDocument doc = new XmlDocument();
doc.Load("Configurations.xml");

XmlNodeList list = doc.SelectNodes("Sites/Site");
foreach (XmlNode node in list)
{
if (webApp.Sites["/sites/" + node.Attributes["name"].Value] != null)
{
Console.WriteLine("Site by name '" + node.Attributes["name"].Value + "' already exists " + Environment.NewLine);
continue;
}
Console.WriteLine("Please wait currently creating new site.." + Environment.NewLine);
SPSite newSite = webApp.Sites.Add("/sites/" + node.Attributes["name"].Value, node.Attributes["title"].Value,
node.Attributes["description"].Value, Convert.ToUInt32(node.Attributes["nLCID"].Value), node.Attributes["webTemplate"].Value,
node.Attributes["ownerLogin"].Value, node.Attributes["ownerName"].Value, node.Attributes["ownerEmail"].Value);

if (newSite != null)
{
Console.WriteLine("Site Created: " + newSite.Url + Environment.NewLine);
newSite.Dispose();
}
else
{
Console.WriteLine("Error Creating:" + node.Attributes["name"].Value + Environment.NewLine);
}
}
Console.WriteLine("Site Creation Compleated. Please press any key to continue..");
Console.ReadLine();
}
}
}
}

-------------------------------------------------------- createsite-----------------------------------------------------
//createsite.bat
@echo off

echo ===============================================================

echo Creating the sites

echo ===============================================================

cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\BIN

@echo off

stsadm -o createsite -url "http://servername:portno/sites/testsite6" -owneremail "username@domain.com" -ownerlogin "domain\username" -title "test site" -description "test site"

echo completed

--------------------------------------------------- CreateSitefromListCA-----------------------------------------

// App.config can be found as below

//Program.cs
using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

using System.Configuration;

namespace CreateSitefromListCA
{
class Program
{
static void Main(string[] args)
{
using (SPSite objsite = new SPSite(ConfigurationSettings.AppSettings["SiteCollectionURL"]))
{

using (SPWeb objweb = objsite.OpenWeb())
{
SPList objlist = objweb.Lists["Process List"];
SPListItemCollection objitmcollection = objlist.Items;
SPWebApplication objwebapp = objsite.WebApplication;

for (int i = 0; i < objlist.ItemCount; i++)
{
string processname = Convert.ToString(objitmcollection[i]["Title"]);
string strownerlogin = Convert.ToString(objitmcollection[i]["owner login"]);
string strowneremail = Convert.ToString(objitmcollection[i]["owneremail"]);
//if ((objwebapp.Sites.WebApplication.Name)!=processname.n)
//{
try
{
objwebapp.Sites.Add("/sites/" + processname, "This is my Test Site", "", 1033, "STS#0", @"domain\username", strownerlogin, strowneremail);
Console.WriteLine(processname + " Site Created");
}
catch (System.Exception _Ex)
{
Console.WriteLine("A Site with title: " + processname + " already exists");
}

// Console.ReadLine();
//}

}
}

}
}
}
}

Adding custom field into sharepoint

2010-09-06T08:28:00.000-07:00

Hi,
First of all thanx to SharePointKings site
First in my Control.ascx i have written as below and had put in 12hive\TEMPLATE\CONTROLTEMPLATES path
<%@Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@Register TagPrefix="SharePoint" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" namespace="Microsoft.SharePoint.WebControls"%>

After that in my fldtypes_control.xml I have written as below and had put in 12hive\TEMPLATE\XML

SPKings Textbox
SPKings Textbox
SPKings Textbox
Text
SharePointKings.CustomControls.SPKingsTextBoxField, SharePointKings.CustomControls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=0dcfd7c46d44c992
TRUE
TRUE

After that in SPKingsTextboxControl.cs I have written as follows
using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Web.UI;
using Microsoft.SharePoint.WebControls;
using System.Web.UI.WebControls;
namespace SharePointKings.CustomControls
{
public class SPKingsTextboxControl:BaseFieldControl
{
protected TextBox txtTextBox;
///

/// setting template name
///

protected override string DefaultTemplateName
{
get
{
return @"SPKingsTextbox";
}
}

///

/// get set value
///

public override object Value
{
get
{
EnsureChildControls();
return txtTextBox.Text.Trim();
}

set
{
EnsureChildControls();
txtTextBox.Text = (string)this.ItemFieldValue;
}
}
///

/// create child control
///

protected override void CreateChildControls()
{
if (Field == null) return;
base.CreateChildControls();
}

}
}

After that in SPKingsTextBoxField.cs I have written as
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint;
namespace SharePointKings.CustomControls
{
class SPKingsTextBoxField:SPFieldText
{
#region Contstructors
public SPKingsTextBoxField(SPFieldCollection fields, string fieldName): base(fields, fieldName)
{
}
public SPKingsTextBoxField(SPFieldCollection fields, string typeName, string displayName) : base(fields, typeName, displayName)
{

}

#endregion
public override string GetValidatedString(object value)
{
string strTxtValue = Convert.ToString(value).Trim();

if (!strTxtValue.ToUpper().StartsWith("HTTP") &&
!strTxtValue.ToUpper().StartsWith("FTP"))
{
throw new SPFieldValidationException("Web address does not start with HTTP or FTP");
}
return strTxtValue;
}
}
}

Matching the site urls with list item urls

2010-06-15T06:59:00.000-07:00

Recently we had an requirement of webpart where it should fetch all the site under that Web Application and check the urls from the list where some urls are already saved.After checking it should display URL's that are available in the list,List of all the sites under the current Web Application,sites that are not available in the list,list URL's are not available in the current Web Application and soon as user clicks the Delete button it should delete the urls in the list which are not alive

using System;

using System.Linq;

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Collections;

using System.Collections.Generic;

using System.Collections.Specialized;

using System.IO;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Administration;

using Microsoft.SharePoint.WebPartPages;

using System.Web.UI.WebControls.WebParts;

namespace RequestSiteDocument

{

public class RequestSiteDocument : System.Web.UI.WebControls.WebParts.WebPart

{

Button btnCreate;

Button btnDelete;

Label lblException;

private bool customMessage = true;

SPWeb oweb = SPContext.Current.Web;

SPSite objsite = SPContext.Current.Site;

SPList objlist = null;

ArrayList arrListofWebHierarchy = new ArrayList();

ArrayList arrListURLInfo = new ArrayList();

ArrayList arrListofsitenames = new ArrayList();

ArrayList arrListURLInfoinDeletebutton = new ArrayList();

ArrayList arrListListofWebHierarchyinDeletebutton = new ArrayList();

ArrayList arrListfordeletelist = new ArrayList();

ArrayList arrListofsitenamesinDeletebutton = new ArrayList();

protected override void CreateChildControls()

{

base.CreateChildControls();

if (DisplayButton)

{

btnCreate = new Button();

btnCreate.ID = "btnCreate";

btnCreate.Text = "Create";

btnCreate.Click += new EventHandler(btnCreate_Click);

btnCreate.Visible = true;

this.Controls.Add(btnCreate);

btnDelete = new Button();

btnDelete.ID = "btnDelete";

btnDelete.Text = "Delete";

btnDelete.Click += new EventHandler(btnDelete_Click);

btnDelete.Visible = true;

this.Controls.Add(btnDelete);

}

lblException = new Label();

lblException.ID = "";

lblException.Visible = true;

this.Controls.Add(lblException);

}

void btnCreate_Click(object sender, EventArgs e)

{

throw new NotImplementedException();

}

[Personalizable(PersonalizationScope.Shared),

WebBrowsable(true),

WebDisplayName("Display button"),

WebDescription("Display button"),

SPWebCategoryName("Display button")]

public bool DisplayButton

{

get { return customMessage; }

set { customMessage = value; }

}

protected override void Render(System.Web.UI.HtmlTextWriter writer)

{

base.Render(writer);

//SPSite objsite = SPContext.Current.Site;

SPWebCollection objspw = objsite.AllWebs;

try

{

objlist = oweb.Lists["RequestASiteList"];

if (objlist != null)

{

writer.Write("");

writer.Write("");

writer.Write("");

writer.Write("");

foreach (SPListItem itmlist in objlist.Items)

{

writer.Write("");

writer.Write("");

writer.Write("");

arrListURLInfo.Add(strurl);

writer.Write("");

}

writer.Write("

URL's that are available in the list
Site Title	Site URL
"); string strsitetitle = (itmlist["Title"].ToString().ToLower()); writer.Write(strsitetitle); writer.Write("	"); string strurl = (itmlist["url"].ToString()).ToLower(); writer.Write(strurl); writer.Write("

");

}

writer.Write("");

writer.Write("");

writer.Write("");

writer.Write("");

//fetching all the site names and site urls

foreach (SPWeb objweb in objspw)

{

writer.Write("");

writer.Write("");

writer.Write("");

writer.Write("");

//adding all site url's to the array list called arrListofWebHierarchy

arrListofWebHierarchy.Add(objwebfullurl);

arrListofsitenames.Add(objweb.Title);

}

writer.Write("

List of all the sites under the current Web Application
Site Name	Site URL
"); writer.Write(objweb.Title); writer.Write("	"); writer.Write(objweb.Url); string objwebfullurl = (objweb.Url).ToLower() + "/default.aspx"; writer.Write("

");

writer.Write("");

writer.Write("Below sites are not available in the list");

int sitefoundflag = 0;

//Compare arrListofWebHierarchy with arrListURLInfo

for (int i = 0; i < arrListofWebHierarchy.Count; i++) { for (int j = 0; j < arrListURLInfo.Count; j++) { if (arrListofWebHierarchy[i].ToString().CompareTo(arrListURLInfo[j].ToString().Trim()) == 0) { sitefoundflag = sitefoundflag + 1; } } if (sitefoundflag <= 0) { writer.Write("
");

writer.Write("Site Name:" + arrListofsitenames[i]);

writer.Write("");

writer.Write("URL:" + arrListofWebHierarchy[i]);

writer.Write("");

}

else

{

sitefoundflag = 0;

}

}

writer.Write("");

writer.Write("Below list URL's are not available in the current Web Application");

int listflag = 0;

//Compare arrListURLInfo with arrListofWebHierarchy

for (int i = 0; i < arrListURLInfo.Count; i++) { for (int j = 0; j < arrListofWebHierarchy.Count; j++) { if (arrListURLInfo[i].ToString().CompareTo(arrListofWebHierarchy[j].ToString().Trim()) == 0) { listflag = listflag + 1; } } if (listflag <= 0) { writer.Write("
");

writer.Write(arrListURLInfo[i]);

arrListfordeletelist.Add(arrListURLInfo[i]);

writer.Write("");

}

else

{

listflag = 0;

}

}

}

catch (Exception ex)

{

lblException = new Label();

lblException.Text = ex.ToString();

}

}

void btnDelete_Click(object sender, EventArgs e)

{

try

{

SPWebCollection objspw = objsite.AllWebs;

//get the url's that are available in the list field called url

objlist = oweb.Lists["RequestASiteList"];

if (objlist != null)

{

foreach (SPListItem itmlist in objlist.Items)

{

string strurl = (itmlist["url"].ToString()).ToLower();

arrListURLInfoinDeletebutton.Add(strurl);

}

}

//fetching all the site names and site urls

foreach (SPWeb objweb in objspw)

{

string objwebfullurl = (objweb.Url).ToLower() + "/default.aspx";

//adding all site url's to the array list called arrListListofWebHierarchyinDeletebutton

arrListListofWebHierarchyinDeletebutton.Add(objwebfullurl);

arrListofsitenamesinDeletebutton.Add(objweb.Title);

}

int listflag = 0;

//Compare arrListURLInfoinDeletebutton with arrListListofWebHierarchyinDeletebutton

for (int i = 0; i < arrListURLInfoinDeletebutton.Count; i++)

{

for (int j = 0; j < arrListListofWebHierarchyinDeletebutton.Count; j++)

{

if (arrListURLInfoinDeletebutton[i].ToString().CompareTo(arrListListofWebHierarchyinDeletebutton[j].ToString().Trim()) == 0)

{

listflag = listflag + 1;

}

}

if (listflag <= 0)

{

arrListfordeletelist.Add(arrListURLInfoinDeletebutton[i]);

}

else

{

listflag = 0;

}

}

SPList olist = oweb.Lists["RequestASiteList"];

SPListItemCollection itmcollection = olist.Items;

for (int i = 0; i < arrListfordeletelist.Count; i++)

{

for (int j = 0; j < itmcollection.Count; j++)

{

SPListItem objsplistitem = itmcollection[j];

if (arrListfordeletelist[i].ToString() == (objsplistitem["url"].ToString()).ToLower())

{

itmcollection.Delete(j);

}

}

}

}

catch (Exception ex)

{

lblException.Text = ex.ToString();

}

}

}

}

Customising Welcome message of the site

2010-03-27T07:55:00.000-07:00

Hi,

There may be the situation where you may have to customise the welcome message which will be on the right top of the site.For that i got the good link.Now my requirement was displaying the message based upon the intranet/extranet site.For that initially i have written the below code in welcome.ascx but the problem is it use to execute if condition always

Finally after seeing the link

http://www.wictorwilen.se/Post/Having-fun-with-the-SharePoint-Welcomeascx-control.aspx

what i did is

I took a custom user controlcustomwelcome.ascx and copy pasted the code of welcome.ascx in it and I have wriiten code in webpart as

namespace CustomWelcome {

public class Welcome : Microsoft.SharePoint.WebControls.Welcome {

protected Welcome() {

}

[SharePointPermission(SecurityAction.Demand, ObjectModel = true)]

protected override void OnLoad(EventArgs e)

{

base.OnLoad(e);

if (HttpContext.Current.User.Identity.IsAuthenticated)

{

if (HttpContext.Current.User.Identity.AuthenticationType==”Forms”)

{

PostCacheSubstitutionText pt = base.ExplicitLogout.MenuControl.Controls[0]

as PostCacheSubstitutionText;

pt.TextType = PostCacheSubstitutionTextType.UserName;

pt.SuffixHtml=”(Extranet)”

}

Else

{

PostCacheSubstitutionText pt = base.ExplicitLogout.MenuControl.Controls[0]

as PostCacheSubstitutionText;

pt.TextType = PostCacheSubstitutionTextType.UserName;

pt.SuffixHtml=”(Intranet)”

}

Dynamic Navigation

2010-03-11T07:42:00.001-08:00

DynamicNavigation.cs

There is a list called DocListNames.Now I shld display the items of the Title field in the form of the table.Actually the items in Title field of MBIADocListNames list are document library names of the site and based upon the Display Indicator field value Yes it has to display the document library names

For this the code is

protected override void Render(System.Web.UI.HtmlTextWriter writer)

{

SPSite objsite = SPContext.Current.Site;

SPWeb objweb = SPContext.Current.Web;

SPList objlist = objweb.Lists["DocListNames"];

string camlquery = " Yes";

SPQuery query = new SPQuery();

query.Query = camlquery;

SPListItemCollection listItemCollection = objlist.GetItems(query);

if (listItemCollection.Count > 0)

{

writer.Write("

");

writer.Write("

");

foreach (SPListItem itmlist in listItemCollection)

{

string title = (itmlist["Title"]).ToString();

writer.Write("

");

}

writer.Write("

");

writer.Write("

");

writer.Write("&nbsp");

writer.Write("");

writer.Write(title);

writer.Write("");

writer.Write("&nbsp");

writer.Write("

");

}

Form Based Authentication in WSS/MOSS 2007

2010-03-06T06:46:00.000-08:00

Create Database using-C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Create a asp.net site and add new item web.config- add the below entry For Extranet and for Internet sites

Use asp.net web site administration tool to add user

Extend the web site for Internet - set proper setting

======================================

For Extranet and for Internet sites

====================

connectionString="server=servername;database=databasename;Integrated Security=SSPI;"

providerName="System.Data.SqlClient"/>

====================

In Central Admin

type="System.Web.Security.SqlMembershipProvider, System.Web,Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="AcSqlConnString"

enablePasswordRetrieval="false"

enablePasswordReset="true"

requiresQuestionAndAnswer="false"

applicationName="/"

requiresUniqueEmail="false"

passwordFormat="Hashed"

maxInvalidPasswordAttempts="5"

minRequiredPasswordLength="1"

minRequiredNonalphanumericCharacters="0"

passwordAttemptWindow="10"

passwordStrengthRegularExpression=""

type="System.Web.Security.SqlRoleProvider, System.Web,Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="AcSqlConnString"

applicationName="/"

==========================

Now add the users to parent sites

==============================

Start testing the extended sites.

==================================

Best of luck

MOSS 2007 interview Questions

2010-01-14T02:35:00.000-08:00

Hi,

After attending so many interviews i am posting the questions.Go through and i wish you All the Best

//Honeywell interview questions
1)Difference b/w SqlDataReader and DataSet?
2)How do u return values from stored procedure to C# Windows Application?
3)Through DataReader could you return multiple values like if i write query as 'select * from emp,acc'?
4)what is EnsureChildControls?
5)If Manager approves the mail only Delivery Manager has to get the alerts what wil u do?
6)If you wanna to add the exe file format in the Document library what will u do?

//Envaiya Infotech questions
1)Diff b/w site definition and site template?
2)what is ghosting?
3)what is .stp?
4)what is the purpose of XSLT?
5)what are event handlers?
6)Diff b/w WSS and MOSS 2007?
7)what is Infopath?
8)what is DWP?
9)how will you filter the data through designer?
10)After installing MOSS 2007 exactly after 180 days u will get one error what is that error?

//2nd Round Envaiya Infotech questions
1)what are the characteristics of polymorphism?
2)How do u configure MOSS 2007?
3)Reg Ghosting and unghosting?
4)what are the types of JIT Compilers?
5)Characteristics of OOPS?

//Emc2 interview questions
1)If i add 'Reader' permission in Central Administration and 'Contributor' permission in Site Collection which would have the first priority?
2)Have you created any site based on the geographical locations?
3)In infopath if i enter your name manager name should get visible what will you do for that?
4)If any user is not able to login what would be your first step to fix it?
5)Have you worked on Lotus Notes?
6)what changes you have noticed after migrating the portal?
7)Virtual funcion in C#?
8)Difference b/w virtual and abstract?

//Enviya infotech final round questions
what are the different types of validation controls?
what is an identity in SQL 2005?
what is .NET Frame work 2.0?
what is an o/p paramter in stored procedure?
what is the diff b/w stack and heap?
Diff b/w DataGrid and GridView?
what is object data source?
Diff b/w ArrayList and ArrayList?
How do u call sp1 in sp2?
what is the membership of Login control in ASP.NET?
what are the state management techniques in ASP.NET?
Diff b/w session and view state?
what are enums?
Let us assume that there is an enum called color and items are red,blue,yellow then how will u add the enum to get all items in drop down list?
Characteristics of OOPS?
what is data encapsulation?
Diff b/w authorisation and authentication?
what are cursors?
what are triggers?
Diff b/w session and application?
what is the use of Hash Table?

//Intelli group questions
1)what are the files you get while installing solution package?
2)Site content types?
3)Publishing in MOSS 2007?
4)Difficulties faced while migrating 2003 to 2007?
5)diff b/w stored procedure and udf?
6)where content db comes into the picture?
7)how many web app's you can create?
8)can web app come under 2 SSP's?
9)life time of a view state?
10)diff types of session management techniques?
11)diff b/w executescalar,dataset,executenonquery?
12)what is a safe control tag in web config file?
13)what is AllowUnsafeUpdates?
14)what is cab file,ddf file?
15)what is crawling?
16)how many site collections you can create?

//CGI Interview Questions(ultimate questions)
1)What is partial class?
2)what is a sub query.Can you write it?
3)what is an extended stored procedure?
4)what are generics?How will u declare.Can you just write and show it to me?
5)In stored procedure how will you return the value just write it down?
6)what is the tool that you have used while converting portal from SPS2003 to MOSS 2007?
7)If i want to add some option in the Site Actions of the site what will u write in feature just write it down?
8)Have you created site template.How will you use it in another site?
9)There are two sites called as site A and site B.Through object model i should display all the items in document libraries of site A in site B but i don't have the persmissions for site A at all then how should i manage this?
10)Through variance how will you manage through object model?
11)How will change the themes.Can you tell me the procedure?
12)what are the different security permission levels in MOSS 2007?

//Accenture interview
What did u do in share point administration?
what is SSP?
what will Manage properties will do in search settings of SSP?
what is infopath?
Is there any tool that will be helpful in generating workflows?
what is infopath?
what is a feature?
what is the command to install feature?
what is the command to uninstall feature?

//Interview questions of wipro
How did u change the themes in MOSS 2007?
How will u create custom site definition?
Have u worked on search?
How will u create List through object model?
How will u deploy the web part?
How will you find the broken links?
Have u created ur own appliction in that?
what is ur role in the project?
what is the diff b/w private & protected modifier?

Diff b/w session & view state?
Difference b/w method overloading and overriding?
How will u declare the stored procedure and in that how will u declare i/p & o/p parameters.Just write down and show it?
what is @ in stored procedure?

//SLK Software
After installing fetures it should not be in list of features what will u do for that?
How will u deploy the web part?
I just want to see the coding standards when u write the code in web part?
what is major diff b/w user ctrl and custom control?
what will the override key does?
Instead of hard coding the listname how can u get the listname to fetch the data?
How can we interact the two web parts
Have u heard of wsp package?
what about the architecture in MOSS 2007?
why shld we do iisreset?

//Intelli group
what is CLR?
Diff b/w Stored procedure and UDF?
In table1 there are empno,empname and in table2 there are empno, deptname now what is the query to fetch the deptname?
Boxing and unboxing?
Diff b/w view state and session?
what are state management techniques?
what is disconnected architecture?
what is Page Lay out?

//Proteans interview questions
How do ASP.NET page knows that it should post back?
How many generations are there in garbage collector?
what is the structure of OOPS?
Does C# support multiple inheritance?
Can you tell me how will u declare delegate?
How polymorphism helps in C#?

//DELL-Perot Systems Interview questions
Page Life cycle in ASP.NET?
what are the state management techniques in ASP.NET?
Have u used any state management techniques?
what are the ctrls that you have used in ASP.NET?
To put the check box in each row of the grid view what will u do?
Have u used the user ctrl?
what is the data source?
what is stored procedure?
what is execution plan?
what is function?
Have u used joins?
what is self join?

//Aditi Technologies
what is SSP?
what is polymorphism?
what is the difference between Method overloading and method overriding?
Have u done any search web part?
In which moment i should i create a web application?
what is application pool?
I just want to set up the search with in the document library.How can i do that?
Puzzle:There are 3 boxes.On each of the boxes there is one label as Red,Green and Mix.Of course there may/may not be the correct color balls.In one shot you correct the labels of the boxes.How will you do that?
For suppose there are 2 users A and B.User A has full control on particular list just say List1 and B has only permission to view the particular row in the list.Now will user A will be able to see the list?
what is data abstraction?

//Innovation interview questions
Diff b/w Application pages and site pages?
where can u find the master pages(path)?
Suppose there are different sites under one site coll.I should have seperate master page for each site.How wil u do that?
Is there any other object in share point object model to work with mails?
Tell me the hierarchy of web app,site coll,sites,sub sites?
Should we include both SPWeb,SPSite while dealing with share point object model?
There is label and button in the web part.My requirement is after entering the value from textbox it should inserrt the item in the list.For that how wil u write the code?
Is there any field level permission in share point?

How to give Global Admin access to user in MOSS 2007

2009-10-23T03:08:00.000-07:00

Hi,

After migrating our application from SPS 2003 to MOSS 2007 we are unsuccessful to give Global Admin to access to our application owner of the portal in MOSS 2007.After doing lot of googling finally my senior Ramesh has found that the path to give the access i.e

In the Cental Administration click 'ApplicationManagement' tab there we can see the 'Application security' section.In that click on 'Policy for Web Appliaction'.Now add the user to whom you want to give the Global Admin access for entire Web Appliaction

Business Data Catalog

2009-08-04T04:07:00.000-07:00

Generating our Application Definition File.

Open up BDC Meta Man on the PC you want to work on (it doesn’t necessarily need to be the MOSS server). To connect to SQL Server click the drop down arrow on the ‘Connect to data source’ button in the top right of the screen and choose SQL Server.

In the ‘Connect To Data Source’ box enter the name of your Server and SQL Server instance if necessary, and select the Authentication mode. If you are using SQL Authentication you will also have to enter your SQL user account details.

Upon successfully connecting to SQL Server you’ll see the top window of BDC Meta Man populate with a list of databases. You can expand each database to see the list of tables by clicking the plus sign next to each database name

Now we can see listed all the tables for this particular database. With BDC Meta Man we think of each table as being its own entity. We create an entity by dragging and dropping a table onto our design surface which is the large grey area to the right.

Upon dragging and dropping the table, the entity is created with the Finder and SpecificFinder methods. You can see a view of it on the design surface with the fields listed that are returned by the Finder method. For this walk through drag the dbo.Department table across

When you have two entities that have a primary key->foreign key relationship between them you can create this relationship as a BDC association. This will allow us to make use of the BDC Related Data web part. To add an association, drag and drop the dbo.Employee table onto our design surface to create an Employee entity. You can create an association simply by dragging and dropping between the fields that are related. With our two entities it is the DepartmentID of the Department entity, and DepartmentID of the Employee entity. Drag and drop from the Department entity DepartmentID to the Employee entity DepartmentID

Doing this drag and drop creates the association for us, and any methods required to bring data back for the BDC Related Data Web Part.

Now all we need to do is generate our application definition file. First we need to set the path to save the file. We set this location by going Configuration -> XML OutPut File from the main options. In the Filename textbox you can either manually type the location and the filename or use the browse button

Once you have saved the filename and path to create your application definition file to simply click the green play button and your application definition file will get generated.

Once generated you get the option to open the XML file in your registered XML editor. If you click yes it’ll probably open it up in Internet Explorer for you to view. Look how much XML it has generated for you!

Importing our Application Definition File.

Remember the Business Data Catalog is only part of MOSS 2007 Enterprise Edition. You can download a trial of MOSS 2007 Enterprise Edition here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=2E6E5A9C-EBF6-4F7F-8467-F4DE6BD6B831&displaylang=en

Once installed and correctly configured we need to import our application definition file.

Open up MOSS 2007 Central Administration by either browsing to it or through the start menu on the server running MOSS 2007 – Start -> All Programs -> Microsoft Office Server -> SharePoint 3.0 Central Administration.

Navigate to the Shared Service Provider Administration (SSP Admin) page from the left quick launch menu

In the SSP Admin page you’ll see a whole section devoted to the BDC. Click on ‘Import application definition’.

Use the browser button to locate our application definition file, or type in the path and filename yourself. Leave all the other options as they are for the time being, and click ‘Import’

MOSS 2007 will now go through and validate your application definition file is correct, once it is done you will get a success page. Clicking past that you will see the administration page for the BDC application we just imported

Using our BDC application in MOSS 2007

Browse to the page where you want to add the Business Data Web Part and edit the page. Click ‘Add a Web Part’ button to display the web part gallery.

Scroll down to the ‘Business Data’ section and click the checkboxes for the ‘Business Data List’ web part and the ‘Business Data Related List’ web part. Click the ‘Add’ button to add the web parts to our web part zone. Once the Web Part Gallery form disappears you’ll see the two BDC web parts added to our web part zone. Now we need to configure them. First the Business Data list, click the ‘Open the tool pane’ link to open the web part tool pane down the right hand side of the screen.

We need to select what BDC entity our BDC data list is going to display, to do this click on the Browse button.

From the pop up window select our dbo.Department Entity and click OK. Then Click OK at the bottom of the Web Part Tool Pane to configuring this web part.

Now we need to configure the BDC Related List web part. Again click on the ‘Open the tool pane’ and select the dbo.Employee entity from the Browse button as you did for the Business Data List. You’ll see when you have selected the Employee entity the relationship drop down is populated and selected with our relationship method. If our entity had multiple association methods this is where we’d select which one to use.

Click ok to close the web part tool pane. The final configuration step we need to do is to connect the web parts together so when a Department is selected, only the Employees for that department are listed. To do this click on the small edit button for the Business Data Related List web part and go:

Edit -> Connections -> Get Related Item From -> dbo.Departments

And there we go. We should now be able to bring back all the Departments by clicking on the ‘Retrieve Data’ button on our Business Data List. Upon selecting a department from the returned values the Business Data Related List will bring back the employees for the selected department.

InfoPath 2007 Top 10 benefits

2009-08-04T04:05:00.000-07:00

1) Deploy InfoPath forms as Microsoft Office Outlook e-mail messages.

With Office InfoPath 2007, you can deploy forms as Outlook e-mail messages, so colleagues can complete forms without leaving the familiar Outlook environment. After you’ve collected the information in Office Outlook 2007, you can export it to a Microsoft Office Excel spreadsheet or merge the data back to a single InfoPath form.
2) Extend business processes beyond the firewall.

Office InfoPath 2007 and InfoPath Forms Services make it easy to extend forms solutions beyond your firewall because you can complete forms using many different Web browsers and mobile devices.

3) Easily convert Microsoft Office Word documents and Excel spreadsheets to InfoPath forms.

By converting Word documents and Excel spreadsheets to InfoPath form templates, you can build data integrity, improve version control, and add structure to information gathering by converting legacy documents to rich InfoPath form templates.

4) Make complex form design easier.

Office InfoPath 2007 helps people build forms with a simple drag-and-drop interface and provides support for prebuilt template parts and shared data connections.

5) Create PDF or XPS records of your form data.

With the addition of a free plug-in, you can create a Portable Document Format file (PDF) or XML Paper Specification (XPS) version of your completed InfoPath form for archival and records management.¹

6) Master your forms workflow using Office InfoPath 2007 and Microsoft Office SharePoint Server 2007.

Use the integrated workflow management tools in Office SharePoint Server 2007 to drive information-gathering processes efficiently.

7) Design a single form for Web browsers and Office InfoPath 2007 clients.

Office InfoPath 2007 includes a design checker to help ensure consistency for forms deployed to InfoPath Forms Services.

8) Enhance protection of important information in InfoPath form templates.

Office InfoPath 2007 includes support for information rights management to help protect forms from inappropriate usage and distribution.

9) Centralize forms management for the entire organization.

InfoPath Forms Services of Office SharePoint Server 2007 enables organizations to centrally manage electronic forms by providing access to only those users who have a secure connection.

10) Develop advanced forms solutions with Office InfoPath 2007 and Microsoft Visual Studio 2005.

Build InfoPath forms solutions by creating InfoPath projects hosted within Visual Studio 2005, so developers can build solutions using managed code and the Microsoft .NET Framework.

Inserting Data from Info path to database through object model

2009-08-04T01:38:00.000-07:00

Let me tell how to start the Infopath from the scratch so that beginners will can also cope up with us

Go to Start->All Programs->Microsoft Office->Click Microsoft Office Infopath 2007.Now you will be able to see the form as below

Now click the ‘Design a Form Template’ under ‘Design a form’ section.Now you will get the another form as below

Before clicking OK confirm whether ‘Enable browser-compatible features only’ option has checked or not.After clicking OK now you will be able to see a blank form as shown below

Now click the ‘Layout’ option under Tasks section.i have dragged and droped ‘Table with Title’ as per my requirement

Now to get the controls click ‘Design Tasks’ and from ‘Controls’ section utlilize the controls which ever you want.Finally I designed my Info path form as below

Now if we insert any data from the infopath it should get updated in the back end database.Now we need to check some settings before writing the code in VS2005.In your info path form go to Tools Menu->Form Options.In the Form options wizard go to ‘Security and Trust’ option and uncheck that ‘Automatically determine security level(recommended)’.Now check the ‘Full Trust’ option as shown below

Click OK

Now I have gone to the ‘button properties’ by right click of that button.In the Label you can enter the button text that you wish .In my case I have entered ‘Submit’ and I have clicked ‘Edit from code’ and it has displayed the following message

Click OK to save your form. After saving again go to ‘Edit from code’ of the Submit button control. Now it opens in Visual Studio mode first thing is we need to add the using System.Data.SqlClient;

Now in the button click event write the code as

XmlNamespaceManager ns = this.NamespaceManager;

XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();

XPathNavigator xnEmpId = xnDoc.SelectSingleNode("/my:myFields/my:field1", ns);

XPathNavigator xnEmpName = xnDoc.SelectSingleNode("/my:myFields/my:field2", ns);

XPathNavigator xnDeptName = xnDoc.SelectSingleNode("/my:myFields/my:field3", ns);

//connection string

string strConnection = "Data Source=Servername\\SQLEXPRESS;Initial Catalog=Sudheer;Integrated Security=SSPI";

SqlConnection conn = new SqlConnection(strConnection);

conn.Open();

SqlCommand cmd = new SqlCommand("insert into Test values('" + xnEmpId + "','" + xnEmpName + "','" + xnDeptName + "')", conn);

cmd.ExecuteNonQuery();

conn.Close();

I hope no need to explain regarding XmlNamespaceManager,XPathNavigator as you would be aware about XML concepts.Now as we need to capture the data of the fields through SelectSingleNode and there we need give the exact XPath of the field.For that what we have to do is

Go to your Info Path in the Design Tasks of right pane click Data Source there you will be able to see the fields.Right click on the field and click Copy XPath and paste in the SelectSingleNode as follows

XPathNavigator xnEmpId = xnDoc.SelectSingleNode("/my:myFields/my:field1", ns);

Finally we need to write the code to connect to the database in the Data Source.We need to write the sql quey to insert the data and finally close the sql connection.Now Run debug your application and check it out in the database.Now you can check it in your database which ever you have inserted in the Info path.

Adding RSS Feed URL to your site

2009-07-30T02:25:00.000-07:00

Hi,

As every body knows RSS(Really Simple Syndication) is one of the new feature in MOSS 2007.so first let us dicuss how to access simple RSS feed through URL through which you can glance the news updates in your site.
First click the 'Edit Page' which is under 'Site Actions' of your page as shown below
After that click on 'Add a Web Part' now in Add a Web Parts Wizard check the RSS Viewer option under 'Default' section as shown below

Click Add and now you will be able to see RSS Viewer box.Click on 'Open the tool pane' hyperlink

On the right side enter the url of the rss feeds in the RSS Feed URL which is under RSS Properties as shown below
Click OK.Now you will be able to see yahoo news updates in your site as shown below

Delpoyment of Custom Web Part using Class libary in MOSS 2007

2009-07-29T22:58:00.000-07:00

To Get Started with creating Custom Web Part for MOSS 2007 in Microsoft Visual Studio 2005, Open the IDE and create a new C# project, Select Class Library as Project Type. Name It as NewWebPart.

Add a reference to the System.Web from .Net components into the project. The System.Web dll contains the required namespace of System.Web.UI.WebControls.WebParts .

In The Project explorer view rename the Class1.cs with NewWbPart.cs to be consistent with this example; this will result in renaming the Class name as well. With the help of “using” keyword include the namespaces as shown in the code example below. Derive / Extend the NewWebPart Class from the WebPart Class ( System.Web.UI.WebControls.WebParts.WebPart), and add the code as shown below. The CreateChildren Control is same as in .Net 1.1, that it would create and add controls to this Web Part Class,. In this case I have only added a WebControl.Calender Object. The RenderControl Method is an override for the WebPart Base Class and calls the RenderChildren Method, this causes the Children Controls to be rendered on the Particular HtmlTextWriter passed as a parameter to the method

using System;

using System.Collections.Generic;

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

namespace NewWepPart

{

public class NewWebPart : WebPart

{

protected override void CreateChildControls()

{

Calendar cldr = new Calendar();

cldr.Enabled = true;

cldr.ShowGridLines = true;

cldr.ShowTitle = true;

cldr.EnableViewState = true;

cldr.SelectedDate = DateTime.Now;

Controls.Add(cldr);

}

public override void RenderControl(HtmlTextWriter writer)

{

RenderChildren(writer);

}

Build the project and on successful built you are ready to Deploy the Web Part to the Portal Site.

Deployment of Web Part:

In order to deploy a web part to a SharePoint portal 2007 site, we must have the URL of the site to which we want our web part needs to be deployed (displayed in fact). As it is mentioned earlier that the Web Parts developed in .Net 2.0 environment does have a .CAB project , instead an assembly is created on build of project. Now there are two choices to deploye the assembly to the SharePoint portal directory.

Deploy the assembly to the Assembly Folder (GAC) (requires the assembly to be stron named).
Put the assembly to the bin folder of the portal directory.

For the sake of simplicity, the later choice is being demonstrated in this example.

Putting Assembly in Bin Folder:

Copy the dll and paste to the BIN folder in ur

C:\Inetpub\wwwroot\wss\VirtualDirectories\

Adding the Safe Control Entry:

Even though the assembly is present in the Portal’s Bin folder, there is another step required to make the Control (Web Part) assembly usable on the Portal Pages. Since the control will need to render on multiple machines in different browsers with as many user accounts as the organizations have. There is a need to declare the control as “safe”. To do so open the web.config file placed under the portal’s directory in the VS.Net 2005 IDE.

Then edit the file in the section of SafeControls, create a new SafeControl entry for our assembly as shown below. Save the file and close it.

SafeControls>

Configuring Portal to use NewWebPart

Since now the web part have been written and deployed to the desired portal’s directory. The next task is to use the web part on the Portal’s Site. The Web Part Deployed to the portal can be placed on any site within that Portal. For convenience this NewWebPart is demonstrated to be placed on the home page of default Portal.

Open the portal site in the internet explorer; in this case http://oss1 is the URL for the default portal, ensuring that the current logged in user has the administrative rights on the portal site.

To begin with, the first step is to add the newly deployed web to the Portal’s web part gallery, since the portal is using the configuration databases to keep record of the contents of the portal, our newly created web part’s information doesn’t exist in the database. We need to add the web part to the Web Part Gallery before we can use it.

To do so, the following steps should be followed.

Click on the Site Actions button and then select Site Settings

2. On the site settings page under Galleries column click on the Web Parts.

On the Web Part Gallery Page click on the New button, to add the new web part assembly to the gallery

4. On the New Web Parts page locate the NewWebPart in the list, check the check box on the left and click on the Populate Gallery button the top of the page. This will result in the Web Part entry creation in the Web Part Gallery list, and hence it can be used from now on from the gallery. It can be notices easily that the Web Parts developed form the new Frame work of 2.0 have an extension of .webpart after their names. Whereas in earlier versions, it was a .dwp file. Both the .webpart and.dwp files are the XML definition of the Web Part.

5. Until this step the web part is ready to be used on the site by selecting it from Web Part Gallery. Click on the Site Actions button on the page and then select Edit Page, this will modify the appearance of the page to enable the edit view. In this view Web Part Zones are highlighted so that a user can add a web part to the zone, Click on the Add a Web Part button in the left zone to add the Web Part.

6. Select the NewWebPart from the web part list . it is found under the Misc section and then click on�Advanced Web Part gallery and options.

7. In the�Add Web Part Pane at right , select Home Gallery and then drag the NewWebPart from the pane into the Web Part Zone.

Click on the Exit Edit Mode link on the page and the site will return to the view mode