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.