Blog

By Team Escalera on 26 Dec 2017 11:10 AM
  • Joins
0 comments

A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

Types Of Join -

  • INNER JOIN: Returns records that have matching values in both tables
  • LEFT OUTER JOIN: Return all records from the left table, and the matched records from the right table
  • RIGHT OUTER JOIN: Return all records from the right table, and the matched records from the left table...............



By Team Escalera on 19 Dec 2017 01:06 PM
  • Type of Loop in C#
0 comments

1. while loop

It repeats a statement or a group of statements while a given condition is true. It tests the condition before executing the loop body.

Syntax:    while(condition) { statement(s); }

2. for loop

It executes a sequen...............



By Team Escalera on 31 Oct 2017 03:34 PM
  • Information
0 comments

If you are a Software Developer looking to enhance your skills or a fresher with little coding knowledge; Join The Software Training Program in Vikas Nagar ( Near Aliganj, Mahanagar, Indira Nagar & Janki Puram). This program will help you get industrial exposure in Information Technology. Our focus is on providing Training on Live projects alongwith full documentation. We provide training on Asp dot net (. net), C#, core & advanced php, C , C ++ etc.

Why Software Development...............



By Team Escalera on 31 Oct 2017 03:32 PM
  • learn C#
0 comments

Class Constructor Example C#

class Person
{
private int age;
private string name;
public Person(string pn)
{
name = pn;
}

public string printName()
{
return name;
}
}
static void Main(string[] args)
{
Person b= new Person(“Manish”);
Console.WriteLine(b.printName(...............



By Team Escalera on 31 Oct 2017 03:29 PM
  • Information
0 comments

Variables c sharp

A “variable” is created in C # programming to reserve a location in memory space to store values. Variable as the name suggests has dynamic values. A variable has a Name and a Data Type.
Data Type can be string, integer, double, float etc.
A Variable must be declared with its data type and then can be used in the program.

Variable are used to perform logical operations.

An Example of Variable Name is yourName


By Team Escalera on 31 Oct 2017 03:27 PM
  • interview questions
0 comments

We can use this code to Calculate Sum of All Elements in array
We can use FOREACH Loop for this task.

int[ ] arr = {13, 36, 63, 556, 990};
int sum = 0;

foreach (int a in arr) {
sum += a;
}

Console.WriteLine(sum);


//This Code Outputs :  “1658” Because 13 + 36 + 63 + 556 + 990...............



By Team Escalera on 31 Oct 2017 03:25 PM
  • interview questions
0 comments

What are destructors in C #

In C # Class is instantiated when Constructors are used but when an Object of a Class is deleted Class Destructors are automatically invoked.

  • There can be only one destructor for a class.
  • A Destructor is not called / cannot be called, it is invoked automatically.
  • A Destructor cannot be modified using modifiers
  • A Destructor cannot have parameters

A Destructor Shares same name with ...............



By Team Escalera on 31 Oct 2017 03:24 PM
  • learn C#
0 comments

A Folder Named App_Code is created by Visual Studio in our Application by Default.

We have to create a Public Class in that folder.
And then write our function which we want to replicate in multiple pages.

Then :-
In the respective pages simply create the object of that public class, all the objects will be able to access
all the public functions of that class.

In the class (in App_code)

public class themainclass


By Team Escalera on 31 Oct 2017 03:20 PM
  • learn C#
0 comments

It is sometimes needed to generate random integers in C# programming.

Random integers can be used  for human verification in Math Captcha .

Random integers can be used for sms verification etc.

Let’s see how to do it.

Our Aspx Code

<asp:Content ID=”Content2″ ContentPlaceHolderID=”MainContent” Runat=”Server”>

    <asp:Label ID=”lblR...............



By Team Escalera on 31 Oct 2017 03:19 PM
  • asp.net training
0 comments

Text to md5 in C Sharp Password Encryption

To Convert a value from TextBox in Asp.net using C# into md5 hash

use following assembly reference in your page
using System.Security.Cryptography; \\FOR MD5

using System.Text;\\For ASCII encoding

And code :

public string GetMD5(string text)

        {

  ...............



By Team Escalera on 31 Oct 2017 03:17 PM
  • asp .net training in lucknow
0 comments

Inheritance

It can be defined as an “Is – A” relationship.

A Class has Parameters and Methods. There can be another class with same parameters as the Main class.

In this case the Main Class is known as Base Class and the Other Class is known as derived class as it will “Inherit” the methods and parameters from the Base Class.

Let Shape is a Class and Base, Radius,&n...............



By Team Escalera on 31 Oct 2017 03:15 PM
  • learn C#
0 comments

Lets Create a String and name it ‘x’

string x = “good text”;
Console.WriteLine(x.Length);

// x.Length will return the length of String, it will count spaces  as well.
//Outputs 9

Console.WriteLine(a.IndexOf(‘t’));

//It will return the position of ‘t’
//Outputs 5

x= x.Insert(0, “This is “);
Console.WriteLine(x)...............



By Team Escalera on 31 Oct 2017 03:13 PM
  • asp .net training in lucknow, C# basic concepts, learn c#
0 comments

This is a sample program in C#(sharp) :

The get and set accessors can be used for  defining an indexer.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

 

namespace EscaleraT

{

class Program

{

class Clients {

private string[] names = new string[10];

<...............



By Team Escalera on 31 Oct 2017 03:09 PM
  • Protected Access Modifier
0 comments

A Protected Access modifier is almost like the Private Access Modifier but with
a difference that Protected access modifier can be accessed only from a derived class.

class Human{
protected int Age {get; set;}
protected string Name {get; set;}
}
class Employee: Human{
public Employe(string nm) {
Name = nm;
}
public void Speak() {
Console.Write(“N...............



By Team Escalera on 31 Oct 2017 03:08 PM
  • Website Development Training Lucknow
0 comments

Most of the business now a days require a website for providing information, notifications, services, etc. to customers. Many Entrepreneurs require a website as a business idea. A Web Application is must in many cases for financial accounting and analysis.

In short, requirement of websites is increasing day by day and companies are looking for website developers with good coding skills and some experience of working on live projects. Escalera is providing Website Development Training...............



By Team Escalera on 31 Oct 2017 03:06 PM
  • Escalera
0 comments

Escalera is a word from Spanish origin. Meaning of Escalera is “LADDER” something that escalates. Escalera word is use to form the word “Escalator”. Escalators are automatic ladders installed in Malls, Foot Over Bridges, Air Ports, Hospitals etc.

Escalera Technologies has an aim of escalating the careers of Technical Professionals to a new height.

...............



By Team Escalera on 31 Oct 2017 03:03 PM
  • PHP training
0 comments

A Simple method to take user input and calculate the sum of two numbers in php is given below :

First Create an HTML Form with two text input fields and one submit button

<form method=”post”>
<input type=”text” name=”firstnumber”>

<input type=”text” name=”secondnumber”>

<input type=”submit” name=”Ca...............



By Team Escalera on 31 Oct 2017 03:02 PM
  • asp.net training, C Sharp Training
0 comments

Let’s consider this example to understand the Usage of AND operator. AND operator is written as ‘&&’ two ampersands. It is used for getting results only if all the conditions are true , all the conditions are separated by && operator.

int age = 55;
double salary = 540;
if(age > 18 && salary > 100) {
Console.WriteLine(“Welcome User”);
}

Here we declared age as 55 and ...............



By Team Escalera on 31 Oct 2017 02:59 PM
  • learn C#
0 comments

C# has  various classes that are built-in and they can store and manipulate data.
An example of such a class is the Array class.
In order to store a collection of data the data structure that is used in C# is known as array. It can be described as a collection of variables of the same type.
Let’s assume a situation where you need to store 250 numbers. One option is to declare 250 different var...............



By Team Escalera on 31 Oct 2017 02:58 PM
  • learn C#
0 comments

This post is helpful if the task is : Providing Initial Values to an Array.

When an array is declared by using curly brackets we can provide initial values to it :

string[ ] cities= new string[3] {“Delhi”, “Mumbai”, “Lucknow”};

We can omit the size declaration when the number of elements are provided in the curly braces:

string[ ] cities= new string[ ] {“Delhi”, “Mumb...............



By Team Escalera on 31 Oct 2017 02:55 PM
  • Arrays
0 comments

Here lets create an array of Fruits (of same data type string)

Name of Our Array is mystrArray and it has 5 elements.

 

string[] mystrArray = new string[] { “Apple”, “Banana”, “Grapes”, “Mango”, “Pine-Apple” };
 
// Reading array items using foreach loop
foreach (string mystr in mystrArray)
{...............



By Team Escalera on 31 Oct 2017 02:54 PM
  • Learn C#
0 comments

Many operators in C# can be overloaded, it means that they can be redefined for custom actions.
For example, you can redefine the action of the plus (+) operator in a custom class.
Consider the Box class that has Height and Width properties:

class Box {
public int Height {get; set;}
public int Width {get; set;}
public Bo...............



By Team Escalera on 31 Oct 2017 02:52 PM
  • Digital marketing course
0 comments

What is Digital Marketing ?

Digital marketing is the promotion of products or brands with the help of one or more forms of digital media.

Experts believe that one must be good at digital marketing in today’s online world in order to get more eyes on the merchandise / enterprise / organization etc.

Some Examples of Digital marketing module are :

  • Search engine optimization (SEO),
  • Search engine marketing (SEM),
  • Content marketi...............



By Team Escalera on 31 Oct 2017 02:45 PM
  • sitelinks
0 comments

Google Sitelink searchbox is the search box which is dedicated to a particular website.

It is placed inside the Sitelink results of any website when users search it’s name in google.

An Example of Sitelink Searchbox for Snapdeal.com is shown below :

The following examples demonstrate how to implement sitelinks searchbox markup on your website using JSON-LD and Mircodata, or on your website and a...............



By Team Escalera on 31 Oct 2017 02:41 PM
  • Php training in lucknow
0 comments

JSON (JavaScript Object Notation) is a lightweight data-interchange format.

Let’s have a look at an example JSON Output (From Railway API)

“TRAIN_NUM”: “12429”,

“FROM_STATION”: {

        “CODE”: “LKO”,

        “NAME”: “LUCKNOW”

    },

...............



By Team Escalera on 31 Oct 2017 02:39 PM
  • learn php in lucknow
0 comments

Constants

Constants are like variable but they cannot be changed or undefined after they’ve been defined.
Begin the name of your constant with a letter or an underscore.
To create a constant, use the define() function: define(name, value, case-insensitive)
Parameters:
name: Specifies the name of the constant;
value: Specifies the value of the ...............



By Team Escalera on 31 Oct 2017 02:37 PM
  • Bootstrap
0 comments

Testing Popup

<html>
<head>
<title>This is my title</title>

<meta charset=”utf-8″>
<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>
<meta name=”viewport” content=”width=device-width, initial-scale=1″>
<meta name=”description...............



By Team Escalera on 31 Oct 2017 01:05 PM
  • Digital Marketing
0 comments

If you are planning to build a basic website for your / client’s organization you can always go for a CMS ( Content Management System ) rather than a website with 5-6+ HTML Pages.

Benefits of using a CMS for Basic website development with SEO (Search Engine Optimization) in mind are as follows :

1.A website with repeated html page templates ( ...............



By Team Escalera on 31 Oct 2017 01:02 PM
  • Website Development
0 comments

In this article we will discuss about some important tools for PHP Website Development.

php

PHP website can be developed and tested locally ( using desktop or laptop computer ). PHP is a server side scripting language and hence a local OR web server is needed to test and run a PHP website. Most widely used web server for php is Apache. Most of th...............



By Team Escalera on 31 Oct 2017 01:00 PM
  • MySQL
0 comments

A local MySql database is used for locally hosted website and web development as discussed in the previous articles.

Why MySql ?

MySql is opensource.
MySql queries are as simple as writing a sentence to fetch data (after some practice).
MySql support community and user base is huge. You will get answers for almost any query on forums.

How to transfer MySql database ?

  • Go to your database or table after opening localhost/phpmyadmin.
  • ...............



By Team Escalera on 31 Oct 2017 12:57 PM
  • asp.net training, WordPress Training
0 comments

Frameworks are software packages that complete the need of various types of backend requirements of a system internally. Most importantly, designers are not required to develop this backend functionality.

An expert frontend designer can use these frameworks to develop and fulfill the backend requirements.

Frameworks are primarily of two types:

  1. Content Management System
  2. Application Management System

As a Content Management System Opensou...............



By Team Escalera on 14 Oct 2017 11:55 AM
  • Trigger
0 comments

We are going to discuss about TRIGGERS in SQL – SERVER in this article. Triggers are very important in enterprises level database management. You have to understand following table:
This command will create a table on which we will apply triggers:

1. Create table Staff(id int NOT NULL PRIMARY KEY IDENTITY(1, 1), name varchar(55), email varchar(55));
2. Create table Log_Audit(id int NOT NULL PRIMARY KEY IDENTITY(1, 1), StfId int, StfName varchar(50),&nbs...............



By Team Escalera on 14 Oct 2017 11:31 AM
  • Recursion
0 comments

A method that calls itself is called a recursive method.

Calculating the factorial of a number is One of the tasks that can be solved using recursion.
In Maths,  Factorial of a number x is denoted as x! and it is :
For example:5! = 5*4 * 3 * 2 * 1 = 120

It concludes that the factorial of any number can be calculated using number x number-1 and such that : number-1 reaches “...............



By Team Escalera on 14 Oct 2017 11:29 AM
  • Encapsulation
0 comments

To understand what encapsulation means, it can be considered as “surrounding” an entity, to keep and protect whatever is inside the surrounding.

It has a similar concept in programming as well, here encapsulation has a wider meaning than combining the members together within a class; it has a function of access restriction to the inner workings of that class as well.
Access modifiers implements E...............



By Team Escalera on 14 Oct 2017 11:27 AM
  • Strings
0 comments

Arrays of characters is a good example to explain Strings in C#.  But actually Strings are Objects in C#.
While declaring a string variable, an object of type “String”  is  instantiated.
Various useful properties and methods are supported by String objects.

Some examples are given below:
Length –  To get the length of a string.
Insert(index...............