Retrieving User Password and Email Address From Database Using C#

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

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

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

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  

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();

    }

}