Author Archives: Lin Zhang

SharePoint and GAC

Reference: What is the GAC folder When developing solutions for SharePoint platform, you will often deploy your solutions to GAC folder and use libraries that are already deployed to GAC, maybe even without knowing it. What is GAC folder? … Continue reading

Posted in SharePoint 2010, SharePoint 2016 | Leave a comment

Cannot access MySites – 403 Forbidden, Access Denied, This web site requires you to login…

Give ‘everyone’ read permission to ‘C:\inetpub\wwwroot\wss\VirtualDirectories\mysites.xxxxxx80\bin’ folder

Posted in SharePoint 2016, Uncategorized | Leave a comment

How to get administrative access to the OneDrive for Business (Mysites) environment of a user

Go to Central Administration > Application Management > Manage service applications > User Profile Service Application > Manage User Profile Search for the user’s login name, when found, click on the user’s profile and then select ‘Manage Site Collection Owners’ … Continue reading

Posted in SharePoint 2016 | Leave a comment

C# Read Excel file with worksheets

using System.Data; using System.Data.OleDb; private void readExcel () { OleDbConnection conn = new System.Data.OleDb.OleDbConnection((“provider=Microsoft.ACE.OLEDB.12.0; ” + (“data source=C:\\Projects\\Driver Reports.xlsx; ” + “Extended Properties=’Excel 12.0;HDR=Yes;IMEX=1;’;”))); // Select the data from Sheet1 of the workbook. OleDbDataAdapter ada = new OleDbDataAdapter(“select * from … Continue reading

Posted in Excel, SharePoint 2016, Visual Studio 2010 | Leave a comment

Overcoming the List View Threshold in SharePoint CAML queries

Great article written by Jonathan Cardy: How to write scalable CAML queries that won’t return list view threshold errors on large SharePoint lists. Introduction When your CAML queries start to hit the list view threshold, you’ll think it will … Continue reading

Posted in CAML, SharePoint 2010, SharePoint 2016 | Leave a comment

SharePoint 2016 – Change SuitBar’s Text, add a logo and URL – PowerShell

This is how you can change the OOTB ‘SharePoint’ text on the top left corner, and also add your logo and URL: Add-PsSnapin Microsoft.SharePoint.PowerShell $webapp = Get-SPWebApplication “” $webapp.SuiteNavBrandingText = “Home Page” $webapp.SuiteNavBrandingLogoTitle = “Home Page” $webapp.SuiteNavBrandingLogoUrl = “” $webapp.SuiteNavBrandingLogoNavigationUrl … Continue reading

Posted in SharePoint 2016 | Leave a comment

Rich Text Box (InputFormTextBox) not working within UpdatePanel in SharePoint 2016

After we have migrated some web parts from SharePoin 2010 to 2016. The rich text box (InputFormTextBox) is not working properly inside UpdatePanels. Symptoms: After each Ajax call or partial page update: 1. An extra rich text box appears on … Continue reading

Posted in SharePoint 2016 | Leave a comment