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','rohatash.mca@gmail.com');
go
insert into tab values('monu','mohan','monu.rathor@gmail.com');
go
insert into tab values('satendra','satya','Satya@gmail.com');
Now using select statement.
select * from tab;
OUTPUT
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.
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.
Figure3
Now enter the the username which is entered in
the table and click on the Get Password button to get password.
Figure4
Now enter the the username which is entered in
the table and click on the Get Email button to get email.
Figure5
You can also download the attachment and test it yourself.