Advanced Login System


In this article we will show you how to Execute spAuthentication stored procedures for Advanced Login System in MS SQL Server 2012.

Visual Studio 2010/2012/2013/15/17, SQL Server 2005/08/2012

Project used Version

Visual Studio 2013, SQL Server 2012

Executing Stored  Procedures in MS SQL Server 2012

Before going to Executing spAuthentication stored procedure make sure, no data entered in tables. 

To add new entries in Table 

Right Click on Table and select "Edit top 200 rows" as shown below:


Then add new entries as shown below ( For dummy Information)


To Execute stored procedure, right click stored procedure and select "Execute stored procedure" as shown below.


Input Email and Password as shown below. 



In below example, Entered Valid Email Id and Valid Password then returns "Logged Successfully!" and Role as "Admin" and User Name as "UKAcademe".

In below example, Entered Valid Email Id and Invalid Password then returns "Invalid Password, No of attemps 1 out of 3".



Download Complete Source Code C#


Video Tutorial