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.

jQuery Ajax Crop and Upload Image with Preview Example in Asp.Net using C#, VB.NET

Introduction: 
  
Here I will explain how to use jQuery ajax method to crop and upload image with preview / thumbnail in folder in asp.net using jcrop jQuery plugin or jQuery ajax upload and crop image with preview example in asp.net using jQuery jcrop plugin. Jcrop is a powerful image cropping engine for jQuery by using this jcrop plugin we can add cropping functionality easily to your web application.

Description:
  
In previous posts I explained jQuery dropdown with multiple select options, JavaScript send ampersand value in querystring, jQuery Change style of controls, jQuery Add fade in effect to webpage, jQuery show html page content in popup window and many articles relating to JQuery. Now I will explain how to crop image and upload image with thumbnail in asp.net using jcrop jQuery plugin.

jQuery Upload Multiple Files in Asp.net using Handler File in C#, VB.NET

Introduction: 

Here I will explain how to upload multiple files using jQuery in asp.net with generic handler (ashx) in c#, vb.net or jQuery upload multiple files in asp.net using HTML5 “AllowMultiple” property of fileupload in c#, vb.net.

Description:
  
In previous articles I explained jQuery call asp.net page methods from json, 7 + jQuery multiple fileupload plugin examples, jQuery check file size before upload in asp.net, jQuery setInterval() function example, jQuery upload multiple files using uplodify plugin in asp.net and many articles relating to jQuery, JavaScript and asp.net. Now I will explain how to upload multiple files using jQuery with generic handler (ashx) in asp.net using c#, vb.net.

Asp.Net Dynamically Change (Add) Meta Tags or Page Title & Description in C#, VB.NET

Introduction:

Here I will explain how to change or add Meta tags dynamically in asp.net to aspx page in  c#.net, vb.net or dynamically change page title and description in asp.net using c#.net, vb.net or add page title and description dynamically in asp.net using c#.net, vb.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.

jQuery Ajax Image Upload without Refreshing Page or Submitting Form in Asp.net

Introduction: 

Here I will explain how to use jQuery ajax for image upload without refereshing page in asp.net using handler (ashx) in c#, vb.net or jQuery upload images or files without  submitting page or postback in asp.net using handler (ashx) in c#, vb.net or jQuery or asynchronous file upload using jQuery without submitting form in asp.net with c#, vb.net.

Description:
  
In previous articles I explained jQuery call asp.net page methods from json, 7 + jQuery multiple fileupload plugin examples, jQuery check file size before upload in asp.net, jQuery setInterval() function example, jQuery upload multiple files using uplodify plugin in asp.net and many articles relating to jQuery, JavaScript and asp.net. Now I will explain how to upload images or files using jQuery without  page refresh or postback in asp.net using handler (ashx) in c#, vb.net.

To upload images or files using jQuery without  page refresh or postback in asp.net using handler (ashx) first create the new web application and open Default.aspx page and write the following code

jQuery Show (Display) Image Preview before Upload with Demo (Example)

Introduction: 

Here I will explain how to use jQuery to show or display image preview before upload in asp.net with example or demo or jQuery show image preview before upload with fileupload example in asp.net or preview image before upload using fileupload in asp.net.

Description:
  
In previous article I explained jquery crop image in asp.net using jcrop plugin, disable right click on image using JQuery, jquery show html content in popup and many articles relating to jQuery, asp.net. Now I will explain how to use jQuery to preview image before upload in asp.net.

jQuery Crop and Upload Image with Thumbnail in Folder in ASP.Net using C#, VB.NET

Introduction: 
  
Here I will explain how to use jQuery to crop and upload image with thumbnail in folder in asp.net using jcrop jQuery plugin or jQuery image crop and upload to folder with thumbnail in asp.net using jQuery jcrop plugin. Jcrop is a powerful image cropping engine for jQuery by using this jcrop plugin we can add cropping functionality easily to your web application.

Description:
  
In previous posts I explained jQuery dropdown with multiple select options, JavaScript send ampersand value in querystring, jQuery Change style of controls, jQuery Add fade in effect to webpage, jQuery show html page content in popup window and many articles relating to JQuery. Now I will explain how to crop image and upload image with thumbnail in asp.net using jcrop jQuery plugin.

jQuery Count (Get) Number of Rows in Table with Example

Introduction: 

Here I will explain how to get number of rows count in table in jQuery or count number of rows in table in jQuery with example or jQuery get number of table rows length or jQuery get rows length in table 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, 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 to get number of rows count in table with example.

jQuery Load More Data (Records) on Button Click in Asp.Net Repeater from Database in C#, VB.NET

Introduction: 

Here I will explain how use jQuery to load more records or data on button click in asp.net repeater from database using jQuery ajax method in c#, vb.net or jQuery load more data in  asp.net repeater on button click from database without postback in c#, vb.net.

Description:
  
In previous articles I explained Asp.net scrollable repeater with fixed header, jQuery bind data to html table from database using JSON Ajax method, display data in html table from database using asp.net, change gridview header dynamically in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to load more data on button click in asp.net repeater from database using jQuery ajax method in c#, vb.net.