SQL Server - Differences between Functions and Stored Procedures

Introduction:

Here I will explain the difference between stored procedure and function in SQL Server.

Description:

In previous posts I explained difference between Left Join and Left Outer Join, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between stored procedure and function in SQL Server.

jQuery slideUp slideDown slideToggle Effects Example /Sample

Introduction: 

Here I will explain how to implement simple div with JQuery slideup, slidedown and slidetoggle effects in asp.net.

Description:
  
In previous posts I explained jQuery fadein fadeout fadeto div example, Best jQuery Drag and Drop Plugins, Draggable and Resizable example, split the string, add fade in effect to page and many articles relating to JQuery. Now I will explain how implement simple div with slideup, slidedown and slidetoggle effects in JQuery.

12 Best jQuery Drag and Drop Plugin Examples/Tutorials

Introduction: 

Here I will explain 12 best jQuery drag and drop plugin examples to implement drag and drop functionalities  using jQuery.

Description:
  
In previous article I explained 11+ best jQuery Scroll to top plugins, 9+ JQuery AutoComplete plugins, 6+ JQuery Password Strength Plugins and JQuery, Ajax, asp.net, SQL Server etc. Now I will explain different type of available JQuery drag and drop plugin examples.

jQuery text fadein fadeout fadeto Effects div Example in Asp.net

Introduction: 

Here I will explain how to implement simple div with fadein fadeout, fadeto effects using JQuery in asp.net.

Description:
  
In previous posts I explained Draggable and Resizable example, split the string, add fade in effect to page, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how implement simple div with fadein fadeout, fadeto effects in JQuery.

To implement fadein fadeout, fadeto effects div in JavaScript we need to write much code but in JQuery we can achieve this functionality just by simple properties fadein, fadeout and fadeto that would be like as shown below

jQuery Enable or Disable Textbox Controls on WebPage in Asp.net

Introduction: 

Here I will explain how to enable or disable textboxes on a page focus using JQuery in asp.net.

Description:
  
In previous articles I explained Enable/Disable all controls on webpage, enable/disable particular controls on page using JQuery in asp.net and another article Enable/disable button using JavaScript and many articles relating to JQuery and JavaScript. Now I will explain how to enable or disable textboxes on a page focus using JQuery in asp.net.

jQuery Change Textbox Background Color on Focus,on Blur using Asp.net

Introduction: 

Here I will explain how to change textbox background color on focus using JQuery in asp.net.

Description:
  
In previous posts I explained change background of controls when validation fails, Change textbox background color in JavaScript, split the string, add fade in effect to page, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how to change textbox background color on focus using JQuery in asp.net.

To implement this functionality in JavaScript we need to write much code for that check this post Change textbox background color in JavaScript but in JQuery we can achieve this functionality just by simple coding that would be like as shown below

Bind Asp.net Gridview with DataReader in C#,VB.NET

Introduction:

 

In this article I will explain how to bind gridview with datareader in asp.net using C#.net and VB.NET. 

Description:

In previous post I explained Convert DataReader to DataTable, Send Gridview as Email body, Check/uncheck checkboxes in gridview using jQuery and many articles relating to asp.net, jQuery, SQL etc. Now I will explain how to bind gridview with datareader in asp.net using C#.net and VB.NET. 

Asp.net- Convert DataReader to DataTable in C#,VB.NET

Introduction:

 

In this article I will explain how to convert datareader to datatable in asp.net using C#.net and VB.NET. 

Description:

In previous post I explained ExecuteReader, ExecuteScalar, ExecuteNonQuery and differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net. Now I will explain how to convert datareader to datatable in asp.net using C#.net, VB.NET. 

DataReader

DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader for that check this post ExecuteReader Example in asp.net.

11 Top jQuery Scroll to Top of Page Plugin Tutorials with Examples

Introduction: 

Here I will explain different type of available JQuery Scroll to Top or Scroll Back to Top or Back to Top plugins.

Description:
  
In previous article I explained 9+ JQuery AutoComplete plugins, 6+ JQuery Password Strength Plugins and JQuery, Ajax, asp.net, SQL Server etc. Now I will explain different type of available JQuery Scroll to Top or Back to Top or Scroll Back to Top plugins. 

jQuery Draggable and Resizable Div Example/Tutorial in Asp.Net

Introduction: 

Here I will explain how to implement JQuery draggable and resizable example in asp.net.

Description:
  
In previous posts I explained JQuery drag and drop div example, Best JQuery AutoComplete plugin examples, add fade in effect to page, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how implement simple div with draggable and resizable options in JQuery.

jQuery Draggable and Droppable Div Example/Tutorial in Asp.Net

Introduction: 

Here I will explain how to implement simple draggable and droppable div example using JQuery in asp.net.

Description:
  
In previous posts I explained split the string, add fade in effect to page, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how implement simple div with draggable and Droppable options in JQuery.

jQuery Drag and Drop DIV Example Code in Asp.NET

Introduction: 

Here I will explain how to implement simple drag and drop div example using JQuery in asp.net.

Description:
  
In previous posts I explained split the string, add fade in effect to page, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how implement simple div with drag and drop options in JQuery.

Asp.net SiteMapPath Navigation Control Example | BreadCrumb Example in Asp.Net

Introduction:

In this article I will explain how to use sitemappath navigation control or create breadcrumb for web application with example in asp.net.

Description:

In previous post I explained how to pass table as parameter to stored procedure, Add Fade in effect to webpage using JQuery and many articles relating to asp.net, JQuery, Ajax etc. Now I will explain how to use sitemap navigation control or how to implement breadcrumb in asp.net.

Sitemap navigation is a control which allows users to know the current page location with respect to home page. To implement this concept

Asp.net- Pass a Table Valued Parameter to Stored Procedure in C# VB.NET Example

Introduction:

In this article I will explain how to pass a table valued parameter to stored procedure in asp.net using C#, VB.NET.

Description:

In previous post I explained Pass table as parameter to stored procedure in SQL Server. Now I will explain how to pass a table valued parameter to stored procedure in asp.net using C#, VB.NET.

SQL Server 2008- Pass Table as Parameter to Stored Procedure Example

Introduction:

In this article I will explain how to pass table as parameter to stored procedure in SQL Server 2008.

Description:

In previous articles I explained Convert Rows to Columns, Query to get data between two dates, Query to get duplicate records count, Query to remove duplicate records and many articles relating to SQL Server. Now I will explain how to pass table as parameter to stored procedure in SQL Server 2008.

Tip to Change Default Search Engine in Internet Explorer 9

Introduction

Here I will explain how to change the default search engine in IE or Internet Explorer 9.

Description:

In Previous article I explained Get New PAN Card if PAN Card lost, Setup DNS Server, how to create desktop shortcut to lock computer just by single click and some other internet tips. Now I will explain how to change the default search engine in IE or Internet Explorer 9.

To change the default search engine in Internet Explorer. we need to follow below steps

9 Top Ajax jQuery AutoComplete Plugins/Tutorials with Examples

Introduction: 

Here I will explain different type of JQuery AutoComplete Plugins  strength meter or indicator plugins.

Description:
  
In previous article I explained 6+ JQuery Password Strength Plugins and JQuery UI autoComplete textbox, Ajax AutoComplete textbox and many articles relating to autoComplete textbox in JQuery, Ajax, asp.net, SQL Server etc. Now I will explain different type of available JQuery/Ajax AutoComplete textbox plugins.

SQL Server- Difference Between Full Outer Join and Cross Join

Introduction:

Here I will explain what is the difference between cross join and full outer join in SQL Server.

Description:

In previous posts I explained difference between Left Join and Left Outer Join, difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between cross join and full outer join in SQL Server.

SQL Server- Difference Between Left Outer Join and Right Outer Join

Introduction:

Here I will explain differences between left outer join and right outer join in SQL Server.

Description:

In previous posts I explained difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between left outer join and right outer join in SQL Server.

SQL Server- Difference Between Left Join and Left Outer Join

Introduction:

Here I will explain the difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the difference between left join and left outer join in SQL Server.

Actually this one is very simple question but many of beginners are asking the same question that’s why I decided to write an article on it. Basically there is no difference between LEFT JOIN and LEFT OUTER JOIN both are same. Whenever we use LEFT JOIN keyword in SQL Server that is the LEFT OUTER JOIN only  

Difference between Left Join,Right Join,Cross Join,Inner Join,Full Outer Join,Self Join in SQL Server

Introduction:

Here I will explain the differences between Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the differences between Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server. To know about the difference between all the joins check this article

Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server

ExecuteReader ExecuteNonQuery ExecuteScalar Examples in Asp.NET when to use what to use in C#.NET,VB.NET

Introduction:

In this article I will explain executereader executenonquery executescalar examples when to use what in asp.net using C#.net and VB.NET.

Description:

If you want to know which command object needs to be used in different situations for that you need to check this article

Differences between ExecuteNonQuery, ExecuteReader and ExecuteScalar in asp.net

If you want to know about each sqlcommand object check below articles