In the previous blog, I wrote about “How to Export SharePoint list items in Excel using PowerShell script“. In this blog, we will see how to get SharePoint list items and store them in the SQL table.To do this you must have a SharePoint site with a list having few rows in it.Now create a … Read more
In this blog, I will write about “How to Export SharePoint list to a excel file?”.As you know, SharePoint list is a combination of rows and columns. It is similar to a table. There are multiple ways to export SharePoint list to excel or CSV file, in this blog I will explain about How to … Read more
Create Data Table while using SharePoint 2010 Client Context with .Net Code I am using .net code to access SharePoint List.I created a method ExecuteSPQuery() which returns Data Table. For that I wrote below code. public static DataTable ExecuteSPQuery() { DataTable dtData = new DataTable(); Microsoft.SharePoint.Client.ListItemCollection listCollection = null; ClientContext context = new ClientContext(“SITE_URL”); try { Site oWebsite = context.Site; context.AuthenticationMode = ClientAuthenticationMode.Anonymous; List list = … Read more
MasterPage and Branding in SharePoint What is branding? – Branding means to design or recreate a page for a site which may use SharePoint Master Page. What is Master Page? – Master Page gives a consistent layout through out the site. For eg – Header, Footer, Top Menu Why We need to do Branding ? … Read more
Display SharePoint List Items using ECMA Script In this blog, I will explain, how to get list items using ECMA Script.ECMA script is a client side way to work with SharePoint object. Create a web part page in page library. Add a content editor web part on that page.In content editor webpart write below code: … Read more
As you know pagination is very important for any data control for eg Gridview if you have large amount of data. Server load on pagination is also a big concern.Below is the code for pagination in gridview using client side. It means no page load/ server post back operation will be performed. To implement this … Read more
What is Throttling and Indexing in SharePoint List? In SharePoint, List is like a table with rows and columns. Similar to SQL tables SharePoint List need indexing if contains heavy amount of data else it will degrade the performance of SharePoint application. So what is Indexing in SharePoint List? Indexing in SharePoint list is similar … Read more
Updates are currently disallowed on GET requests. To allow updates on a GET, set the ‘AllowUnsafeUpdates’ property on SPWeb. I searched on google and found the solution.You need to update webapplication throttle setting through powershell command $w = get-spwebapplication http://mysite:2015$w.HttpThrottleSettings$w.Update() List Threshold setting page should open now.
As per MSDN definition, QueryThrottleMode is a property of SPQuery class which gets or sets value that indicate the throttling mode to be applied to the query. As we know that List Throttling is a new option available in SharePoint 2010. List Throttling limits the list data that will be fetched in a single request.Beyond the limit, request will … Read more
I was working on SharePoint Client Context, and i was writing a piece of code to fetch items from SharePoint list. I got this error at this line:objContext.ExecuteQuery(); I solved this issue by executing powershell command.Open SharePoint Powershell and type below command one by one. $webapp = Get-SPWebApplication “http://spserver”$webapp.ClientCallableSettings.AnonymousRestrictedTypes.Remove([microsoft.sharepoint.splist], “GetItems”)$webapp.Update()Open SharePoint Powershell and type below command … Read more