Simple User Login In ASP.NET Using C#

Introduction

In this article we will create a registration form, a login form and a form for checking for existing email. We will create a table and stored procedure in a SQL database.

Registration Form

Step 1 Create Table

Now create a table in a SQL Server database with username, password and email fields. The table looks like this.

create table registrationtab
(
  Username varchar(100), Email varchar(100), Password varchar(20)
)

Step 2 Create stored procedure

Now create a stored procedure for registration. That means the values will be inserted into the table using the stored procedure. The stored procedure looks like:

create procedure[dbo].[storlogin134]
(
  @username varchar(40), @email varchar(50), @password varchar(20)
)
as
insert into registrationtab values(@username, @email, @password)

Step 3 Create form for registration

Now create a form in ASP.Net with the following fields defined in the table. The form looks like the following figure.



Figure1

Now double-click on the register me button and add following code

protected void Buttonregisterme_Click(object sender, EventArgs e) {
    string strcon = "Data Source=.;uid=sa;pwd=Password$2;database=master";
    SqlConnection con = new SqlConnection(strcon);
    SqlCommand com = new SqlCommand("storlogin134", con);
    com.CommandType = CommandType.StoredProcedure;
    SqlParameter p1 = new SqlParameter("username", TextBoxusername.Text);
    SqlParameter p2 = new SqlParameter("email", TextBoxemail.Text);
    SqlParameter p3 = new SqlParameter("password", TextBoxpassword.Text);
    com.Parameters.Add(p1);
    com.Parameters.Add(p2);
    com.Parameters.Add(p3);
    con.Open();
    com.ExecuteNonQuery();
    Labelinfo.Text = "registered successful.";
}

Now run the application and enter the username, email and password and then click on the register me button to save the values to the database.

Figure 2

Open the database and check the registrationtab table.

Login form

Step 4 Create stored procedure

Now create a stored procedure for login. That means the values will be selected from the table using a stored procedure. The stored procedure looks like

create PROCEDURE CheckUser
(
  @username as varchar(50), @password as varchar(50)
)
AS
SELECT * FROM registrationtab WHERE username = @username AND password = @password

Now create a form in ASP.Net with the following fields defined in the table. The form looks like the following figure.



Figure3

Step 5 Create form for login

Now create a form in ASP.Net with the username and password field which are defined in the table. The form looks like the following figure.

Figure 4

Now double-click on the login button and add the following code.

protected void Buttonlogin_Click(object sender, EventArgs e) {
    string strcon = "Data Source=.;uid=sa;pwd=Password$2;database=master";
    SqlConnection con = new SqlConnection(strcon);
    SqlCommand com = new SqlCommand("CheckUser", con);
    com.CommandType = CommandType.StoredProcedure;
    SqlParameter p1 = new SqlParameter("username", TextBoxusername.Text);
    SqlParameter p2 = new SqlParameter("password", TextBoxpassword.Text);
    com.Parameters.Add(p1);
    com.Parameters.Add(p2);
    con.Open();
    SqlDataReader rd = com.ExecuteReader();
    if (rd.HasRows) {
        rd.Read();
        Labelinfo.Text = "Login successful.";
    } else {
        Labelinfo.Text = "Invalid username or password.";
    }
}

Now run the application and enter the username and password and then click on the login button to retrieve the values from the database. Now suppose we enter the wrong username and password, as in,

Figure4

Now enter the correct username and password,

Figure 5

check existence

Step6 Check email Existence

Now create a stored procedure for checking the existence of email. The stored procedure looks like:

create PROCEDURE existance
(
  @email as varchar(50)
)
AS
SELECT * FROM registrationtab WHERE email = @email

Now create a form in ASP.Net with the email field defined in the table. The form looks like the following figure.



Figure 6

Step-7

Now double-click on the login button and add the following code,

protected void Buttonchekexistance_Click(object sender, EventArgs e) {
    string strcon = "Data Source=.;uid=sa;pwd=Password$2;database=master";
    SqlConnection con = new SqlConnection(strcon);
    SqlCommand com = new SqlCommand("existance", con);
    com.CommandType = CommandType.StoredProcedure;
    SqlParameter p1 = new SqlParameter("email", TextBoxemail.Text);
    com.Parameters.Add(p1);
    con.Open();
    SqlDataReader rd = com.ExecuteReader();
    if (rd.HasRows) {
        rd.Read();
        this.Labelinfo.ForeColor = System.Drawing.Color.Red;
        this.Labelinfo.Text = "already Exist!";
    } else {
        this.Labelinfo.Text = "you can login now";
        this.TextBoxusername.Text = "";
        this.TextBoxpassword.Text = "";
        this.TextBoxemail.Text = "";
    }
}

Now run the application and enter the username, email and password to check for the existence of the emailid in the database. Suppose we enter a new email id,

Figure 7

Then click on the Check existence button.

Figure8

Now enter an existing email id and click on the Check existence button.

Figure 9

You can also download the attachment and test it yourself.