Tutorial by Examples: le

Complete example with formulas

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create 2 WorkSheets ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); ExcelWorksheet worksheet2 = excelPackage.Workbook.Worksheets.Add("Sheet 2"); ...

epplus • Creating formulas and calculate ranges

Fastfile lane to build and install all flavors for given build type to a device

Add this lane to your Fastfile and run fastlane installAll type:{BUILD_TYPE} in command line. Replace BUILD_TYPE with the build type you want to build. For example: fastlane installAll type:Debug This command will build all flavors of given type and install it to your device. Currently, it doesn't...

Android • fastlane

Simple Message with in Bootstrap Modal

Code below will show you bootstrap model without writing hole long code by generating bootstrap model at run time. It will also make creating multiple bootstrap model i.e. one on other easy. Follow below simple code to make simple bootstrap model. Include below CSS to your code <link rel=&quot...

bootstrap-modal • Getting started with bootstrap-modal

Bootstrap Dialog with Title and Message Only

Include below CSS to your code <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.7/css/bootstrap-dialog.min.css&...

bootstrap-modal • Examples to Show bootstrap model with different attributes and Controls

Manipulating Dialog Title

Include below CSS to your code <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.7/css/bootstrap-dialog.min.css&...

bootstrap-modal • Examples to Show bootstrap model with different attributes and Controls

Animating between multiple states

The <div> in this template grows to 50px and then 100px and then shrinks back to 20px when you click the button. Each state has an associated style described in the @Component metadata. The logic for whichever state is active can be managed in the component logic. In this case, the component...

Angular 2 • Animation

AutoComplete with CustomAdapter, ClickListener and Filter

Main layout : activity_main.xml <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:id="@+id/activity_main" android:layout_width="match_parent" android:layo...

Android • AutoCompleteTextView

Sharing data from one controller to another using service

We can create a service to set and get the data between the controllers and then inject that service in the controller function where we want to use it. Service : app.service('setGetData', function() { var data = ''; getData: function() { return data; }, setData: function(requestData)...

AngularJS • Sharing Data

Example

ASPX <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt...

ASP.NET • View State

Isolation level READ UNCOMMITTED

Create a sample table on a sample database CREATE TABLE [dbo].[Table_1]( [Id] [int] IDENTITY(1,1) NOT NULL, [title] [varchar](50) NULL, CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_...

Microsoft SQL Server • PHANTOM read

Example

ASP.NET • WebForms

Example

Basic KatanaConsole Application namespace KatanaConsole { // use an alias for the OWIN AppFunc: using AppFunc = Func<IDictionary<string, object>, Task>; class Program { static void Main(string[] args) { WebApp.Start<Startup>(&...

ASP.NET • Katana

Invisible characters

Show or hide invisible characters To show invisible characters: :set list To hide invisible characters: :set nolist To toggle between showing and hiding invisible characters: :set list! Default symbol characters SymbolCharacter^ITab$New Line Customize symbols To set the tab characte...

vim • Vim Options

Classes and Multiple Inheritance

Swift does not support multiple inheritance. That is, you cannot inherit from more than one class. class Animal { ... } class Pet { ... } class Dog: Animal, Pet { ... } // This will result in a compiler error. Instead you are encouraged to use composition when creating your types. This can b...

Swift Language • Classes

A simple Hive UDF within Apache Spark

import org.apache.spark.sql.functions._ // Create a function that uses the content of the column inside the dataframe val code = (param: String) => if (param == "myCode") 1 else 0 // With that function, create the udf function val myUDF = udf(code) // Apply the udf to a column in...

Scala Language • User Defined Functions for Hive

Delete Key/ keys from Dictionary

set oDic = CreateObject("Scripting.Dictionary") oDic.add "USA", "United States of America" oDic.add "UK", "United Kingdom" oDic.add "CAN", "Canada" ' Delete only if Key exists If oDic.Exists("UK") Then oDic.R...

vbscript • Dictionary Objects

Global Exception Handling in ASP.NET Core

UseExceptionHandler can be used to handle exceptions globally. You can get all the details of exception object like Stack Trace, Inner exception and others. And then you can show them on screen. You can easily implement like this. app.UseExceptionHandler( options => { options.Run( as...

asp.net-core • Error Handling

Example: Consider will have two threads T1 and T2.

How do you detect them? If the same variable/resource/memory location is accessible by multiple threads and at least of the thread is changing the value of variable/resource/memory location, then Race Condition can occurred. Because if a thread is changing the value of variable/resource/memory ...

pthreads • Race condition in pthreads

Misusing GROUP BY to return unpredictable results: Murphy's Law

SELECT item.item_id, uses.category, /* nonstandard */ COUNT(*) number_of_uses FROM item JOIN uses ON item.item_id, uses.item_id GROUP BY item.item_id will show the rows in a table called item, and show the count of related rows in a table called uses. It will also show the va...

MySQL • Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...

Misusing GROUP BY with SELECT *, and how to fix it.

Sometimes a query looks like this, with a * in the SELECT clause. SELECT item.*, /* nonstandard */ COUNT(*) number_of_uses FROM item JOIN uses ON item.item_id, uses.item_id GROUP BY item.item_id Such a query needs to be refactored to comply with the ONLY_FULL_GROUP_BY sta...

MySQL • Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...