European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Retrieve Lists from SharePoint using Webservice?

Feb 13th

Posted by Peter in European SharePoint Server 2013 Hosting

Today, I will tell you about how to Retrieve Lists from SharePoint using Webservice. This following code will give you all the list from SharePoint with the details of particular list. You can change BaseType to get different types of list from SharePoint.

using System;  
using System.Collections.Generic;  
using System.ComponentModel;  
using System.Data;  
using System.Drawing;  
using System.Linq;  
using System.Text;  
using System.Xml;  
using System.Xml.Linq;  
using System.Windows.Forms;  
using System.Resources;  
using System.Web;  

//To add below namespace you should add below reference library.  
//1.)Microsoft.SharePoint.Client.dll  
//2.)Microsoft.SharePoint.Client.Runtime.dll  

using Microsoft.SharePoint; //add this namespace to access SharePoint Web Service.  
using Microsoft.SharePoint.Client; //add this namespace to access SharePoint Web Service.  
using Microsoft.SharePoint.Utilities; //add this namespace to access SharePoint Web Service.  

namespace WindowsFormsApplication1  
{  
public partial class COM : System.Windows.Forms.Form  
{  
string url = string.Empty;  
string listName = string.Empty;  
string listGUid = string.Empty;  
string rowLimit = "";  
System.Net.NetworkCredential creadential = new System.Net.NetworkCredential("username", "password", "domain");  
public COM()  
{  
      InitializeComponent();  
}  
private void btngetlist_Click(object sender, EventArgs e)  
{  
      string listname = string.Empty;  
      if (txturl.Text == string.Empty)  
      {  
            MessageBox.Show("Please Insert Valid Site URL!", "URL Needed!", MessageBoxButtons.OK, MessageBoxIcon.Information);  
      }  
      else  
      {  
            url = txturl.Text;  
            List<string> lst = getlist(url);  
      }  
}  
public List<string> getlist(string url)  
{  
      string listname = string.Empty;  
      ListWebService.Lists lst = new ListWebService.Lists();  
      List<string> listnames = new List<string>();  
      lst.Url = url + "/_vti_bin/Lists.asmx";  
lst.Credentials = creadential;  
try  
{  
      XmlNode xnode = lst.GetListCollection();  
      XmlNodeList node = xnode.SelectNodes("*[@BaseType=1]"); //change BaseType to retrieve Different list.  
      foreach (XmlNode list in node)  
      {  
            //if(Convert.ToInt32(list.Attributes["BaseType"]) == 0)  
            listname = list.Attributes["Title"].Value.ToString();  
            combolist.Items.Add(listname);  
      }  
}  
catch (Exception ex)  
{  
      MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);  
}  
return listnames;  
}  
public void combolist_SelectedIndexChanged(object sender, EventArgs e)  
{  
ListWebService.Lists lst = new ListWebService.Lists();  
url = txturl.Text;  
lst.Credentials = creadential;  
try  
{  
      listName = combolist.SelectedItem.ToString();  
      XmlNode xnode = lst.GetListCollection();  
      XmlNode list = lst.GetList(listName);  
      XmlNodeList visibleColumns= list.SelectNodes("Fields/Field[not(@Hidden) or @Hidden='FALSE']");  
      System.Xml.XmlNode nodlistview = lst.GetListAndView(listName, string.Empty);  
      XmlDocument xmldoc = new XmlDocument();  
      xmldoc.LoadXml(nodlistview.OuterXml);  
      XmlNodeList xmllist = xmldoc.GetElementsByTagName("ViewFields");  
      xmldoc = new System.Xml.XmlDocument();  
      System.Xml.XmlElement query = xmldoc.CreateElement("Query");  
      System.Xml.XmlElement viewfield = xmldoc.CreateElement("ViewFields");  
      xnode = xmllist.Item(0);  
      string queryinnerxml = string.Empty;  
      for (int i = 0; i < xnode.ChildNodes.Count; i++)  
      {  
            if (xnode.ChildNodes[i].Attributes["Name"].Value != "Edit")  
            {  
                  queryinnerxml = queryinnerxml + "<FieldRef Name=\"" + xnode.ChildNodes[i].Attributes["Name"].Value + "\" />";  
            }  
      }  
      viewfield.InnerXml = queryinnerxml.Trim();  
      System.Xml.XmlElement queryoption = xmldoc.CreateElement("QueryOptions");  
      queryoption.InnerXml = "<IncludeMandatoryColumns>TRUE</IncludeMandatoryColumns>";  
      System.Xml.XmlNode nodelistitem = lst.GetListItems(listName, string.Empty, query, viewfield, rowLimit, queryoption, null);  
      System.IO.StringReader xmlsr = new System.IO.StringReader(nodelistitem.InnerXml);  
      DataSet ds = new DataSet();  
      ds.ReadXml(xmlsr);  
      listgrid.DataSource = ds.Tables[1];  
}  
catch (Exception ex)  
{  
      MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);  
}  
}  
}  
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Xml;

using System.Xml.Linq;

using System.Windows.Forms;

using System.Resources;

using System.Web;

//To add below namespace you should add below reference library.

//1.)Microsoft.SharePoint.Client.dll

//2.)Microsoft.SharePoint.Client.Runtime.dll

using Microsoft.SharePoint; //add this namespace to access SharePoint Web Service.

using Microsoft.SharePoint.Client; //add this namespace to access SharePoint Web Service.

using Microsoft.SharePoint.Utilities; //add this namespace to access SharePoint Web Service.

namespace WindowsFormsApplication1

{

public partial class COM : System.Windows.Forms.Form

{

string url = string.Empty;

string listName = string.Empty;

string listGUid = string.Empty;

string rowLimit = "";

System.Net.NetworkCredential creadential = new System.Net.NetworkCredential("username", "password", "domain");

public COM()

{

InitializeComponent();

}

private void btngetlist_Click(object sender, EventArgs e)

{

string listname = string.Empty;

if (txturl.Text == string.Empty)

{

MessageBox.Show("Please Insert Valid Site URL!", "URL Needed!", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

else

{

url = txturl.Text;

List<string> lst = getlist(url);

}

public List<string> getlist(string url)

{

string listname = string.Empty;

ListWebService.Lists lst = new ListWebService.Lists();

List<string> listnames = new List<string>();

lst.Url = url + "/_vti_bin/Lists.asmx";

lst.Credentials = creadential;

try

{

XmlNode xnode = lst.GetListCollection();

XmlNodeList node = xnode.SelectNodes("*[@BaseType=1]"); //change BaseType to retrieve Different list.

foreach (XmlNode list in node)

{

//if(Convert.ToInt32(list.Attributes["BaseType"]) == 0)

listname = list.Attributes["Title"].Value.ToString();

combolist.Items.Add(listname);

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

return listnames;

}

public void combolist_SelectedIndexChanged(object sender, EventArgs e)

{

ListWebService.Lists lst = new ListWebService.Lists();

url = txturl.Text;

lst.Credentials = creadential;

try

{

listName = combolist.SelectedItem.ToString();

XmlNode xnode = lst.GetListCollection();

XmlNode list = lst.GetList(listName);

XmlNodeList visibleColumns= list.SelectNodes("Fields/Field[not(@Hidden) or @Hidden='FALSE']");

System.Xml.XmlNode nodlistview = lst.GetListAndView(listName, string.Empty);

XmlDocument xmldoc = new XmlDocument();

xmldoc.LoadXml(nodlistview.OuterXml);

XmlNodeList xmllist = xmldoc.GetElementsByTagName("ViewFields");

xmldoc = new System.Xml.XmlDocument();

System.Xml.XmlElement query = xmldoc.CreateElement("Query");

System.Xml.XmlElement viewfield = xmldoc.CreateElement("ViewFields");

xnode = xmllist.Item(0);

string queryinnerxml = string.Empty;

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

{

if (xnode.ChildNodes[i].Attributes["Name"].Value != "Edit")

{

queryinnerxml = queryinnerxml + "<FieldRef Name=\"" + xnode.ChildNodes[i].Attributes["Name"].Value + "\" />";

}

viewfield.InnerXml = queryinnerxml.Trim();

System.Xml.XmlElement queryoption = xmldoc.CreateElement("QueryOptions");

queryoption.InnerXml = "<IncludeMandatoryColumns>TRUE</IncludeMandatoryColumns>";

System.Xml.XmlNode nodelistitem = lst.GetListItems(listName, string.Empty, query, viewfield, rowLimit, queryoption, null);

System.IO.StringReader xmlsr = new System.IO.StringReader(nodelistitem.InnerXml);

DataSet ds = new DataSet();

ds.ReadXml(xmlsr);

listgrid.DataSource = ds.Tables[1];

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

SharePoint 2013 Hosting Recommendation

HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Useful CSOM Snippets

Feb 6th

Posted by Peter in European SharePoint 2013 Hosting

In this article, we will learn about some important Csom codes used for SharePoint operations

Nuget Package Required:

SharePointPnPCoreOnline

1	SharePointPnPCoreOnline

Required imports are:

using System;    
using System.Collections.Generic;    
using System.Linq;    
using System.Text;    
using System.Threading.Tasks;    
using Microsoft.SharePoint.Client;    
using OfficeDevPnP.Core;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Microsoft.SharePoint.Client;

using OfficeDevPnP.Core;

Authenticating with Sharepoint:

string siteUrl = "Your Site Collection Url";  
            string userName = "UserName of Account";  
            string password = "Password";  
            OfficeDevPnP.Core.AuthenticationManager authManager = new OfficeDevPnP.Core.AuthenticationManager();  
            using (var clientContext= authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password))

string siteUrl = "Your Site Collection Url";

string userName = "UserName of Account";

string password = "Password";

OfficeDevPnP.Core.AuthenticationManager authManager = new OfficeDevPnP.Core.AuthenticationManager();

using (var clientContext= authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password))

The above code creates authentication with Sharepoint with a valid username and password. It returns a clientcontext object. With the clientcontext object, we will do our required operations in Sharepoint.

Getting Listitems from sharepoint

string listName = "mynewlist";   
   List list = clientContext.Web.Lists.GetByTitle(listName);    
clientContext.Load(List);  
         if (list != null)    
                  {    
                      CamlQuery query = CamlQuery.CreateAllItemsQuery(100);    
                      ListItemCollection items = list.GetItems(query);    
                      clientContext.Load(items);    
                      clientContext.ExecuteQuery();    
                  foreach (ListItem listItem in items)    
                  {    
                      Console.WriteLine(listItem.FieldValues["ID"]);    
                  }    
              }    
    
                  else    
                  {    
                      Console.WriteLine("List is not available on the site");    
                  }

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

if (list != null)

{

CamlQuery query = CamlQuery.CreateAllItemsQuery(100);

ListItemCollection items = list.GetItems(query);

clientContext.Load(items);

clientContext.ExecuteQuery();

foreach (ListItem listItem in items)

{

Console.WriteLine(listItem.FieldValues["ID"]);

}

else

{

Console.WriteLine("List is not available on the site");

}

The above code returns items from the sharepoint list, depending upon the caml query provided.

Creating new items in the SharePoint list

string listName = "mynewlist";    
   List list = clientContext.Web.Lists.GetByTitle(listName);   
clientContext.Load(List);

   if (list != null)  
                {  
                    ListItemCreationInformation newItem = new ListItemCreationInformation();  
                    ListItem listItem = list.AddItem(newItem);  
                    listItem["Title"] = "Madhan";  
                    listItem.Update();  
                    clientContext.ExecuteQuery();  
                }  
  
                else  
                {  
                    Console.WriteLine("List is not available on the site");  
                }

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

if (list != null)

{

ListItemCreationInformation newItem = new ListItemCreationInformation();

ListItem listItem = list.AddItem(newItem);

listItem["Title"] = "Madhan";

listItem.Update();

clientContext.ExecuteQuery();

}

else

{

Console.WriteLine("List is not available on the site");

}

The above code will insert a new item in the SharePoint list (i.e. create a new id and Title value as Madhan)

Updating Listitem in sharepoint

string listName = "mynewlist";      
   List list = clientContext.Web.Lists.GetByTitle(listName);  
clientContext.Load(List);

if (list != null)  
                {  
                      
                    ListItem oListItem = list.GetItemById(5);  
                    clientContext.Load(oListItem);  
                    clientContext.ExecuteQuery();  
                    // clientContext.ExecuteQuery();  
                    if (oListItem.FieldValues.Count >0) {   
                    oListItem["Title"] = "My Updated Title.";  
  
                    oListItem.Update();  
  
                    clientContext.ExecuteQueryRetry(); }  
                }  
  
                else  
                {  
                    Console.WriteLine("List is not available on the site");  
                }

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

if (list != null)

{

ListItem oListItem = list.GetItemById(5);

clientContext.Load(oListItem);

clientContext.ExecuteQuery();

// clientContext.ExecuteQuery();

if (oListItem.FieldValues.Count >0) {

oListItem["Title"] = "My Updated Title.";

oListItem.Update();

clientContext.ExecuteQueryRetry(); }

}

else

{

Console.WriteLine("List is not available on the site");

}

Basically updating and deleting are processed based on ID, the above code will update the value of Title field to “My Updated Title” for Id “5” in the SharePoint list mynewlist

Deleting a ListItem in Sharepoint

string listName = "mynewlist";        
   List list = clientContext.Web.Lists.GetByTitle(listName); 
clientContext.Load(List);   
              ListItem oListItem = list.GetItemById(5);  
                    clientContext.Load(oListItem);  
                    clientContext.ExecuteQuery();  
                    if (oListItem.FieldValues.Count > 0)  
                    {  
                        oListItem.DeleteObject();  
  
                        clientContext.ExecuteQuery();  
                    }  
                }  
  
                else  
                {  
                    Console.WriteLine("List is not available on the site");  
                }

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

ListItem oListItem = list.GetItemById(5);

clientContext.Load(oListItem);

clientContext.ExecuteQuery();

if (oListItem.FieldValues.Count > 0)

{

oListItem.DeleteObject();

clientContext.ExecuteQuery();

}

else

{

Console.WriteLine("List is not available on the site");

}

As I said earlier, deleting an item is based on ID. The above code will delete the listitem corresponding to the ID “5”

Creating a New List

clientContext.Web.CreateList(ListTemplateType.DocumentLibrary, "WithPnpDOC",false);

1	clientContext.Web.CreateList(ListTemplateType.DocumentLibrary, "WithPnpDOC",false);

The above code will create a new document library in the Sharepoint site. We want to provide a valid listtemplatetype for creating various lists. The types are:

GenericList	100	0	A basic list which can be adapted for multiple purposes.
DocumentLibrary	101	1	Contains a list of documents and other files.
Survey	102	4	Fields on a survey list represent questions that are asked of survey participants. Items in a list represent a set of responses to a particular survey.
Links	103	0	Contains a list of hyperlinks and their descriptions.
Announcements	104	0	Contains a set of simple announcements.
Contacts	105	0	Contains a list of contacts used for tracking people in a site.
Events	106	0	Contains a list of single and recurring events. An events list typically has special views for displaying events on a calendar.
Tasks	107	0	Contains a list of items that represent completed and pending work items.
DiscussionBoard	108	0	Contains discussions topics and their replies.
PictureLibrary	109	1	Contains a library adapted for storing and viewing digital pictures.
DataSources	110	1	Contains data connection description files.
XmlForm	115	1	Contains XML documents. An XML form library can also contain templates for displaying and editing XML files via forms, as well as rules for specifying how XML data is converted to and from list items.
NoCodeWorkflows	117	1	Contains additional workflow definitions that describe new processes that can be used within lists. These workflow definitions do not contain advanced code-based extensions.
WorkflowProcess	118	0	Contains a list used to support execution of custom workflow process actions.
WebPageLibrary	119	1	Contains a set of editable Web pages.
CustomGrid	120	0	Contains a set of list items with a grid-editing view.
WorkflowHistory	140	0	Contains a set of history items for instances of workflows.
GanttTasks	150	0	Contains a list of tasks with specialized Gantt views of task data.
IssuesTracking	1100	5	Contains a list of items used to track issues.

Checking if the folder exists. If not, then creating a new folder:

string listName = "mynewlist";          
   List list = clientContext.Web.Lists.GetByTitle(listName); 
clientContext.Load(List);  
var  folder = list1.RootFolder.EnsureFolder("WithPnpDOC1");

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

var folder = list1.RootFolder.EnsureFolder("WithPnpDOC1");

As the heading describes, it checks the library with the foldername “WithPnpDOC1”. If it does not exist, it will create a new folder.

Creating a new Folder without checking existing

string listName = "mynewlist";            
   List list = clientContext.Web.Lists.GetByTitle(listName);  
clientContext.Load(List);

var folder = list.RootFolder.CreateFolder("WithPnpDOC");

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

var folder = list.RootFolder.CreateFolder("WithPnpDOC");

Simply creates the new folder in the Sharepoint document library

Creating Contenttype

clientContext.Web.CreateContentType("Contenttype name", "description", "Guid ", "Group");

1	clientContext.Web.CreateContentType("Contenttype name", "description", "Guid ", "Group");

The above code will create new contenttype in Sharepoint where the name and guid are unique. In the Guid, starting characters represents the parent content type. The available types are:

System 0x
Item 0x01
Document 0x0101
Event 0x0102
Issue 0x0103
Announcement 0x0104
Link 0x0105
Contact 0x0106
Message 0x0107
Task 0x0108
Workflow History 0x0109
Post 0x0110
Comment 0x0111
Folder x0120

e.g.

clientContext.Web.CreateContentType(“PNP doc3”, “My Desc”, “0x010100C2D5F149518B119D801AC6C18942554A”, “PNP grp CT”);

Adding fields to Content Type

string fieldIdStr = "5b0a8635-49a5-469f-8d42-1b92e8d4e17b";  
                  string contentTypeName = "PNP Ct";  
                  bool isRequired = false;  
                  bool isHidden = false;  
                  // Field As Guid    
                  Guid fieldId = new Guid(fieldIdStr);  
                  // Adds Field to Content Type using Name    
                  clientContext.Web.AddFieldToContentTypeByName(contentTypeName, fieldId, isRequired, isHidden);

string fieldIdStr = "5b0a8635-49a5-469f-8d42-1b92e8d4e17b";

string contentTypeName = "PNP Ct";

bool isRequired = false;

bool isHidden = false;

// Field As Guid

Guid fieldId = new Guid(fieldIdStr);

// Adds Field to Content Type using Name

clientContext.Web.AddFieldToContentTypeByName(contentTypeName, fieldId, isRequired, isHidden);

The above code will add sitecolumns field to content type PNP ct where guid is the valid site column guid.

Setting default Content type to list

clientContext.Web.SetDefaultContentTypeToList("mynewlist", "0x0100A33D9AD9805788419BDAAC2CCB37509F");

1	clientContext.Web.SetDefaultContentTypeToList("mynewlist", "0x0100A33D9AD9805788419BDAAC2CCB37509F");

The above code will sets the default contenttype to the list ,where the first parameter is listname, the next one is contenttype Guid

Creating Fields and SiteColumn

string displayName = "TestColumn2";  
              string internalName = "TestColumn2";  
              string groupName = "TestPnPGroup";  
      string fieldId = "4FDD339E-6B98-4A11-B1AC-9C6B8C37AE2E";  
              FieldType fieldType = FieldType.DateTime;  
              OfficeDevPnP.Core.Entities.FieldCreationInformation newFieldInfo = new OfficeDevPnP.Core.Entities.FieldCreationInformation(fieldType)  
              {  
                  DisplayName = displayName,  
                  InternalName = internalName,  
                  Id = new Guid(fieldId),  
                  Group = groupName  
              };  
              // Creates new Field    
              Field newField = mycleint.Web.CreateField(newFieldInfo);

string displayName = "TestColumn2";

string internalName = "TestColumn2";

string groupName = "TestPnPGroup";

string fieldId = "4FDD339E-6B98-4A11-B1AC-9C6B8C37AE2E";

FieldType fieldType = FieldType.DateTime;

OfficeDevPnP.Core.Entities.FieldCreationInformation newFieldInfo = new OfficeDevPnP.Core.Entities.FieldCreationInformation(fieldType)

{

DisplayName = displayName,

InternalName = internalName,

Id = new Guid(fieldId),

Group = groupName

};

// Creates new Field

Field newField = mycleint.Web.CreateField(newFieldInfo);

The above code creates a new datetime site column in your Sharepoint site with the name TestColumn2

string listName = "mynewlist";
List list = clientContext.Web.Lists.GetByTitle(listName);
clientContext.Load(List);
OfficeDevPnP.Core.Entities.FieldCreationInformation fldEmpID = new OfficeDevPnP.Core.Entities.FieldCreationInformation(FieldType.Number);  
               fldEmpID.DisplayName = "Employee IDd";  
               fldEmpID.InternalName = "EmpIDd";  
               fldEmpID.AddToDefaultView = true;  
               fldEmpID.Id = Guid.NewGuid();  
               list.CreateField(fldEmpID);  
               list.Update();  
               mycleint.ExecuteQueryRetry();

string listName = "mynewlist";

List list = clientContext.Web.Lists.GetByTitle(listName);

clientContext.Load(List);

OfficeDevPnP.Core.Entities.FieldCreationInformation fldEmpID = new OfficeDevPnP.Core.Entities.FieldCreationInformation(FieldType.Number);

fldEmpID.DisplayName = "Employee IDd";

fldEmpID.InternalName = "EmpIDd";

fldEmpID.AddToDefaultView = true;

fldEmpID.Id = Guid.NewGuid();

list.CreateField(fldEmpID);

list.Update();

mycleint.ExecuteQueryRetry();

The above code creates new number field with name Employee IDd in the list “mynewlist” the available types are:

Invalid = 0,
Integer = 1,
Text = 2,
Note = 3,
DateTime = 4,
Counter = 5,
Choice = 6,
Lookup = 7,
Boolean = 8,
Number = 9,
Currency = 10,
URL = 11,
Computed = 12,
Threading = 13,
Guid = 14,
MultiChoice = 15,
GridChoice = 16,
Calculated = 17,
File = 18,
Attachments = 19,
User = 20,
Recurrence = 21,
CrossProjectLink = 22,
ModStat = 23,
Error = 24,
ContentTypeId = 25,
PageSeparator = 26,
ThreadIndex = 27,
WorkflowStatus = 28,
AllDayEvent = 29,
WorkflowEventType = 30,
Geolocation = 31,
OutcomeChoice = 32,
Location = 33,
Thumbnail = 34,
MaxItems = 35

Conclusion

We have learned some crucial operations in SharePoint using PnpCore CSOM. Hope this helps somone. Happy Coding! 🙂

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Add SharePoint group to a site ?

Jan 31st

Posted by Peter in European SharePoint 2013 Hosting

One day, I need to Add SharePoint group to a site. The thing is that you have to create the group on the site collection, and then you assign it to the required site. To make use of the group you also need to grant some rights to it (“Full Control”, “Contribute” etc). Assigning the group to the site and granting the rights are perfomed using the SPRoleAssignment and SPRoleDefinition classes, respectively.

Because a group has to be created on the site collection, you must add it to the site’s SiteGroups collection. Attempting to adding it directly to the Groups collection will result in an exception. The only way to get the group into the Groups collection is by assigning it to the parent site. The code snippet below demonstrates how to create the tester’s group to an SharePoint site

using (SPSite site = new SPSite("your_site_col/subsite")) { using(SPWeb web = site.OpenWeb()) { web.SiteGroups.Add("Testers", web.CurrentUser, web.CurrentUser, "Group for Testers"); }

1	using (SPSite site = new SPSite("your_site_col/subsite")) { using(SPWeb web = site.OpenWeb()) { web.SiteGroups.Add("Testers", web.CurrentUser, web.CurrentUser, "Group for Testers"); }

At this point the group has been created on the site collection. To add the group to your site, you create an SPRoleAssignment object by associating the group in the constructor. Then, create an SPRoleDefinition object with the required permission level (taken from the site’s RoleDefinition collection), and then add it to the SPRoleAssignment object’s RoleDefinitionBindings collection. Now, add the SPRoleAssignment object to the site’s RoleAssignment collection .

SPGroup group = web.SiteGroups["Testers"];
SPRoleAssignment roleAssignment = new SPRoleAssignment(group);
SPRoleDefinition roleDefinition = web.RoleDefinitions["Contribute"];
roleAssignment.RoleDefinitionBindings.Add(roleDefinition);
web.RoleAssignments.Add(roleAssignment);

SPGroup group = web.SiteGroups["Testers"];

SPRoleAssignment roleAssignment = new SPRoleAssignment(group);

SPRoleDefinition roleDefinition = web.RoleDefinitions["Contribute"];

roleAssignment.RoleDefinitionBindings.Add(roleDefinition);

web.RoleAssignments.Add(roleAssignment);

Don’t forget, this code will not work on a site that has inherited permissions.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Get all Terms from the TermStore in SharePoint Using C#?

Jan 10th

Posted by Peter in European SharePoint 2013 Hosting

This post shows how to retrieve all the Terms from the Term Store in SharePoint Using C#. We are fetching a custom Term Set from a Custom Group.

Code:

using (SPSite RootSite = new SPSite(SPContext.Current.Site.Url))      
            {      
                using (SPWeb RootWeb = RootSite.OpenWeb())      
                {      
                    TaxonomySession TaxonomySession = new TaxonomySession(RootSite);      
                    TermStore termstore = TaxonomySession.TermStores["Managed Metadata Service"];      
                    Group group = termstore.Groups["CustomGroup"];      
                    TermSet termset = group.TermSets["CustomTermset"];     
                    TermCollection termcoll = termset.GetAllTerms();      
                    StringBuilder strbl = new StringBuilder();      
                    foreach (Term term in termcoll)      
                    {      
                        strbl.Append(term.Name.ToString());                              
                    }      
                    Literal1.Text = strbl.ToString();      
              }      
            }

using (SPSite RootSite = new SPSite(SPContext.Current.Site.Url))

{

using (SPWeb RootWeb = RootSite.OpenWeb())

{

TaxonomySession TaxonomySession = new TaxonomySession(RootSite);

TermStore termstore = TaxonomySession.TermStores["Managed Metadata Service"];

Group group = termstore.Groups["CustomGroup"];

TermSet termset = group.TermSets["CustomTermset"];

TermCollection termcoll = termset.GetAllTerms();

StringBuilder strbl = new StringBuilder();

foreach (Term term in termcoll)

{

strbl.Append(term.Name.ToString());

}

Literal1.Text = strbl.ToString();

}

SharePoint 2013 Hosting – HostForLIFE.eu :: Office UI Fabric Choice Group Integration in SharePoint Framework (SPFx)

Dec 19th

Posted by Peter in European SharePoint 2013 Hosting

In this blog, we will learn how to integrate an Office UI Fabric ChoiceGroup control in the SharePoint Framework (SPFx).

The ChoiceGroup component, also known as radio buttons, lets users select one option from two or more choices. Each option is represented by one ChoiceGroup button; a user can select only one ChoiceGroup in a button group. The below steps explain how to integrate choice group control in your SPFx solution, and how to store values to state variable on change.

Steps Involved

Install “office-ui-fabric-react” from the node package manager as shown below.

PS C:\XXXX\SPFxSolutions\SpFxRichTextEditor>npm install --save office-ui-fabric-react

1	PS C:\XXXX\SPFxSolutions\SpFxRichTextEditor>npm install --save office-ui-fabric-react

Import “office-ui-fabric-react” to your .tsx file as shown below.

import { ChoiceGroup } from 'office-ui-fabric-react';

1	import { ChoiceGroup } from 'office-ui-fabric-react';

In this blog, I have used class file (ProjectTaskConstants.ts) to hold all the values to be populated in choice group as shown below

ProjectTaskContants.ts

import { ChoiceGroup } from 'office-ui-fabric-react';  
export default class ProjectTaskConstants{  
    static get StatusOptions(){  
        const statusOptions: IChoiceGroupOption[] = [  
            { key: "Open", text: "Open" },  
            { key: "Closed", text: "Closed" },  
            { key: "On hold", text: "On hold" }  
        ];  
        return statusOptions;  
    }      
}

import { ChoiceGroup } from 'office-ui-fabric-react';

export default class ProjectTaskConstants{

static get StatusOptions(){

const statusOptions: IChoiceGroupOption[] = [

{ key: "Open", text: "Open" },

{ key: "Closed", text: "Closed" },

{ key: "On hold", text: "On hold" }

];

return statusOptions;

}

Import ProjectTaskContants.ts file to your .tsx file as shown below

import ProjectTaskConstants from '../ProjectTaskConstants';

1	import ProjectTaskConstants from '../ProjectTaskConstants';

Instantiate the class file as shown below:

/*This to get all the constant values*/  
  public Constants = new ProjectTaskConstants();

1 2	/This to get all the constant values/ public Constants = new ProjectTaskConstants();

Usage

In Render method, use the control as shown below:

<ChoiceGroup  
     id="status"  
     name="StatusOptions"  
     defaultSelectedKey="Open"  
     options={Constants.StatusOptions}  
     onChange={this.onStatusChange.bind(this)}  
     selectedKey={this.state.Status}         
   />

<ChoiceGroup

id="status"

name="StatusOptions"

defaultSelectedKey="Open"

options={Constants.StatusOptions}

onChange={this.onStatusChange.bind(this)}

selectedKey={this.state.Status}

OnChange event:

public onStatusChange(ev: React.FormEvent<HTMLInputElement>, option: any): void {  
    this.setState({  
      Status: option.key  
    });  
}

public onStatusChange(ev: React.FormEvent<HTMLInputElement>, option: any): void {

this.setState({

Status: option.key

});

}

In the above example, I have used “Status” state variable of type string.

To disable the choice group:

<ChoiceGroup  
     id="status"  
     name="StatusOptions"  
     defaultSelectedKey="Open"  
     options={Constants.StatusOptions}  
     selectedKey={this.state.Status}  
     disabled={true}  
 />

<ChoiceGroup

id="status"

name="StatusOptions"

defaultSelectedKey="Open"

options={Constants.StatusOptions}

selectedKey={this.state.Status}

disabled={true}

SharePoint 2013 Hosting – HostForLIFE.eu :: New Improvements in SPFx v 1.10

Dec 12th

Posted by Peter in European SharePoint 2013 Hosting

Hi All, I hope many are aware of the new release of SharePoint Framework v1.10. I have summarized release details in a table for a quick review.

1. Extensions – Pre-allocated placeholders
Issue: Page is pushed down slightly when top header navigation (SPFx extension) is added between suite navigation and the header.
Cause: This is created by the top header extension being injected into the page when the page contents are downloaded.

Fix:
This issue is fixed by locking the area with pre-allocated placeholders(50px) for optimal experience by end-users.
You can control this experience by creating an item from Tenant wide extensions list -> Host properties column.

2. SPFx for Teams – Personal Apps support
Improvements: SPFx Teams tab development started from v1.6. They are added as tabs in the Teams channel. From v1.10 SPFx, the development also involves the Personal Apps in Microsoft Teams based on User context rather than a tab in Teams channel.
Proposed: We can specify this webpart manifest, whether it should be in SharePoint Webpart, Teams Tab, or Personal Tab in Teams.

3. List Notification API
Improvements: Whenever a new item is added to the list, the webpart displays the item dynamically without refreshing.

4. SharePoint Framework for Office – starts with OWA
Improvements: Extend the Outlook experience with SharePoint Framework development. For example, a user can add attachments from a SharePoint Library by creating a simple panel extension. Currently, this works with full support of REST API and Graph API.

5=>Search Suggestions
Improvements: No longer associated as SharePoint Search, it is now Microsoft Search and so it is displayed in Top bar.
Query is passed to Search API and results are displayed based on the word even with translation support.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Retrieve Lists from SharePoint using Webservice?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Useful CSOM Snippets

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Add SharePoint group to a site ?

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Get all Terms from the TermStore in SharePoint Using C#?

SharePoint 2013 Hosting – HostForLIFE.eu :: Office UI Fabric Choice Group Integration in SharePoint Framework (SPFx)

SharePoint 2013 Hosting – HostForLIFE.eu :: New Improvements in SPFx v 1.10

BLOGROLL

Featured On

European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Retrieve Lists from SharePoint using Webservice?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting UK – HostForLIFE.eu :: Useful CSOM Snippets

SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Add SharePoint group to a site ?

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Get all Terms from the TermStore in SharePoint Using C#?

SharePoint 2013 Hosting – HostForLIFE.eu :: Office UI Fabric Choice Group Integration in SharePoint Framework (SPFx)

SharePoint 2013 Hosting – HostForLIFE.eu :: New Improvements in SPFx v 1.10

BLOGROLL

Featured On

Tags