Show Gridview Header and Footer when there is No Data / Empty in Asp.net

Introduction: 

Here I will explain how to display or show gridview header and footer when the gridview is empty in asp.net using c#, vb.net with example or show gridview header and footer when there is no data or empty in asp.net using c#, vb.net with example. By using gridview properties ShowHeaderWhenEmpty, EmptyDataText we can show gridview header even when data is empty but to show footer we need to write custom code by adding new to gridview in asp.net.

Description:
  
In previous articles I explained populate dropdownlist selected value in gridview in asp.net, group columns in gridview, gridview examples in asp.net, cascading dropdownlist in gridview using asp.net, change gridview header dynamically in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to display or show gridview header and footer when the gridview is empty in asp.net using c#, vb.net.

jQuery Get/Detect Browser Type and Version in Asp.net using jQuery Migrate Plugin

Introduction: 

Here I will explain how to jQuery to get browser type and version or jQuery detect browser version and type in asp.net with example or jQuery find browser type / version with example. By using jQuery migrate plugin we can get browser type and veriosn with example.

Description:
  
In previous articles I explained jQuery load more records on button click in repeater, jQuery show asp.net exception message in ajax calls, jQuery check whether radiobutton selected or not, jQuery get radio button selected value by name, jQuery validate radiobuttonlist with example and many articles relating to css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to use jQuery to get browser version and type in asp.net with example.

jQuery Autocomplete Textbox in Asp.net with Database Example using C#, VB.NET

Introduction: 

Here I will explain how to fill a jQuery autocomplete textbox from database in asp.net using c#, vb.net with example or jQuery autocomplete textbox example in asp.net with database usiing c#, vb.net and show / display no results found message in autocomplete textbox when no matching records found in asp.net using c#, vb.net.

Description:
  
In previous articles I explained jQuery show or hide loading image in asp.net, jQuery autocomplete textbox with multiple words in asp.net, jQuery autocomplete with images in asp.net, jQuery slideup, slidedown, slidetoggle effects example and many articles relating to autocomplete, css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to fill  jQuery autocomplete textbox from database in asp.net with example.

Gridview Make Column (Cell) Not Editable (Read Only) in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to make gridview columns or cells read only or not editable in gridview edititemtemplate in asp.net using c#, vb.net with example. By using readonly property we can set asp.net gridview column as read only or not editable using c#, vb.net with example.

Description:
  
In previous articles I explained set dropdownlist selected value in gridview edititemtemplate in asp.net, populate gridview based on dropdownlist selected value in asp.net, group columns in asp.net gridview, Edit gridview row details in modalpopup and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set or make gridview columns read only or not editable in edititemtemplate in asp.net using c#, vb.net.

Bind (Set) DropDownList Selected Value in GridView EditItemTemplate in ASP.Net

Introduction: 

Here I will explain how to populate or bind dropdownlist selected value in gridview edititemtemplate in asp.net using c#, vb.net with example or set selected value of dropdownlist in gridview from database in asp.net using c#, vb.net with example.

Description:
  
In previous articles I explained group columns in asp.net gridview, asp.net insert update delete operations in gridview, gridview examples in asp.net, insert multiple selected gridview rows into database, paging in asp.net gridview with pageindexchange event, Edit gridview row details in modalpopu and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to populate or bind dropdownlist selected value in gridview edititemtemplate in asp.net using c#, vb.net.

Populate Gridview Based on Dropdownlist Selected Value in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to populate gridview based on dropdownlist selected value in asp.net using c#, vb.net or Bind or filter asp.net gridview based on dropdownlist selection or selected value in asp.net using c#, vb.net.

Description:
  
In previous articles I explained bind dropdownlist in asp.net gridview using dataset, validate textbox controls inside gridview in asp.net, cascading dropdownlist in gridview using asp.net, change gridview header dynamically in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to filter asp.net gridview data with dropdownlist selection in  in asp.net using c#, vb.net.

SQL Server Difference between DML, DDL, DCL and TCL Commands

Introduction:

Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.

Description:

In previous articles I explained find hierarchical data in sql server, cursor example in sql server,  joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, query to remove first and last characters from string in sql server and many articles relating to SQL server. Now I will explain difference between DDL, DML, DCL and TCL statements in sql server.

SQL SERVER DML, DDL, DCL and TCL Commands Examples

Introduction:

Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.

Description:

In previous articles I explained find hierarchical data in sql server, cursor example in sql server,  joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, query to remove first and last characters from string in sql server and many articles relating to SQL server. Now I will explain difference between DDL, DML, DCL and TCL statements in sql server.

SQL Server Add Hours (Minutes) to Current Date using DateAdd Function

Introduction:

Here I will explain how to add hours to current date using DateAdd function in sql server with example or adding hours or minutes to date in sql server. By using DateAdd function in sql server we can add hours or minutes to current date in sql server.

Description:

In previous articles I explained SQL Server get only hours, minutes, date and time from datetime, take database backup in sql server, encrypt and decrypt string in sql server, sql server interview questions for experienced, cursor example in sql server and many articles relating to SQL server. Now I will explain how to add hours or minutes to current date in sql server.

jQuery Set Dropdownlist Selected Value (Text) based on Text / Value

Introduction: 

Here I will explain how to use jQuery to set dropdownlist selected value or text based on value / text or jQuery set dropdownlist value based on value or text with example. By using jQuery map functions we can set dropdownlist selected value based on value or text.

Description:
  
In previous articles I explained jQuery autocomplete textbox with masterpage in asp.net, filter gridview with dropdownlist using filter expression in asp.net, jQuery UI datepicker with master page example, get selected values from dropdownlist in angularjs, jQuery show asp.net exception message in ajax calls and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set dropdownlist selected value or text based on value / text in jQuery.