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.

Set Dropdownlist Selected Value (Text) in Asp.net on Page Load / Code Behind

Introduction: 

Here I will explain how to set dropdownlist selected value on page load or code behind in asp.net using c#, vb.net or set dropdownlist selected item by value or text in asp.net using c#, vb.net. In dropdownlist we can set selected item by value or text using FindByValue and FindByText properties in asp.net using c#, vb.net.

Description:
  
In previous articles I explained dropdown validation using javascript in html, populate dropdownlist from database in asp.net, cascading dropdownlist in asp.net gridview, country, city, state cascading dropdownlist in asp.net and many articles relating to dropdownlist, gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set dropdownlist selected value in asp.net using c#, vb.net.

Set Default Value in Dropdownlist in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to set default value in dropdownlist in asp.net using c#, vb.net or setting default value for dropdownlist in asp.net using c#, vb.net. In dropdownlist we can set default value by using selectedindex and selectedvalue properties in asp.net using c#, vb.net.

Description:
  
In previous articles I explained populate dropdownlist from database in asp.net, filter gridview with dropdownlist using filter expression in asp.net, get selected values from dropdownlist in angularjs, jQuery show asp.net exception message in ajax calls, cascading dropdownlist in gridview using asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set default value in dropdownlist in asp.net using c#, vb.net.

SQL Server Get Only Hours, Minutes, Date, Time from DateTime Field

Introduction:

Here I will explain how to get only hours and minutes from datetime in sql server or extract / get only time from datetime field in sql server or get hours datetime in sql server  or get only minutes from sql server or query to get only date / time / hours / minutes from sql server.

Description:

In previous articles I explained 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, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to get only date / time / hours / minutes from datetime field in sql server.

jQuery Autocomplete Textbox Example in Master Page using Web Service in Asp.net using C#, VB.net

Introduction: 

Here I will explain how to populate jQuery autocomplete textbox in master page using web service example in asp.net using c#, vb.net or bind or fill a jQuery autocomplete textbox example with master page using web service in asp.net using c#, vb.net or jQuery autocomplete textbox with content page and master page example in asp.net using c#, vb.net.

Description:
  
In previous articles I explained jQuery google currency conversion as per exchange rates example, jQuery countdown timer example, jQuery increase or decrease font size of website, jQuery autocomplete textbox with multiple words in asp.net, jQuery autocomplete with images in asp.net and many articles relating to autocomplete, css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to implement jQuery autocomplete textbox in master page using web service example in asp.net using c#, vb.net with example.

jQuery Autocomplete Clear Textbox if No Match Found in Asp.Net

Introduction: 

Here I will explain how to use jQuery to clear autocomplete textbox if no records match found in asp.net using c#, vb.net or jQuery autocomplete clear textbox if no records match found while searching 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 clear in jQuery autocomplete textbox in asp.net with example.

jQuery Display No Results (Match) Found Message in AutoComplete in Asp.Net

Introduction: 

Here I will explain how to use jQuery to show or display no results found message in autocomplete textbox when no matching records found in asp.net using c#, vb.net or jQuery autocomplete textbox display no records found message when no matching results 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 display no records found message in autocomplete textbox when no matching records found in jQuery using asp.net with example.

Find hierarchical data in SQL server (Recursion)

Introduction:

Here I will show you how to find the hierarchical data of a sql server, like we did in Team management process. In a team process we have different users having their own parent. So if we want to go from level 1 to level n then what should we have to do? Lets come and check how to traverse all the users at all level from top to bottom and bottom to top.

Description:

Previously we have discussed about Generate Genealogy view in ASP.NET C# using Google Organizational Chart, here we have discussed about the hierarchical data. In this post we have just shown the data, but here we will use recursion to get the data. Let’s see how to do?

jQuery UI Datepicker Change Date Format yyyy-mm-dd, dd/mm/yy, mm/dd/yy

Introduction: 

Here I will explain how to set or change jQuery UI datepicker or calendar change date format like yyyy-mm-dd, dd/mm/yy, mm/dd/yy, 'd M,y', etc... .

Description:
  
In previous posts I explained many articles relating to jQuery Datepicker in asp.net. Now I will explain how to change date format in jQuery calendar control like dd/mm/yy or mm/dd/yy or etc based on our requirement.

jQuery UI Datepicker(Calendar) with Master (Content) Page Example in Asp.net

Introduction: 

Here I will explain jQuery ui datepicker or calendar control with master page along with content page example or how to make jQuery ui datepicker work with master page with example in asp.net. To display calendar control in content page with master page we need to add script files in master page instead of child page in asp.net.

Description:
  
In previous articles I explained jQuery ui datepicker example, jQuery change datepicker / calendar control format, jQuery show multiple months in datepicker / calendar, jQuery slideup, slidedown, slidetoggle effects example, jQuery add border to images using css classes and many articles relating to css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to use jQuery ui datepicker with master page in asp.net with example.

Add Meta tags to Asp.Net Master Page and ASPX Child Content Pages

Introduction: 

Here I will explain how to add meta tags in master and child pages in asp.net using c#, vb.net or add meta tags like page title, description, keywords dynamically in asp.net using c#, vb.net or dynamically change page title and description in master page and child content page in asp.net using c#, vb.net.

Description:
  
In previous articles I explained jQuery crop and upload image with preview in asp.net, jQuery upload multiple files in asp.net using handler, jQuery load more data in repeater on button click in asp.net, jQuery show asp.net exception message in ajax calls, cascading dropdownlist in gridview using asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to add metags in master page and child pages in asp.net using c#, vb.net.