I forget password using email in ado.net

See more:

C#

ADO.NET

email

public ActionResult ForegetPassord(RegisterModel s)

       
            {
        string Email = Request.Form["Email"];
        string Msg = Request.Form["Message"];


        string strConnection = "Data Source=mehaknaz;Initial Catalog=Registration;Integrated Security=True";
                string strSelect = "SELECT Fullname,Password FROM registration WHERE Email = @Email";

                SqlConnection connection = new SqlConnection(strConnection);
                SqlCommand command = new SqlCommand();
                command.Connection = connection;
                command.CommandType = CommandType.Text;
                command.CommandText = strSelect;

                DataSet dsPwd = new DataSet();
                SqlDataAdapter dAdapter = new SqlDataAdapter(command);
                 connection.Open();
                  dAdapter.Fill(dsPwd);
        connection.Close();
        if(dsPwd.Tables[0].Rows.Count > 0 )
        {
                string MailingAddress = ConfigurationManager.AppSettings["MailingAddress"].ToString();
                System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage(MailingAddress, Email);
                SmtpClient client = new SmtpClient();
                message.Subject = "forget";
                message.IsBodyHtml = true;
                message.Body = "FullName: " + dsPwd.Tables[0].Rows[0]["FullName"] + "<br><br>Password: " + dsPwd.Tables[0].Rows[0]["Password"] + "<br><br>";
                client.Host = ConfigurationManager.AppSettings["MailServerName"].ToString();
                client.Port = 587;
                System.Net.NetworkCredential basicCredential = new System.Net.NetworkCredential(
                              MailingAddress
                                , ConfigurationManager.AppSettings["Password"].ToString()
                                );
                client.Credentials = basicCredential;
                client.Send(message);
                Response.Write("<script LANGUAGE='JavaScript'>alert('Email Sent')</script>");

               }
        else
        {
            Response.Write("<script LANGUAGE='JavaScript'>alert('Email Not Register')</script>");
        }
        

            return View(s);
        }

What I have tried:

i Have an errror ..how to resolve..if you have forget passwpord code then provide

Server Error in '/' Application.

Must declare the scalar variable "@Email".

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Email".

Source Error:


Line 113: SqlDataAdapter dAdapter = new SqlDataAdapter(command);
Line 114: connection.Open();
Line 115: dAdapter.Fill(dsPwd);
Line 116: connection.Close();
Line 117: if(dsPwd.Tables[0].Rows.Count > 0 )