JQuery Scroll to top button,Back to top button option on webpage in asp.net

Introduction:

In this article I will explain how to show Back to Top or Scroll To Top button option in website using JQuery when user scroll down webpage in asp.net.

Description:
  
In previous posts I explained many articles relating to JQuery. Now I will explain how to show Back to Top or Scroll To Top button options in website when users scroll down webpage. In many sites we will see option like Back to Top or Scroll To Top button option when we scroll the webpage down this type of functionality we can implement easily by using JQuery when scrollbar top position greater than certain value. To implement this one write the code as shown below

Change-Reduce size of jquery datepicker in asp.net

Introduction:

In this article I will explain how to reduce or change size of JQuery UI datepicker control or calendar control in asp.net.

Description:
  
In previous post I explained many articles relating to JQuery UI datepicker. During work with JQuery UI Datepicker I face problem to reduce or change the size of datepicker control in asp.net at that time I decided it’s better to write article on this. By default if we use JQuery UI datepicker control it will like this

Regular expression to validate phone number using jquery in asp.net

Introduction: 

Here I will explain how to validate phone number with regular expression using Jquery in asp.net.

Description:
  
In previous articles I explained validate email address using JQuery in asp.net and many articles relating to JQuery. Now I will explain how to use regular expression to validate phone number using JQuery in asp.net.

To implement this one we need to write code as shown below in your aspx page

jQuery Email Address Validation with Regular Expression in Asp.net

Introduction: 

Here I will show how to validate email address using jQuery with regex or regular expression or validate email address in jquery using regular expression or email validation using jQuery in asp.net.

Description:
  
In previous articles I explained how to disable or enable all the controls on page using JQuery and many articles relating to JQuery. Now I will explain how to use regular expression to validate email address using JQuery in asp.net.

To implement this one we need to write code as shown below in your aspx page

Enable-disable selected or particular controls on a page using JQuery in asp.net

Introduction: 

Here I will explain how to enable or disable selected or particular controls on a page using JQuery in asp.net.

Description:
  
In previous articles I explained how to disable or enable all the controls on page using JQuery and many articles relating to JQuery. Now I will explain how to disable or enable only selected or particular controls on webpage using JQuery in asp.net.

To implement this one we need to write code as shown below in your aspx page

JQuery how to disable/enable all the controls on asp.net page

Introduction: 

Here I will explain how to disable or enable all the controls in page using JQuery in asp.net.

Description:
  
In previous articles I explained Bind gridview using JQuery in asp.net  and AutoComplete textbox with JQuery using asp.net and many articles relating to JQuery. Now I will explain how to disable or enable all the controls in webpage using JQuery in asp.net.

To implement this one we need to write code as shown below in your aspx page

Difference between char varchar and nvarchar in sql server

Introduction:

In this article I will explain what is the difference between char, varchar and nvarchar in SQL Server.

Description:

In previous post I explained many articles relating to SQL Server. Now I will explain the differences between char, varchar and nvarchar in SQL Server. Actually one of blog reader has asked me question regarding differences between varchar and nvarchar at that time I decided it’s better to write article on this topic.

Char DataType

Char datatype which is used to store fixed length of characters. Suppose if we declared char(50) it will allocates memory for 50 characters. Once we declare char(50) and insert only 10 characters of word then only 10 characters of memory will be used and other 40 characters of memory will be wasted.

Query to remove first, last character from string in sql server

Introduction:

In this article I will explain how to remove first or last characters from string in SQL server.

Description:

In previous post I explained concatenate row values into string and substring function example to replace particular of string in SQL Server and many articles relating to SQL Server. Now I will explain how to write a query to remove first or last character from string in SQL Server. Here I will explain with one example for that I have one string which contains data like this

SQL Server - Query to Concatenate Row Values in SQL Server

Introduction:

In this article I will explain how to write a query to concatenate row values in SQL server.

Description:

In previous post I explained how to concatenate column values in SQL Server and many articles relating to SQL Server. Now I will explain how to write a query to concatenate row values in SQL Server. Here I will explain with one example for that I have one table UserDetails like as shown below

Query to concatenate two column values in SQL Server

Introduction:

In this article I will explain how to write a query to concatenate two columns of data to single column in datatable using SQL server.

Description:

In previous post I explained how to alter or modify or delete or change already existing 

column in datatable in SQL Server and many articles relating to SQL Server. Now I will explain how to write a query to concatenate two columns of data into single column in SQL Server. Here I will explain with one example for that I have one table UserDetails like as shown below