SQL Server Retrieve Data from Multiple Tables using Joins

Introduction:

In this article I will explain how to retrieve data from multiple tables in sql server.

Description:

In previous post I explained Difference b/w functions and stored procedures, Pass table as parameter in SQL Server 2008, differences between char, varchar and nvarchar, difference between tinyint,smallint,int,bigint and many articles relating to SQL Server. Now I will explain how to retrieve data from multiple tables in SQL Server.

Asp.net Difference between DataReader and DataSet and DataAdapter in C#, VB.NET

Introduction:

In this article I will explain difference between datareader, dataset and dataadapter in asp.net.

Description:

In previous posts I explained Interview Questions in asp.net,C#,SQL, difference between Executereader, ExecuteNonQuery and ExecuteScalar, difference between Len and DataLength functions, difference between int,tinyint and bigint and differences between char, varchar and nvarchar in SQL Server. Now I will explain difference between datareader, dataset and dataadapter in asp.net

Dynamically Add Meta tags to Aspx Page in Asp.net using C#, VB.NET

Introduction:

In this article I will explain how to add Meta tags dynamically to aspx page in asp.net.

Description:

In Previous posts I explained Differences between appsettings and connection strings, jQuery get hidden field values from asp.net gridview and many articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain how to add Meta tags dynamically to aspx pages in asp.net.

Asp.net Difference between appSettings and Connection Strings in web.config

Introduction:

In this article I will explain the differences between appsettings and connection strings in web.config using asp.net.

Description:

In previous posts I explained Read or Write appsettings from web.config, Read/Write connection strings in web.config. Now I will explain differences between appsettings and connection strings in web.config using asp.net.

In many cases, we need to use some data string throughout the application simple example for this database connection string. Instead of writing the same connection string wherever required, it is easy to maintain if we store it in one place that is web.config file.

Show tooltip in Asp.net Dropdownlist items Mouseover Event in C#, VB.NET

Introduction: 

Here I will explain how to show tooltip in dropdownlist items on mouseover event in asp.net using C# and VB.NET.

Description:
  
In previous posts I explained Bind data to Dropdownlist from database, Bind Images to dropdownlist, Cascading dropdownlist example and many articles relating to dropdownlist, JQuery, asp.net etc. Now I will explain how to show tooltip in dropdownlist items on mouseover event in asp.net.

Show Bind Data to Asp.net Dropdownlist from Database in C#, VB.NET

Introduction:

Here I will explain how to bind or show data in dropdownlist from database in asp.net using C#.net and VB.NET.

Description:

In previous posts I explained many articles relating asp.net, jQuery, SQL Server, JavaScript. Now I will explain how to bind or show data in dropdownlist from database in asp.net using C#.net and VB.NET.

Get Hidden Field Values from Asp.net Gridview in jQuery

Introduction: 

Here I will explain how to get gridview hidden field value using JQuery in asp.net.

Description:
  
In previous posts I explained Bind Gridview with datareader, send gridview as mail body, Highlight gridview row when checkbox selected  and many articles relating to Gridview, JQuery, etc. Now I will explain how to get gridview hidden field values using JQuery in asp.net.

jQuery Remove All whitespaces from string with Regular Expression

Introduction: 

Here I will explain how to remove or delete all white spaces from string using JQuery in asp.net.

Description:
  
In previous articles I explained jQuery Remove first/last character from string, jQuery Drag and Drop Example and many articles relating to JQuery. Now I will explain how to remove or delete white spaces from string using JQuery in asp.net.

To remove or delete white spaces from string we can use default jQuery function trim() but it will remove only starting and ending spaces but spaces within string will be same because of that we need to use regular expression to remove white spaces from string for that we need to write codesnippet like as shown below

jQuery Remove Spaces from String with Regular Expression

Introduction: 

Here I will explain how to remove or delete spaces from string using JQuery in asp.net.

Description:
  
In previous articles I explained jQuery Remove first/last character from string, Best Drag and Drop Plugin examples, Scroll back to top plugin Examples, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how to remove or delete spaces from string using JQuery in asp.net.

jQuery Remove First/Last Character From String in Asp.net

Introduction: 

Here I will explain how to trim or remove first/last characters from string using JQuery in asp.net.

Description:
  
In previous posts I explained jQuery Add/Remove CSS Class, jQuery slideUp, slideDown and slideToggle Example, Draggable and Resizable example, add fade in effect to page, Password strength jquery plugin examples and many articles relating to JQuery. Now I will explain how to trim or remove first or last characters from string using JQuery in asp.net.

To remove or trim first/last characters we need to write the codesnippet like as shown below