Retrieving user password and email address from database in VB.NET

Here, we will see how to retrieve user password and email address from database in ASP.NET.
  • 3859
 

Here, we will see how to retrieve user password and email address from database in ASP.NET. To perform this task We will create a table and stored procedure in a SQL database.

Step 1:

Create Table 

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

create table tab

(

      userName varchar(20) not null,

      userPassword varchar(20),

      Email varchar(100)

) 

Now enter some values in the table.

insert into tab values('Rohatash','roh','[email protected]');

go

insert into tab values('monu','mohan','[email protected]');

go

insert into tab values('satendra','satya','[email protected]');

Now using select statement.

select * from tab;

OUTPUT

table 1.gif
 

Figure1

Step 2:

Create stored procedure 

Now create a stored procedure for tab table. That means 
user password and email will be retrieve from table using the stored procedure. The stored procedure looks like:

create procedure retriveUserPass

@userName varchar(20)

as

begin

 select userPassword,Email from tab where userName=@userName

end

Step 3: 

Create form in asp. net for retrieve user password and email. The form looks like the following figure.

form 1.gif
 

Figure2

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

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

        Dim con As New SqlConnection(strcon)

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

        com.CommandType = CommandType.StoredProcedure

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

        com.Parameters.Add(p1)

        con.Open()

        Dim dr As SqlDataReader = com.ExecuteReader()

 

        If dr.Read() Then

 

            Label1.Text = "Password is: " & dr(0).ToString()

        Else

            Label1.Text = "User Name does not exist"

        End If

        con.Close()

Now double click on the Get Email button and add following code.          

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

        Dim con As New SqlConnection(strcon)

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

        com.CommandType = CommandType.StoredProcedure

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

        com.Parameters.Add(p1)

        con.Open()

        Dim dr As SqlDataReader = com.ExecuteReader()

        If dr.Read() Then

            Label1.Text = "Password is: " & dr(1).ToString()

        Else

            Label1.Text = "User Name does not exist"

        End If

        con.Close()

 

Step 4:

Now run the application and enter the username which is not defined in table and click on any button.

form2.gif
 

Figure3

Now enter the the username which is entered in the table and click on the Get Password button to get password.

form3.gif
 

Figure4

Now enter the the username which is entered in the table and click on the Get Email button to get email.

form4.gif
 

Figure5
 

You can also download the attachment and test it yourself.

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.