How to get forget password in ASP.NET 3 tier architecture and stored procedure

See more:

ASP.NET4

Hi sir,I have been designing a project int that i have to write code for forget password i wrote some code and i check that code by putting some debug point.while debugging the password from data base is reading into the data access layer but while leaving the loop from data access layer it showing null.I tried but i couldnt get .here i am giving my code which i tried.

in database my code is:

Create procedure sp_ForgetPwd(
@UserName varchar(20),
@SecurityQuetion varchar(Max) ,
@Answer varchar(Max))
as
begin
select Password from tb_Login where UserName=@UserName And SecurityQuetion=@SecurityQuetion and Answer=@Answer
end

in Presentation layer the code is:

protected void Button1_Click(object sender, EventArgs e)
{
string username = TextBox2.Text;
string securityquestion = DropDownList1.SelectedItem.Text;
string ans = TextBox5.Text;
string pwd = "";

Session["pwd"] = pwd;
b.Forgetpwd(username, securityquestion , ans, pwd);

Label1.Text = "Your Password is " + Session["pwd"];
}

in DAta Access layer the code is:


public string Forgetpwd(string username,string securityquestion ,string ans,string pwd)
{
con.Open();
SqlCommand cmd = new SqlCommand("sp_ForgetPwd", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", username);
cmd.Parameters.AddWithValue("@SecurityQuetion", securityquestion );
cmd.Parameters.AddWithValue("@Answer", ans);
try
{

SqlDataAdapter adapter = new SqlDataAdapter(cmd);


DataSet ds = new DataSet();
adapter.Fill(ds);
SqlDataReader dr = cmd.ExecuteReader();


if (ds.Tables[0].Rows.Count>0)

{

pwd = ds.Tables[0].Rows[0]["Password"].ToString();



}
}
catch (Exception ex)
{
pwd = "";
}

return pwd;
}


in Business layer the code is:

public string Forgetpwd(string username,string securityquestion ,string ans,string pwd)
{

return d.Forgetpwd(username, securityquestion , ans,pwd);
}


Please anyone help me to solve this problem.
And Thanks in Advance.

What I have tried:

i Have tried above code and tried with some other way but the problem is still remains.