ARTICLE

Simple User Login in ASP.NET using VB.NET

Posted by Rohatash Kumar in Articles | ASP.NET using VB.NET on June 09, 2011

Tags: asp.net, asp.net article, asp.net login project, asp.net tutorials, Emilid existence in asp.net, login in asp.net

Here, we will create in this article. 1. Registration Form 2. Login Form 3. Email existence Form

Tweet
2541
1

Download Files:

loginproject.zip

Reader Level: Beginner

Introduction

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

1. Registration Form

Step-1

Create Table

Now creating a table in SQL server database which has the username, password and email fields. Table looks like this.

create table registrationtab

(

Username varchar(100),

Email varchar(100),

Password varchar(20)

)

Step-2

Create stored procedure

Now Creating stored procedure for registration. That means values will be insert in table using stored procedure. Stored procedure looks like that for it.

create procedure [dbo].[storlogin134]

(

@username varchar(40),

@email varchar(50),

@password varchar(20)

)

insert into registrationtab values(@username,@email,@password )

Step-3

Create form for registration

Now creating a form in asp.net with the following field which are defined in the table. The form looks like below figure.

Figure1

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

Protected Sub Buttonregisterme_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Buttonregisterme.Click

Dim strcon As String = "Data Source=.;uid=sa;pwd=Password$2;database=master"

Dim con As New SqlConnection(strcon)

Dim com As New SqlCommand("storlogin134", con)

com.CommandType = CommandType.StoredProcedure

Dim p1 As New SqlParameter("username", TextBoxusername.Text)

Dim p2 As New SqlParameter("email", TextBoxemail.Text)

Dim p3 As 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."

End Sub

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

Figure2

Open the database and check it in registrationtab table.

2. Login form

Step-4

Create stored procedure

Now Creating stored procedure for login. That means values will be match in table using stored procedure. Stored procedure looks like that for it.

create PROCEDURE CheckUser

(

@username as varchar(50),

@password as varchar(50)

)

SELECT * FROM registrationtab WHERE username=@username AND password=@password

Now creating a form in asp.net with the following field which are defined in the table. The form looks like below figure.

Figure3

Step-5

Create form for login

Now creating a form in asp.net with the username and password field which are defined in the table. The form looks like below figure.

Figure4

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

Protected Sub Buttonlogin_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Buttonlogin.Click

Dim strcon As String = "Data Source=.;uid=sa;pwd=Password$2;database=master"

Dim con As New SqlConnection(strcon)

Dim com As New SqlCommand("CheckUser", con)

com.CommandType = CommandType.StoredProcedure

Dim p1 As New SqlParameter("username", TextBoxusername.Text)

Dim p2 As New SqlParameter("password", TextBoxpassword.Text)

com.Parameters.Add(p1)

com.Parameters.Add(p2)

con.Open()

Dim rd As SqlDataReader = com.ExecuteReader()

If rd.HasRows Then

rd.Read()

Labelinfo.Text = "Login successful."

Else

Labelinfo.Text = "Invalid username or password."

End If

End Sub

Now run the application and enter the username and password and then click on the login Button to match the values with database. Suppose we enter wrong username and password.