In
this article I will explain how to keep or maintain text of password textbox
during postback in asp.net

Description:

In previous posts I explained many articles relating to Asp.net, JQuery, and SQL etc. Now I will explain how to maintain text of
password textbox during postbacks in asp.net. Generally if you observer password
textbox it won’t maintain text if any postback happens like as shown below

If we want to
implement functionality like display files from file directory gridview check
below post here I explained clearly how to save files in folder and how to
display files in gridview from files directory and how to download files from
gridview in asp.net

Here I will explain how to calculate age of person from date of
birth and regular expression for mm/dd/yyyy format using JavaScript.

Description:

In some situation we need to display age of person based on date
of birth .In that situation we can calculate age of person using JavaScript by
comparing present date and date of birth as shown below. Here I have a one
textbox every time I need to validate that data whether user enter valid data
or not if the date not in mm/dd/yyyy format or not.

In this article I will explain how to get or find IP address of client machine
in asp.net using JQuery.

Description:

In previous posts I explained many articles relating toJQuery. Now I will explain how to get client
machine IP address of client machine in asp.net using jquery. To implement this
one write the code as shown below

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

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

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.

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

Here
I will explain how to write a query to delete null or empty values from
datatable in SQL Server.

Description:

In
previous articles I explained many articles relating to SQL
Server. Now I will explain how to write a query to delete null or empty
values from datatable in SQL
Server. For that first design one table (UserInfo) in database and enter data like as shown below

Joining the table itself called self join. Self join is
used to retrieve the records having some relation or similarity with other
records in the same table. Here we need to use aliases for the same table to
set a self join between single table and retrieve records satisfying the
condition in where clause.

In
this article I will explain how to write Query to add new column with default
value to existing datatable in SQL server.

Description:

In
previous post I explained how to alter or add new column in datatable using SQL
Server. Now I will explain how to write query to add new column with
default value to existing datatable in SQL Server. During work with one
application I got requirement like alter existing table structure to add new
column with default value 0(zero). If we want to add new column with some default
value to existing table we need to write the query in a format as shown below

Generally
case statement is conditional statement that will return column value based on
the evaluation of set conditions. We can use CASE in statements such as
SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE,
ORDER BY, and HAVING.