jquery expand textbox on focus using asp.net

Introduction: 

Here I will explain how to expand or increase textbox size on focus using JQuery in asp.net.

Description:
  
In previous article I explained disable right click on image using JQuery and many articles relating to JQuery. Now I will explain how to expand or increase textbox size on focus using JQuery in asp.net.

Disable right click on images using jquery in asp.net

Introduction: 

Here I will explain how to disable right click on right click only on images using JQuery in asp.net.

Description:
  
In previous article I explained disable right click web page using JQuery. Now I will explain how to disable right click only on images using JQuery in asp.net.

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

JQuery disable right click on web page using asp.net

Introduction: 

Here I will explain how to disable right click on webpage using JQuery in asp.net.

Description:
  
In previous article I explained how to disable right click on webpage using JavaScript. Now I will explain how to disable right click on webpage using JQuery in asp.net.

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

SQL Server - Query to Get Data between Two Dates in SQL Server

Introduction:

Here I will explain how to write a SQL query to get data between two dates 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 get data between two dates in SQL Server. In database I have one table UserInformation that contain data like as shown below

Asp.net-cannot open database requested by the login. the login failed. login failed for user 'iis apppool\DefaultAppPool'

Introduction:

In this article I will explain how to solve cannot open database requested by the login. The login failed. Login failed for user 'iis apppool\DefaultAppPool' problem in IIS7. 

Description:

In previous posts I explained many articles to solve Run time errors in asp.net. In IIS7 I published one website and started running my deployed application at that time I got some error message like cannot open database requested by the login. The login failed. Login failed for user 'iis apppool\DefaultAppPool'. To solve this problem I did some modifications in IIS for that check below post to make required modifications in iis

Asp.net-Unable to start debugging on the web server. IIS does not list a web site that matches the launched URL

Introduction: 

Here I will explain how to solve the problem “Unable to start debugging on the web server. IIS does not list a web site that matches the launched URL.” When running web application using visual studio in asp.net.

Description

In previous posts I explained many articles to solve errors in asp.net. Now I will explain how to solve the problem of “Unable to start debugging on the web server. IIS does not list a web site that matches the launched URL”. During work with one application error like as mentioned above. We can solve this problem in different methods.

use top clause with update delete statements in SQL Server

Introduction:

Here I will explain how to use top clause or keyword with update and delete statements in SQL Server.

Description:

In previous post I explained use top clause with insert statement in SQL Server and many more articles relating to SQL Server. Now I will explain how to use top clause with update and delete statements in SQL Server.

Before write query to use top keyword or clause with update and delete statements we need to design table UserInformation in database like as shown below

SQL Server - Query to use Top Keyword Clause with Insert Statement in SQL Server

Introduction:

Here I will explain how to write SQL query to use top keyword or clause with with insert statement in SQL Server.

Description:

In previous post I explained use distinct keyword with top statement, Replace function example and Substring function example in SQL Server and many more articles relating to SQL Server. Now I will explain how to use top clause or keyword with insert statement in SQL Server.

Difference between bit tinyint smallint int and bigint datatypes in SQL Server

Introduction:

In this article I will explain what is the difference between bit, tinyint, smallint, int and bigint datatypes in SQL Server.

Description:

In previous post I explained Differences between char, varchar and nvarchar in SQL Server and many articles relating to SQL Server. Now in this article I will explain what is the difference between bit, tinyint, smallint, int and bigint datatypes in SQL Server.

how to return value from stored procedure in sql server

Introduction:

In this article I will explain how to create a stored procedure to return value in SQL server.

Description:

In previous post I explained Create stored procedure to return multiple values in SQL Server and many articles relating to SQL Server. Now I will explain how to create a stored procedure to return value in SQL Server. If you want to know how stored procedure return value in sql server check below post in that post explained clearly how stored procedure will return single or multiple values in SQL Server.

how to return multiple values from stored procedure in sql server

Introduction:

In this article I will explain how to create a stored procedure to return value or multiple values in SQL server.

Description:

In previous post I explained how to write stored procedure to return output parameter values in sql server and many articles relating to SQL Server. Now I will explain how to create a stored procedure to return values in SQL Server. To implement this concept first design table in database and give name as UserDetails as shown below

Asp.net Dynamic button click event in c# vb.net

Introduction:

In this article I will explain how to implement dynamic button click events in asp.net using c# or vb.net.

Description:

In previous posts I explained how to create controls dynamically in asp.net and save dynamic control values in database and many articles relating to Asp.net, JQuery, and SQL etc. Now I will explain how to handle dynamic button click events in asp.net using c# or vb.net for that first we need to write the following code in your aspx page

Asp.net save dynamically created control values in database

Introduction:

In this article I will explain how to save dynamically created control values in database using asp.net.

Description:

In previous posts I explained how to create controls dynamically in asp.net and get dynamically created control values in asp.net. Now I will explain how to save dynamically created controls values in database using asp.net. To implement this concept first design table in database and give name as UserDetails as shown below

How to get dynamically created textbox value in asp.net

Introduction: 

In this article I will explain how to get dynamically created textbox value in asp.net.

Description:

In previous post I explained dynamically create controls and handle event clicks in asp.net  . Now I will explain how to get dynamically created textbox values in asp.net.

If we want to get dynamically created textbox values we need to write code like as shown below

Dynamically create controls in asp.net handle button click events

Introduction:

In this article I will explain how to create dynamic controls like button, linkbutton and other controls and how to handle button click events in asp.net.

Description:

In previous posts I explained how to create controls dynamically in asp.net and many articles relating to Asp.net, JQuery, and SQL etc. Now I will explain how to handle dynamically created controls click events in asp.net for that first we need to write the following code in your aspx page

Asp.net get twitter logged in user details username, profile image, twitter followers

Introduction: 

In this article I will explain how to get Username, twitter followers, recent tweets, number of tweets and profile image of twitter logged in user using asp.net.

Description:

In previous post I explained how to use twitter api login authentication to website in asp.net. Now I will explain how to get twitter logged in userdetails like username, profile image, twitter followers and recent tweets etc using asp.net.

keep-maintain password textbox value during postback asp.net

Introduction:

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

Asp.net display files in gridview from file-server directory

Introduction: 

In this article I will explain how to show or display files from file directory in gridview using asp.net.

Description:

In previous post I explained how to save or upload files to server in asp.net and Download files folder in asp.net. Now I will explain how to display files from file directory in gridview using asp.net.

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

Download files from gridview with linkbutton click in asp.net

Introduction: 

In this article I will explain how to download files from server whenever we click on linkbutton in gridview in asp.net.

Description:

In previous post I explained how to save or upload files to server in asp.net and Download files folder in asp.net. Now I will explain how to download files from server with gridview linkbutton click in asp.net.

If we want to implement functionality like download files from gridview when we click linkbutton for that check below post

Regular expression to validate date in mm/dd/yyyy format in JavaScript

Introduction:

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.

Regular expression for mm/dd/yyyy date format is

re=/^(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d+$/;

If you want to implement code for calculate age of person using javascript design your aspx page like this

how to find ip address in asp.net behind proxy in c# vb.net

Introduction: 

In this article I will explain how to find system or client machine IP address from which user visited the website in asp.net behind proxy in c# and vb.net.

Description:
  
In previous posts I explained JavaScript Get User IP Address, City, Latitude, Longitude, how to find client machine IP using jquery in asp.nt relating to JQuery. Now I will explain how to get system or client IP address of machine from which the user visited the website in asp.net in c# and vb.net. To implement this one write the code as shown below

how to get-find ip address of client machine in asp.net using jquery

Introduction: 

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 to JQuery. 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

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

how to bind dropdownlist in asp.net using jquery or JSON

Introduction: 

Here I will explain how to bind dropdownlist using JQuery ajax or JSON in asp.net.

Description:
  
In previous articles I explained Bind gridview using JQuery in asp.net  and AutoComplete textbox with JQuery using asp.net. Now I will explain how to bind dropdownlist using JQuery or JSON in asp.net.

To implement this concept first design table in database and give name as Country as shown below

How to send or pass multiple parameters in jquery ajax in asp.net

Introduction:

Here I will explain how to send or pass multiple parameters using JQuery or JSON in asp.net.

Description:

In previous posts I explained articles relating JSON in that I explained how to call page methods using JSON or JQuery in asp.net or Auto complete textbox with JQuery/JSON in asp.net. Now I will explain how to pass or send multiple parameters using JQuery or JSON in asp.net.

If we want to send or pass multiple parameters using JSON or JQuery in asp.net we need to declare it like as shown below

how to check dataset is null or empty in asp.net | Check dataset contains a data or not

Introduction:

Here I will explain how to check a dataset contains data or dataset is null or empty in asp.net.

Description:

In previous posts I explained many articles relating code snippets in asp.net. Now I will explain how to check if dataset contains any data or dataset is null or empty in asp.net.

If we want to check dataset contains data or not for that we need to write code as shown below

How to send mail with multiple attachments in asp.net

Introduction: 

In this article I will explain how to send mail with multiple attachments in asp.net.

Description:

In previous post I explained how to send mail with attachment in asp.net. Now I will explain how to send mail with multiple attachments in asp.net. During work with one of the application I got requirement like send mail with multiple attachments in asp.net actually we can implement this concept very easily just by adding few lines of code to how to send mail with attachment in asp.net.

Query to return default value if column contains null value in SQL Server

Introduction:

Here I will explain how to write a query to return default value if column contains null value in SQL Server.

Description:

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

Get output parameter from stored procedure in asp.net

Introduction: 

In this article I will explain how to get output parameters returns by stored procedure in asp.net.

Description:

In previous posts I explained many articles relating asp.net, gridview, JQuery, SQL Server etc. Now I will explain how to get output parameters return by stored procedure in asp.net. First we will see how to write a stored procedure to return output parameters for that check this post write stored procedure to return output parameters in SQL Server. Once stored procedure designed in database write the following code in code behind to get output parameters returns by stored procedure in asp.net.

Query to delete null or empty values from datatable in sql server

Introduction:

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

Query to convert lowercase to uppercase characters in SQL Server

Introduction:

In this article I will explain how to write a query to convert or change lowercase to uppercase or uppercase to lowercase characters in 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 convert or change lowercase to uppercase or lowercase to uppercase characters in SQL Server. Here I will explain with one example for that I have one table UserDetails like as shown below

Query to change the datatype of column in sql server

Introduction:

In this article I will explain how to change or rename datatype of column in 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 rename or change datatype of column name or table name in SQL Server.

Syntax to modify existing column datatype in table

If we want to modify existing column datatype from data table that syntax will be like this

Add datatable data with comma separated values in string

Introduction:

Here I will explain how to add or bind datatable column data with comma separated values in asp.net.

Description:

In previous article I explained about self join in SQL server, Joins in SQL Server and many more articles relating to SQL Server. Now I will explain how to add datatable data with comma separated values in asp.net.

self join query in sql server | self join example in sql server

Introduction:

Here I will explain how to write self join query in SQL server and self join example in SQL server.

Description:

In previous article I explained about Joins in SQL Server and many more articles relating to SQL Server. Now I will explain about self join in SQL Server.

Self Join

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.