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