Normalization
Database Normalization
Normalization is a technique of managing records in a database. It is an approach to eliminate data redundancy and anamolies . It also removes data duplicacy in a record. It helps in data update,delete and insert anamol...
How to download an image automatically using Javascript
Hello Reader's!
If you want to make your file download by execution of JS then you can use the code below:-
var a = document.createElement('a');
a.href = "/favicon.png"; //make the link of image
a.download = "favicon.png";
document.body.ap...
How to show selected words in alert box using Javascript
Hello Reader's!
If you want to show what the text user has selected in a alert box, Then by using Javascript you can perform this task very quickly.
Step1:-
<div>Some test text for you to select</div>
Make a div that show...
How to make alert message on select the radio button using Javscript
Hello Reader's!
If you want to make an alert message for everytime user select the button then you can use the following JS as below:-
Lets say our HTML is like this:-
<input class="gender" type="radio" name="sex" value="male">Male &...
How to remove header and footer in print
When we print some html page bydefault the header and footer comes. On different browsers its in different way.
To remove it from chrome use
@page{
size: A4;
margin: 5mm; /* this affects the margin in the printer settings *...
Prepared Statement in Oracle
Prepared statement is used to execute same database statements repeatedly with high performance. For example, if you want to insert multiple employee records you can use same prepared statement again and again.
For below illustration it is as...
What is BUILD VERIFICATION TEST?
BUILD VERIFICATION TEST/SMOKE TEST are cursory tests that are helpful to determine the stability and testability of the build. These tests need to be run every time a build is deployed. The Build Verification test is preferable fast verification ...
When to start Automation Testing?
While automating GUI one has to be very careful, do not start the automating when the project starts, else you will ends up re-writing the the automation scripts. Many a times vendors provide training and support of automation tools to the resour...
Difference between px, dip and sp
If you are looking to know about the difference between px,dp,sp , here it is:-
px(Pixels) :-
px corresponds to actual pixels on the screen.
Pixel is the smallest element of a picture represented on the screen.
dip Density-...
Magento indexing issue
Sometime we face issues in reindexing like "Some problem with reindexing process" error, there are many reasons for it -
1) maximum execution of script
2) number of products in database and store view
3) locked files of previous process
...
Choosing the right tool for Testing?
Choosing the right tool is crucial to succeed in test automation. There are several factors that need to be considered when selecting a test automation tool. Some of the tools are free, some are expensive.
Here are some factors that you mi...
Less Scope
Values of less variable depends on the scope. If the value is not specified in the specific scope, LESS will look for it in upper blocks until it finds the nearest declaration.
Example:-
@text-color: #000000;
ul{
@text-color: #fff;
...
Login Authentication
Below i have written the code for Login Authentication, this code will check that weather the entered name and password are there in database or not.
The following code will return true boolean value if the entered name and password exist in dat...
How to do Nesting in Less
Nesting is used to style your structure of the stylesheet that matches the HTML structure of the page to reduce the chance of conflicts.
Example:-
ul{
background-color: #03A9F4;
padding: 10px;
list-style: none;
li{
backgr...
How to change the default controller in ASP.NET MVC
Many times we need to change the default controller in ASP.NET MVC. To change this
first we need to understand how the default route is configured. This setting is
available in RouteConfig file (under App_Start folder).
routes.MapRoute(
...
How to overload the action Method in ASP.NET MVC
In this article we will see how to overload the action Method in ASP.NET MVC. Overloading is the scenario where we have two methods with
the same name but different signatures. At compile time, the compiler finds out which method it is going t...
Anonymous function in php
Anonymous functions, is a function that allows the creation of a function without any specific name. We can use it as follows:
1-Assign it to a variable, then call it later using the variable's name.
2-We can store an array of different ano...
Selecting the first n rows, Pagination, Rownum & ROW_NUMBER() in Oracle
There will be requirement where you might need to select the first n rows, or do pagination in Oracle. This can be achieved using Rownum.
Lets create sample table and data to understand the logic.
create table Employees (
id number ...
Creating service through provider and factory in angularjs.
We can create service through provider,service,value and factory. In this blog I am describing provider and factory. For value and service you can refer to my previous blog -Calculate area of a circle using .value and .service in angularjsBy crea...
Outer joins in database query
Joins in database, We can easily determine the meaning of joins very easily. In database we use the concept of joining in tables to fetch the data combination. There
are different type of methods of joining two or more than two tables in databas...
Comparison of ViewData, ViewBag and TempData
Generally in ASP.NET MVC we use the ViewData,ViewBag, and TempData objects for the purposes of moving data beween
views or from controller to views.In this post we compare them against each other higlighting there difference
and usage patterns...
How to use TempData to pass data ?
ASP.NET MVC TempData object is used to share data between controller actions.It is a dictionary object derived from TempDataDictionary.
The value of TempData persists until it is read or until the current users session times out.TempdData can b...
How to handle Error 404 in ASP.NET MVC
In the following article we will learn how to handle 404 errors in ASP.NET MVC gracefully.
The first step will be to set up the custom errors page by making the following settings in web.config:
<system.web>
<compilation d...
What is a CDN in jquery?
Hello Readers,
CDN is a content delivery network or we also call it as content distribution network, its basically a large distributed system of servers which deployed in multiple data centers across the internet.
Goal of CDN:
Serve co...
JavaScript string prototype property
prototype property in JavaScript: The prototype property gives us freedom to add the new property and method into the object at any time. This is the global property in JavaScript which can be called through any JavaScript object at any time.
...
How to pass multiple optional parameters using Laravel 4.x
As we all know that routes plays an important role in any MVC framework. In Laravel we will define our routes in routes.php. Using Laravel 4.x we have the option to pass multiple optional parameters using Laravel 4.x.
By using example it can b...
Difference between body document.ready() and window.onload() function
Hello Readers,
document.ready : document.ready is an specific jQuery event when the entire HTML have been loaded.
window.onload : window.onload is a normal JavaScript event.
The below are some point to define the difference between docum...
jQuery.noConflict in jquery
Hello Readers,
jquery.noConflict is the jquery function (jquery is the client side library) when we use the jquery.noConflict function in jquery it removes the conflict between different jquery libraries like Mootools, Prototype etc. they also...
Some Important Tips to write a Prefect Meta Description
As far as SEO is concerned, the Meta Description tag is always an important part of any website seo. Apart from the background parameters, the major search engine result page(SERP) mainly shows three things:
Title of a Website
Url /...
String methods charAt and charCodeAt in JS
charAt() method : This method returns the character exist in a specified index of string.The index in a string always starts with 0.
Syntax of charAt() method :
string.charAt(index)
The index is required field. If no character is foun...
length property in JavaScript String
length property in JavaScript String : Strings in JavaScript are sequence of characters. What if you want to know the number of characters a string has, solution is call the property called length on string object. JavaScript string has the prope...
Listing the videos stored in gallery
Hello friends,
The following code can be used to show the videos stored in gallery:
UIImagePickerController *imagePicker = [[UIImagePickerController alloc] init];
imagePicker.delegate = self;
imagePicker.sourceType = UIImagePicke...
Lazy loading in android RecyclerView
Step 1:- create an xml file image_recyclerview.xml
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_h...
How to make Linkify function in android
Using below code i have created Linkify function. Here I have created MainActivity class and In main.xml layout I have added Text View property. Below code will clearly described you how to make Linkify function.
Step(1)-Create MainActivity-
...
Sending notification to IOS device using C# code
In one of my current project, I had to develop and integrate the IOS notification functionality in my server side C# code. I did some RnD for this and found below mentioned code to serve this purpose.
public void SendNotification(string device...
How to Generate Google Analytic Code and Implement on Website
Google analytic code generation and implementation on website is an important SEO task that need to be done so that a webmaster can easily analyse and monitor the performance of his webs...
How to use Less Mixins
LESS gives us the oportunity to use an existing class or ids and apply all its styles directly to another selector.
Example:-
#circle{
background-color: #4CAF50;
border-radius: 100%;
}
#small-circle{
width: 50px;
height: 50...
Change UISearchBar Field Text Color in iOS
You can change UISearchField text color in iOS. Use single line of code to do it.
[[UILabel appearanceWhenContainedIn:[UISearchBar class], nil] setTextColor:[UIColor whiteColor]];
Happy Coding!!!
Change UISearchBar appearance in Objective C
If you want to change the appearance of UISearchBar and its related elements then use below code.
-(void)changeSearchBarAppearance{
[[UITextField appearanceWhenContainedIn:[UISearchBar class], nil] setBackgroundColor:[UIColor whiteCol...
Pure virtual function in C++
In C++, Pure virtual method or pure virtual function is a virtual function in which virtual function does not contain a definition inside the function declaration. A pure virtual function/method is declared by assigning a function equal to 0 in d...
Android Studio Tips and Tricks: Keyboard Commands
Programming key commands
Action
Android Studio Key Command
Command look-up (autocomplete command name)
CTRL + SHIFT + A
Project quick fix
ALT + ENTER
Reformat code
CTRL + ...
How to use SharedPrefrence in Android
SharedPrefrence help us to store private primitive app data in form of key value pairs, but the data is lost when you uninstall the application or you clear application data through settings.To use the SharedPrefrence in your android app follow t...
How to Create Perfect Meta Title Tags for Web-pages
Meta Title Importance
When we talk about keyword rank with respect to some specific search engine let us say Google t...
Laravel join with 3 Tables
As we all know that when we are working on the big project then there is a need of join 2-3 table to get the result.
We can easily understand that by using example of joining 3 table.
Example:
$shares = DB::table('shares')
->join...
Structure of Android Manifest file
In every android application AndroidManifest.xml is the necessary part. Manifest file contains every essential information about your appliucation. It contains information about your package, activities, permissions, services, brodcast receiver a...
Could not inspect the application package when using device
Could not inspect the application package when using device
How to autoload Guzzle in Laravel 4
It becomes easier with Guzzle, which is a PHP HTTP, to send HTTP requests. Moreover, one can easily perform the task of integrating with web services. Guzzle enables to send both synchronous and asynchronous requests.
Guzzle using Laravel 4.x:...
For Loop in C
For Loop: allow us to efficiently write a loop that needs to be executed specific number of times.
Syntax:
for(init statement; test expression; increment)
{
code(s) to be executed;
}
The init statement allow us to
initia...
Installing mongodb on ubuntu
Install mongodb on ubuntu
Hi friends,
Today I am going to give you a step-by-step guide of how to install mongodb on ubuntu server. The steps are:
First we need to import the mongodb public GPG key to verify the authenticity of di...
Variables in Less
The one of the main feature of Less is the variables just like in a standard programming language. Variable can store any type of value colors, dimensions, selectors, font names, URLs etc. The use of less is to reuse the CSS syntax where ever pos...