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