How to Perform CRUD Operations in SQL Server

Last Updated: February 20, 2017

crud operations in sql server

CRUD Operations stands for Create, Read, Update and Delete, these are the basic functions of any database. In this tutorial I will teach how to perform CRUD in SQL Server. Create = Create a Table / Insert Records into a Table Read = Select Records from a Table Update = Update Records in a Table Delete = Delete Records from a Table

Create a Student Table

I will first create a Student Table where I will perform CRUD Operations. This table contains the information of students in a School. In the Object Explorer of SQL Server right click on the Databases node and select New Database. (more…)

Entity Framework – How to Create an EDMX file in Visual Studio

Last Updated: February 16, 2017

entity framework create edmx file

Microsoft has created Entity Framework (short form EF) for helping developers to automate database related operations in C#, VB, C++ and other programming languages. Due to EF developers are not needed to do the lengthy ADO.NET programming as EF takes all its care.

EF helps developers in many ways like:
  • 1. Less database related codes.
  • 2. Fast development of projects.
  • 3. Better transaction.
  • 4. Testability improvements.
Here in this tutorial I will help you to get stated with Entity Framework. (more…)

How to Implement IMBD API using jQuery AJAX

Last Updated: February 13, 2017

Implement IMBD API using jQuery AJAX

By implementing IMDB API in a website you can show the visitors all movies, actors and series information, right in our website. Here I will implement the IMDB API using jQuery AJAX method. The first thing is to create your free IMDB API key from here.

The IMDB API Application

The application is quite simple. Firstly, create an HTML page and add a text box and a button. A user enters his search text into this text box and clicks the button. On the button click, the API call is made and the result is fetched and shown to the user. (more…)

Example: JQuery AJAX to Call an API

Last Updated: February 9, 2017

Example JQuery AJAX to Call an API

One of the best features o f jQuery AJAX is to load data from external website by calling their API’s, and get the response in JSON or XML formats. In this example I will show you how easy it is to make such API calls in jQuery AJAX.

OpenWeatherMap API

The OpenWeatherMap API’s provide with the complete weather information for any location on Earth including over 200,000 cities. Their API’s provide the response in JSON format. (more…)

How to Create a Web Scraper in ASP.NET MVC and jQuery

Last Updated: February 9, 2017

web scraper

A Web Scraper is a software that helps in extracting data from websites. They can be use to extract typical information like emails, telephone numbers, addresses, etc from different URL. This extracting technique is also known as Data Harvesting. I created this tutorial to teach how to create your own Web Scraper in ASP.NET MVC and jQuery. This Scraper will extract all emails and telephone numbers from a specified URL and show them in a HTML div control. (more…)

How To Use jQuery To Scroll To A Specific Element

Last Updated: February 1, 2017

jQuery scroll to element

With jQuery you can create excellent ways to increase the interaction with the users. One such way is by creating jQuery Scroll to Element feature. With this feature you can create internal links on your web page, when a person clicks on any such link he is scrolled to the specific element. This is very handy specially when the web page is quite large and with these internal links users are taken directly to the specific topics on the page. (more…)

How To Implement jQuery Infinite Scroll Feature For Auto Paging

Last Updated: January 30, 2017

jquery infinite scroll

The jQuery Infinite Scroll feature has become quite common now days. Different websites including Facebook and Twitter are using it. This feature helps in creating Auto Paging (not link-based paging) in a web page so when a user scrolls down to the bottom, the next page content are automatically loaded. This continues on and on. This feature is not only fast but also very good for the visitors as they don’t have to click on the page links given at the bottom of the web page. (more…)

How to Transfer From WordPress com To WordPress org

Last Updated: January 30, 2017

transfer wordpress com to wordpress org

Running website or blog through WordPress.com is good but only up to a certain point then you have to move your website to self-hosted WordPress i.e. WordPress.org. The reason to transfer your website from Wordpress com To Wordpress org is mainly because self-hosted WordPress (WordPress.org) provides you with full control of your website (Themes, Plugins & code). This full control of your website is missing in WordPress.com.

Benefits of WordPress.org
  • Totally Free and you don’t have to pay for adding stuffs and features to your site.
  • You can use millions of Plugins that are free to use from WordPress.org repository.
  • Show ads in your website and earn money.
  • Free to use millions of theme without restrictions.
  • WordPress.com sometimes restricts some websites that are not following its policies. This is not there when you are using Self Hosted WordPress.
  • Serious bloggers should use WordPress.org
(more…)

jQuery AJAX Events Complete Guide for Beginners and Experts

Last Updated: January 23, 2017

jQuery AJAX Events

When there is an AJAX call the jQuery AJAX Events are fired during the life cycle of the AJAX call. We can use these events to show custom message or do other operations.

There are 6 different jQuery AJAX Events:
  • 1. ajaxStart()
  • 2. ajaxSend()
  • 3. ajaxSuccess()
  • 4. ajaxComplete()
  • 5. ajaxStop()
  • 6. ajaxError()
(more…)

jQuery Post Complete Guide for Beginners and Experts

Last Updated: February 12, 2017

jquery post

The jQuery Post function is an AJAX method that fetches data from the server using HTTP POST. You can use it to call server page like .php or .aspx. Let us understand all about the jQuery Post method in details.

Syntax of jQuery Post Method

[js] jQuery.post( url [, data ] [, success ] [, dataType ] ) [/js] (more…)