Post
Ask Question

Retrieving User Password and Email Address From Database Using C#

Today, I have provided an article showing you how to retrieve a user's password and email address from a database in ASP.NET. In this article, we will use a TextBox control, two Buttons named Retrievepass and RetrieveEmail and a Label control. When a user enters their username into a TextBox and clicks on the RetrievePass Button, the Label control will display the password according to the username. If a user enters thier username into a TextBox and clicks on the RetrieveEmail Button, the Label control will display the email according to the username. To perform this task we will create a table and stored procedure in a SQL database. All you have to do is implement and hook it up to your website. First, start Visual Studio .NET and make a new ASP.NET web site using Visual Studio 2010.

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 UserDetails

(

      userName varchar(20) not null,

      userPassword varchar(20),

      Email varchar(100)

) 

Now enter some values in the table and use the select command to select the values from the table.

select * from UserDetails;

OUTPUT

img0.jpg

Step 2: Create stored procedure

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

create procedure RetrieveEmailPass

@userName varchar(20)

as

begin

 select userPassword,Email from UserDetails where userName=@userName

end

Now you have to create a web site.

  • Go to Visual Studio 2010
  • New-> Select a website application
  • Click OK

img5.jpg

Now add a new page to the website.

  • Go to the Solution Explorer
  • Right-click on the Project name
  • Select add new item
  • Add new web page and give it a name
  • Click OK

img6.jpg

Design the page and place the required controls in it. Now drag and drop one TextBox, two Buttons and a Label control onto the form. When a user enters the username into a TextBox and clicks on the RetrievePass Button, the Label control will display the password according to the username. After that, a user enters the username into a TextBox and clicks on the RetrieveEmail Button. The Label control will display the email corresponding to the username. Let's take a look at a practical example.

.aspx Code  

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

        &nbsp; UserName

        <asp:TextBox ID="TextBox1" runat="server" Height="28px" Width="185px"></asp:TextBox>

        <asp:Label ID="Label1" runat="server" BackColor="#66FF99" ForeColor="#FF3300" Text="Label"></asp:Label>

        <br />

        <br />

        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="RetrievePass" />

        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

        <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="RetrieveEmail" />

    </div>

    </form>

</body>

</html>

 

In the code-behind write the following code:
 

Code-behind

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

 

public partial class Default2 : System.Web.UI.Page

{

 

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection("Data Source=.;uid=sa;pwd=wintellect;database=rohatash");

        SqlCommand com = new SqlCommand("RetrieveEmailPass", con);

        com.CommandType = CommandType.StoredProcedure;

        SqlParameter p1 = new SqlParameter("@userName", TextBox1.Text);

        com.Parameters.Add(p1);

        con.Open();

        SqlDataReader dr = com.ExecuteReader();

        if (dr.Read())

        {

            Label1.Text = "Password is:  " + dr[0].ToString();

        }

        else

        {

            Label1.Text = "User Name does not exist";

        }

        con.Close();

    }

    protected void Button2_Click(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection("Data Source=.;uid=sa;pwd=wintellect;database=rohatash");

        SqlCommand com = new SqlCommand("RetrieveEmailPass", con);

        com.CommandType = CommandType.StoredProcedure;

        SqlParameter p1 = new SqlParameter("@userName", TextBox1.Text);

        com.Parameters.Add(p1);

        con.Open();

        SqlDataReader dr = com.ExecuteReader();

        if (dr.Read())

        {

            Label1.Text = "Email is:  " + dr[1].ToString();

        }

        else

        {

            Label1.Text = "User Name does not exist";

        }

        con.Close();

    }

}

 

Now run the application and test it.


img1.jpg

 

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


img2.jpg

 

Now enter the the username which is entered in the table and click on the RetrievePassword Button to get the password.


img3.jpg

 

Now enter the username which is in the table and click on the Get RetrieveEmail Button to get the email.


img4.jpg


Similar Articles