How to decrypt password ?

See more:

C#

ASP.NET

Hi All,

I have developed one log in page and registration page, and forget password page. I have given option to "forget password". If i click forget password link button i have given option "Enter Email ID" if that email id is already existing then only password send's to that email id. I am sending details "User name and Password". Password is sending to mail like "System.Byte[]". While i am sending details i need to decrypt the password. How to do that?
Guide me to resolve the issue.

using System;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Net.Mail;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using Chirravuri;
 
namespace HIMS.web
{
  public partial class ForgotPassword : System.Web.UI.Page
  {
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
 
    protected void btnPass_Click(object sender, EventArgs e)
    {
       
//Create Connection String And SQL Statement     
      string ConnectionString = ConfigurationManager.AppSettings["HIMSRMConnectionString"].ToString();
      string strSelect = "SELECT UserName,Password FROM Users WHERE Email = @Email";
      //string strSelect =(@"select Password , convert(varchar(50), DECRYPTBYPASSPHRASE ('12',password )) AS PWD from Users where UserName=@UserName and Password=@Password", ConnectionString);
              
    SqlConnection connection = new SqlConnection(ConnectionString);
    SqlCommand command = new SqlCommand();
    command.Connection = connection;
    command.CommandType = CommandType.Text;
    command.CommandText = strSelect;
 
    SqlParameter email = new SqlParameter("@Email", SqlDbType.VarChar, 50);
    email.Value = txtEmail.Text.Trim().ToString();
    command.Parameters.Add(email);
        
    //Create Dataset to store results and DataAdapter to fill Dataset 
    DataSet dsPwd = new DataSet();
    SqlDataAdapter dAdapter = new SqlDataAdapter(command);
    connection.Open();
    dAdapter.Fill(dsPwd);
    connection.Close();
    if(dsPwd.Tables[0].Rows.Count > 0 )
    {
      MailMessage loginInfo = new MailMessage();
      loginInfo.To.Add(txtEmail.Text.ToString());
      loginInfo.From = new MailAddress("YourID@gmail.com");
      loginInfo.Subject = "Forgot Password Information";
      loginInfo.Body = "Username: " + dsPwd.Tables[0].Rows[0]["UserName"] + "<br /><br />Password: " + dsPwd.Tables[0].Rows[0]["Password"] + "<br /><br />";
      loginInfo.IsBodyHtml = true;
      SmtpClient smtp = new SmtpClient();
      smtp.Host = "smtp.gmail.com"; 
      smtp.Port = 587;
      smtp.EnableSsl = true;
      smtp.Credentials = new System.Net.NetworkCredential("Email@id", "Password");
      smtp.Send(loginInfo);       
      lblMessage.Text = "Password is sent to you Email ID,you can Login Now <a href='Login.aspx'>Login</a>";
        
    }
    else
    {
      lblMessage.Text = "Email Address Not Registered";
    }
     
  }
      
  }
 }

I need to decrypt and send that password to particular email id.