Tutorial by Examples

This line of code demonstrate how to check if a specific field is NULL or has blank value =IIF(IsNothing(Fields!UserEmail.Value) OR Fields!UserEmail.Value = "", "Empty", "Not Empty") This line of code checks if the field is NULL IsNothing(Fields!UserEmail.Value) ...

Excel -> Save as -> Save as type -> "Comma separated value (*.csv)" AND Tools (left to Save button) -> Web options -> Encoding -> Save this document as -> Unicode (UTF-8)

The host file is used to store connections for Anisble playbooks. There are options to define connection parameters: ansible_host is the hostname or IP address ansible_port is the port the machine uses for SSH ansible_user is the remote user to connect as ansible_ssh_pass if using a password to ...

function lastRowForColumn(sheet, column){ // Get the last row with data for the whole sheet. var numRows = sheet.getLastRow(); // Get all data for the given column var data = sheet.getRange(1, column, numRows).getValues(); // Iterate backwards and find first non empty cell ...

The pyplot interface to matplotlib might be the simplest way to close a figure. import matplotlib.pyplot as plt plt.plot([0, 1], [0, 1]) plt.close()

A specific figure can be closed by keeping its handle import matplotlib.pyplot as plt fig1 = plt.figure() # create first figure plt.plot([0, 1], [0, 1]) fig2 = plt.figure() # create second figure plt.plot([0, 1], [0, 1]) plt.close(fig1) # close first figure although second one is active ...

This is how the Asset Catalog in Xamarin Studio looks like, As shown in above picture there are 5 types of assets you can create within the catalog. I will cover only image set, because its the simplest one. When you create a new image set. You will get options like this To add images to the...

A path through every vertex exactly once is the same as ordering the vertex in some way. Thus, to calculate the minimum cost of travelling through every vertex exactly once, we can brute force every single one of the N! permutations of the numbers from 1 to N. Psuedocode minimum = INF for all per...

Notice that if we consider the path (in order): (1,2,3,4,6,0,5,7) and the path (1,2,3,5,0,6,7,4) The cost of going from vertex 1 to vertex 2 to vertex 3 remains the same, so why must it be recalculated? This result can be saved for later use. Let dp[bitmask][vertex] represent the minimum c...

db.collection.createIndex() method is used to create a 2dsphere index. The blueprint of a 2dsphere index : db.collection.createIndex( { <location field> : "2dsphere" } ) Here, the location field is the key and 2dsphere is the type of the index. In the following example we are goi...

Download the Stripe API Library and place it in vendor Folder source : [https://github.com/stripe/stripe-php][1] include the library in your controller use Stripe\BalanceTransaction; use Stripe\Charge; use Stripe\Stripe; require_once('../vendor/stripe/init.php'); set the strip key \Stripe...

NOTE: for best results, make sure your project was created using the Angular-CLI. npm install angular/{core,common,compiler,platform-browser,platform-browser-dynamic,http,router,forms,compiler-cli,tsc-wrapped,platform-server} You don't have to do this step if you project already has angular 2 an...

... "angularCompilerOptions": { "genDir": "./ngfactory" } ... This is the output folder of the compiler.

from the root of your project ./node_modules/.bin/ngc -p src where src is where all your angular 2 code lives. This will generate a folder called ngfactory where all your compiled code will live. "node_modules/.bin/ngc" -p src for windows

// this is the static platform browser, the usual counterpart is @angular/platform-browser-dynamic. import { platformBrowser } from '@angular/platform-browser'; // this is generated by the angular compiler import { AppModuleNgFactory } from './ngfactory/app/app.module.ngfactory'; // note the...

Once you've installed react and react-router, Its time to use both of them together. The syntax is very simple, you specify the url and the component you want to render when that url is opened <Route path="hello" component={ HelloComponent } /> This means when the url path is hell...

When user enters an URL, for example: http://example-website.com/Example/HelloWorld, MVC application will use the routing rules to parse this url and extract the subpath, that will determine the controller, action and possible parameters. For the above url, the result will be /Example/HelloWorld, wh...

If there would be another value in the URL like: /Example/ProcessInput/2, the routing rules will threat the last number as a parameter passed into the action ProcessInput of controller Example. public ActionResult ProcessInput(int number) { ViewData["OutputMessage"] = string.format(...

Using a small transparent image called empty.png public class MyPage : ContentPage { public Page() { if (Device.OS == TargetPlatform.Android) NavigationPage.SetTitleIcon(this, "empty.png"); } }

Label label = new Label { Text = "text" }; if(Device.OS == TargetPlatform.iOS) { label.FontSize = label.FontSize - 2; }