Showing posts with label SHAREPOINT PROGRAMS. Show all posts
Showing posts with label SHAREPOINT PROGRAMS. Show all posts

Saturday, April 23, 2011

SHAREPOINT SAMPLE ROGRAMS AND INTERVIEW QUESTIONS


WSS Object Model

1. SPSite Class
Represents a collection of sites in a Web application, including a top-level Web site and all its subsites
2. SPWeb Class
Represents a Windows SharePoint Services Web site.
3. SPWebCollection Class
Represents a collection of SPWeb objects.
4. SPList Class
Represents a list on a SharePoint Web site.
5. SPListCollection Class
Represents a collection of SPList objects.
6. SPListItem Class
Represents an item or row in a list.
7. SPListItemCollection Class
Represents a collection of SPListItem objects.
8. SPListTemplateType Enumeration
Specifies the type of a list definition or a list template.
9. SPView Class
Represents a view of the data that is contained in a list on a SharePoint site.
10. SPViewCollection Class
Represents a collection of SPView objects.
11. SPQuery Class
Represents a query in a list view
13. SPField Class
Represents a field in a list on a Windows SharePoint Services Web site.
14. SPFieldCollection Class
Represents a collection of SPField objects.
15. SPUser Class
Represents a user in Microsoft Windows SharePoint Services.
17. SPUserCollection Class
Represents a collection of SPUser objects.
18. SPGroup Class
Represents a group on a Windows SharePoint Services Web site
19. SPGroupCollection Class
Represents a collection of SPGroup objects.
20. SPFolder Class
Represents a folder on a SharePoint Web site.
21. SPFolderCollection Class
Represents a collection of SPFolder objects.
22. SPFile Class
Represents a file in a SharePoint Web site that can be a Web Part Page, an item in a document library, or a file in a folder.
23. SPFileCollection
Represents a collection of SPFile objects.
24. SPForm Class
Represents a form creating, displaying, or editing a list item in a list.
25. SPFormCollection Class
Represents a collection of SPForm objects



// 1. Program to Get Properties of SharePoint Site
using Microsoft.SharePoint;
public partial class DisplaySiteProp : System.Web.UI.Page
{
SPSite spsite = new SPSite("http://system:9000/");
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
try
{
spweb = spsite.OpenWeb();
//Display Current User
string sCurrentUser = spweb.CurrentUser.ToString();
Response.Write("The Current User is:" + sCurrentUser + "
");
//Display title
string sTitle = spweb.Title;
Response.Write("Title is:" + sTitle + "
");
//Display all sites in site collection
SPWebCollection spwebcoll = spsite.AllWebs;
Response.Write("The sites in site collection are" + "
");
for (int icount = 0; icount < spwebcoll.Count; icount++) { Response.Write(spwebcoll[icount].Title + " "); } } catch (Exception ex) { Response.Write(ex.ToString()); } finally { spsite.Close(); spweb.Close(); spsite.Dispose(); spweb.Dispose(); } } } //2. Program to create Sub Site Creation using Microsoft.SharePoint; public partial class CreateSite : System.Web.UI.Page { SPSite spsite = new SPSite("http://system:9000/"); SPWeb spweb; protected void Page_Load(object sender, EventArgs e) { spweb = spsite.OpenWeb(); } string sTitle, sName, sDesc, sTemplate; protected void btnCreateSite_Click(object sender, EventArgs e) { try { sTitle = txtTitle.Text; sName = txtName.Text; sDesc = txtDesc.Text; sTemplate = spweb.WebTemplate; SPWebCollection spwebcoll = spsite.AllWebs; spwebcoll.Add(sName, sTitle, sDesc, 1033, spweb.WebTemplate, true, false); Response.Write("Site Created Successfully");
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
spsite.Close();
spweb.Close();
spsite.Dispose();
spsite.Dispose();
}
}
}

// 3. Program to display List available in site
using Microsoft.SharePoint;
public partial class DisplayList : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
try
{
spsite = new SPSite("http://system:9000/");
spweb = spsite.OpenWeb();
SPListCollection lstcoll = spweb.Lists;
Response.Write("Lists in sites");
foreach (SPList lst in lstcoll)
{
Response.Write(lst.Title + "
");
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
spsite.Close();
spweb.Close();
spsite.Dispose();
spweb.Dispose();

} } }

// 4. Program to List Creation
using Microsoft.SharePoint;
public partial class _Default : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
spsite = new SPSite("http://system:9000/");
spweb = spsite.OpenWeb();
}
protected void create_Click(object sender, EventArgs e)
{
string sName = txtName.Text;
string sDesc = txtDesc.Text;
string sType = ddlType.SelectedItem.ToString();
try
{
SPListCollection lstColl = spweb.Lists;
SPListTemplateType tempType = new SPListTemplateType();
switch (sType)
{
case "Announcements": tempType =
SPListTemplateType.Announcements;
break;
case "Tasks": tempType = SPListTemplateType.Tasks;
break;
case "GenericList": tempType =
SPListTemplateType.GenericList;
break;
}
spweb.AllowUnsafeUpdates = true;
lstColl.Add(sName, sDesc, tempType);
Response.Write("list of type" + sType + "is created");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
spsite.Close();
spweb.Close();
spsite.Dispose();
spweb.Dispose();
}
}
}


// 5. Program to Edit List Items
using Microsoft.SharePoint;
public partial class EditItems : System.Web.UI.Page
{
SPSite spsite = new SPSite("http://system:9000/");
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
try
{
spweb = spsite.OpenWeb();
SPList splist = spweb.Lists["Employee"];
SPListItem itmToEdit = splist.GetItemById(1);
itmToEdit["Title"] = "101-edit";
itmToEdit["EName"] = "abc-edit";
spweb.AllowUnsafeUpdates = true;
itmToEdit.Update();
splist.Update();
spweb.Update();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
spsite.Close();
spweb.Close();
spsite.Dispose();
spweb. Dispose ();
}
}
}
// 6. Program to Display List Items
using Microsoft.SharePoint;
public partial class DisplayListItems : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
try
{
spsite = new SPSite("http://system:9000/");
spweb = spsite.OpenWeb();
SPList lst=spweb.Lists["Employee"];
SPListItemCollection itemcoll = lst.Items;
Response.Write("List of Employees are:" + "
");
foreach (SPListItem item in itemcoll)
{
Response.Write(item["Title"] + " "+item["EName"]+"
");
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
spsite.Close();
spweb.Close();
spweb.Dispose();
spsite.Dispose();
}
}}

// 7.Program to Delete Sites in a Site Collection
using Microsoft.SharePoint;
public partial class DeleteSite : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
SPWebCollection spwebcoll;
protected void Page_Load(object sender, EventArgs e)
{
spsite = new SPSite("http://technofin:9000/");
spweb = spsite.OpenWeb();
spwebcoll = spsite.AllWebs;
foreach (SPWeb web in spwebcoll)
{
ListItem li = new ListItem();
li.Text = web.Name;
li.Value = web.Name;
ddlSitestoDelete.Items.Add(li);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
spwebcoll.Delete(ddlSitestoDelete.SelectedValue);
lblMsg.Text = "The site is deleted";
}
}
// 8. Program to add Item to list
using Microsoft.SharePoint;
public partial class Lists_AddItems : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
spsite = new SPSite("http://system:9000");
spweb = spsite.OpenWeb();
spweb.AllowUnsafeUpdates = true;
SPList splist= spweb.Lists["Employee"];
SPListItemCollection lstcoll = myList.Items;
SPListItem newItem = lstcoll.Add();
newItem["Title"] = "105";
newItem["EName"] = "techno";
newItem.Update();
splist.Update();
spweb.Update();
}
}

// 9. Program to Create view for list
using System.Collections.Specialized;
using Microsoft.SharePoint;
public partial class AddViews : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
spsite = new SPSite("http://system:9000");
spweb = spsite.OpenWeb();
SPList splist = spweb.Lists["Employee"];
SPViewCollection viewColl = splist.Views;
StringCollection fldsinView = new StringCollection();
fldsinView.Add("EmpID");
fldsinView.Add("EName");
fldsinView.Add("Empsal");
spweb.AllowUnsafeUpdates = true;
viewColl.Add("Prg_View", fldsinView, "", 100, false, true);
splist.Update();
Response.Write("New View Added");
}
}

// 10. Program to Create Document Library
using Microsoft.SharePoint;
public partial class Libraies_Create_Library : System.Web.UI.Page
{
SPSite spsite;
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
spsite = new SPSite("http://system:9000");
spweb = spsite.OpenWeb();
SPListCollection lstColl = spweb.Lists;
spweb.AllowUnsafeUpdates = true;
lstColl.Add("Prg_DocLib", "Sample Library From Program",
SPListTemplateType.DocumentLibrary);
spweb.Update();
Response.Write("New Library Added");
}
}



// 11. Program to See Documents properties in Document Library
using Microsoft.SharePoint;
public partial class Libraies_ViewProperties : System.Web.UI.Page
{
SPSite spsite;
SPWeb myWeb;
protected void Page_Load(object sender, EventArgs e)
{
spsite = new SPSite("http://system:9000");
myWeb = spsite.OpenWeb();
SPFolder spDocLib = myWeb.GetFolder("Shared Documents");
SPFileCollection spFiles= spDocLib.Files;
foreach (SPFile spFile in spFiles)
{
Response.Write("" + "Name of the File" +spFile.Name+ "
");
Response.Write("Author" + spFile.Author + "
");
Response.Write("Size" + spFile.Length + "
");
}
}
}

Collaboration Apllication Markup Language (CAML) examples

// 12. Program using CAML Query

using Microsoft.SharePoint;
public partial class _Default : System.Web.UI.Page
{
SPSite spsite = new SPSite("http://system:9000");
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
spweb = spsite.OpenWeb();
SPList splst = spweb.Lists["employeeInfo"];

SPQuery spquery = new SPQuery();

spquery.Query = string.Format("");

SPListItemCollection itemcoll = splst.GetItems(spquery);

Response.Write("

" + "List Items" + "


");

foreach (SPListItem item in itemcoll)
{
Response.Write(item["Title"]+" "+item["Employee Name"] +
"
");
}
}
}




// 13. program to display List in a Gridview

using Microsoft.SharePoint;
public partial class Default2 : System.Web.UI.Page
{
SPSite spsite = new SPSite("http://system:9000");
SPWeb spweb;
protected void Page_Load(object sender, EventArgs e)
{
spweb = spsite.OpenWeb();
SPList splst = spweb.Lists["employeeInfo"];

SPQuery spquery = new SPQuery();
spquery.Query = string.Format("15000");

SPListItemCollection itemcoll = splst.GetItems(spquery);

Response.Write("

" + "List Items" + "


");

DataTable dtItems = itemcoll.GetDataTable();

gvItems.DataSource = dtItems;
gvItems.DataBind();
}

WebService Example

// 14. Program to display List Names
public partial class Lists : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ListsWebService.Lists myLstWebServ = new ListsWebService.Lists();

myLstWebServ.Credentials =
System.Net.CredentialCache.DefaultCredentials;

myLstWebServ.Url="http://system:2525/_vti_bin/Lists.asmx";

System.Xml.XmlNode mynode=myLstWebServ.GetListCollection();

Response.Write("

"+"The Lists in the list coll are"+"


");

foreach (System.Xml.XmlNode node in mynode)
{
Response.Write(node.Attributes["Title"].Value+"
");
}
}
}


// 15.Program to add User to Group

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
usergrpwebservice.UserGroup webserv = new
usergrpwebservice.UserGroup();
webserv.Credentials = System.Net.CredentialCache.DefaultCredentials;
webserv.Url = "http://system:2525/_vti_bin/UserGroup.asmx";
webserv.AddUserToGroup("Viewers","manju","system\\manju",
"manju@gmail.com","Hi..am Manjunath");
Response.Write("Users Added");
}
}