Display animated gif Image before Iframe content is loaded

Description:

In this example we explain that Display animated GIF image before iframe content is loaded .or display gif image before iframe content is not loaded.

Suppose if you are working with iframe then iframe content take time to load, so if you may want to display a simple gif loading image that indicate the end user that loading process is working so wait for some time.

How to delete selected item from dropdown list using JavaScript/jQuery

Description:

 In this example we explain that how to delete selected item from dropdown list using JavaScript/jQuery in asp.net.or how to remove selected item from dropdown list using JavaScript or jQuery in asp.net.

Sometime we have requirement like remove dropdown list items/option when something occur like for example if we select category is equals to vegetable then  only vegetable are shown in other dropdown and other items of dropdown list will be removed.

So below is the example that demonstrates to remove/delete item in dropdown list using client side script like jQuery or JavaScript.

Fetch Next and Previous rows values in SQL Server.

Description:

In this example we explain that how to fetch next and previous rows values in SQL Server.or get the next and previous record from table in sql server.

There are many question arise in mind like is there any ways to access the “previous row” and “next row” value in SELECT statement in SQL Server.sql has no inbuilt facility to access next and previous rows of the table.

Calculate or Find median group by in SQL Server

Description:

In previous example we already explain that how to calculate median in SQL Server. But in this example we explain that function to find median group by in SQL Server. Or calculate median group by in SQL Server. Before we calculate/find median in sql server first we understand what the median is and formula to calculate the median in sql server.

What is Median?

Median means denoting or relating to a value or quality lying at the midpoint of a frequency distribution of observed values or quantities, such that there is an equal probability or falling or below it.

For ex: supposed to find the median of bellows values like

{1,2,3,4,5} then the median is equal 3

{1,2,5,10} then the median is equal 3.5

{1,5,8,7} then median is equal 6

How to Calculate or Find median in SQL Server

Description:

In this example we explain that how to calculate median in SQL Server. Or function to find median in SQL Server. Before we calculate/find median in sql server first we understand the what is the median and formula to calculate the median in sql server.

What is Median?

Median means denoting or relating to a value or quality lying at the midpoint of a frequency distribution of observed values or quantities, such that there is an equal probability or falling or below it.

To calculate or Find median grou by in SQL Server click here Calculate median group by in SQL Server

Populate HTML Table with XML data using JavaScript and jQuery

Description:

In this example we explain that how to populate XML data in HTML Table using javascript in asp.net or Fill HTML Table with XML data using javascript in asp.net.

Here we demonstrate how to bind or populate XML data in HTML Table in client side like using javascript.previously we already explain that how to bind or populate gridview with XML data but here we bind the XML data in normal HTML table using javascript.

Here we first read the XML string from XML document and then bind or populate it with HTML Table using javascript or jQuery.

Below is the example that demonstrate how to populate XML data with HTML Table using javascript.

Execute multiple select query in a single SQL statement using C# in asp.net

Description:

In this example we explain that how to execute multiple select query in a single SQL statement in asp.net using C#. or execute multiple SQL queries in a one  statement using C#.

Sometime we have requirement like bind multiple GridView at a time like bind employee and department grid information in a single SQL statement using C#.

Here we demonstrate how to execute two select query simultaneously in one statement using C#.

SQL Query to get the values of an option set of Dynamic CRM

Description:

In this example we explain that how to get Option set values from SQL Server in an application outside dynamic CRM. Or how to fetch the text value of the option set (Dropdown list) in Dynamic CRM.

There are many question raised when we are new in Dynamic CRM like

Where does Microsoft Dynamic CRM stores Option Set values in SQL Server?

How to retrieve the values of an option set of dynamic CRM?

Microsoft Dynamic CRM store Option Set values in the StringMapBase table. You will query via object code, Attribute Name, Option Set Value, Language Id and then it will returns the attribute value.

How to fetch all product attached in Invoice of the product grid in Dynamic CRM.

Description:
 

In this example we explain that how to fetch all product attached in Invoice of the product grid in Dynamic CRM.

Dynamic CRM to fetch all products items attached with Order/Invoice in grid using SQL Query.

SQL Query to get all product (item) attached in Invoice of the Product Grid in Dynamic CRM.

Many question raised depend of different user like how can I fetch all product items for the particular invoice or order using SQL Query.

Below is the SQL Query that will returns all the product item attached with its related invoice or order.

Difference between Label and Literal control in Asp.Net

Description:

In this example we explain that what is the difference between Label and Literal control in Asp.Net.

Or where and when to use Label control and when to use Literal control in asp.net.

Below is the difference between Label and Literal control in asp.net

Label	Literal
Label control is rendered as HTML tag means Text of the Label is enclosed within HTML <span> tag. When AssociatedControlID is not set for the Label control then it is rendered as the <label> tag.	Literal control is not enclosed within HTML tags
You can easily style within Label control.	Literal control cannot be styled.
Label control is easily used in a JavaScript or jQuery in client side scripting.	Literal control is not accessed by the JavaScript or jQuery.
Used for displaying Text or message.	Generally used for displaying HTML tags.

set Dropdown List Selected Value (Text) based on text /value in asp.net using jQuery

Description:-

In this example we explain that how to set Dropdown List Selected Value (Text) based on text /value in asp.net using jQuery. Or set Dropdown List selected value or text using jQuery. Set dropdown value by text using jQuery. Setting select list ‘selected’ based on text using jQuery. Setting the selected value of a select control via its text description using jQuery.

Sometime we have requirement like when we edit record at that time the DrodownList value will be automatically set based on the value retrieve from the database.

JQuery provide map functions to set the Dropdown List selected value based on text or value.

jQuery AJAX: Async False (Synchronous call) and Async True (Asynchronous call) difference

Description:

In this example we explain that what is the difference between Synchronous and Asynchronous call in AJAX using jQuery.Synchronous call is fired when async is set to false and Asynchronous call is fired when async is set to true.by default async is set to true.

Below is the example that will define the actual difference between synchronous and Asynchronous jQuery AJAX call.

Synchronous call is not recommended by the WC3 because it hangs the web page(form) until the response is not delivered or received from the server.so best way is to always use the Asynchronous jQuery AJAX call.

Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT in SQL Server

	Session	Scope
@@IDENTITY	Same Session	Global scope value
SCOPE_IDENTITY()	Same Session	Local scope value
IDENT_CURRENT()	May be different	Depends on table name passed in parameter

Description:

In this example we explain that how to get last inserted ID of SQL table in SQL Server.

Or how to get last inserted record id in SQL Query.

In this example we explain that difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT.

We used @@IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT properties to get the last inserted id or identity record in sql server table.