July 2015 – Bruce Ng's software development blog

Generate connection string

Follow SO question: http://stackoverflow.com/questions/10479763/how-to-get-the-connection-string-from-a-database

Extend a Sharepoint web app to another port

You can extend existing Sharepoint web application to another application on another port. A new IIS site will be created for the new web application.

Go to Central Admin, select manage web applications, select the web app you want to extend and click “Extend” on the ribbon.

Error Occurred in Deployment step ‘Recycle IIS Application Pool’

http://stackoverflow.com/questions/21278281/error-occurred-in-deployment-step-recycle-iis-application-pool

When a page cannot be edited in edit mode

add “?controlmode=edit” to the URL to resolve

scroll using pure javascript

To scroll down to an element in the page. The best way is to use function scrollIntoView

Pure javascript

var theElement = document.getElementById(‘yourElementId’);
theElement.scrollIntoView();

Using jquery to select element:

$(SELECTOR)[0].scrollIntoView();

The offline tool I’m currently using http://greggigon.github.io/my-personal-kanban/ . Simple, fast and easy to use. Just create an IIS web application and put this inside. Make sure to export and backup data regularly.

Time tracking

Time tracker at http://0xff.net/site/index.php/timetracker/downloads/ seems to have a really great UI and easy to use with automatic tracking with reports and ability to export.

Check if a variable is undefined in javascript

if(typeof variable_here === 'undefined'){
   // your code here.
 };

Get the domain name with port number in javascript

var arr = window.location.href.split(“/”);
var url = arr[0] + “//

Check if it’s edit mode in javascript in Sharepoint

var wikiInEditMode = document.forms[MSOWebPartPageFormName]._wikiPageMode.value;
if (wikiInEditMode == “Edit”)
{
// wiki page is in edit mode
}
else
{
// wiki page is not in edit mode
}

Another solution http://sharepoint.stackexchange.com/questions/12792/how-do-i-know-if-the-page-is-in-edit-mode-from-javascript

var inDesignMode = document.forms[MSOWebPartPageFormName].MSOLayout_InDesignMode.value;

if (inDesignMode == "1")
{
    // page is in edit mode
}
else
{
    // page is in browse mode
}

How to find culture and publickeytoken of dll deployed on GAC

https://camerondwyer.wordpress.com/2013/11/01/how-to-find-the-version-culture-and-publickeytoken-of-an-assemby-dll-using-powershell/

Or use the SN tool in VS Developer command prompt.

If the assembly has been deployed to GAC, navigate to the folder containing the assembly and follow the article above, using reflection to load the assembly.

Month: July 2015