code for simple login with forget password Recovery

hey vivek,
following code snippest is help for u

using System;

using System.Data;

using System.Data.SqlClient;

using System.Net.Mail;

After that write the following code in button click

protected void btnSubmit_Click(object sender, EventArgs e)

{

try

{

DataSet ds = new DataSet();

using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))

{

con.Open();

SqlCommand cmd = new SqlCommand("SELECT UserName,Password FROM UserInfo Where Email= '" + txtEmail.Text.Trim() + "'", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Close();

}

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

{

MailMessage Msg = new MailMessage();

// Sender e-mail address.

Msg.From = new MailAddress(txtEmail.Text);

// Recipient e-mail address.

Msg.To.Add(txtEmail.Text);

Msg.Subject = "Your Password Details";

Msg.Body = "Hi,
Please check your Login Detailss

Your Username: " + ds.Tables[0].Rows[0]["UserName"] + "

Your Password: " + ds.Tables[0].Rows[0]["Password"] +"

";

Msg.IsBodyHtml = true;

// your remote SMTP server IP.

SmtpClient smtp = new SmtpClient();

smtp.Host = "smtp.gmail.com";

smtp.Port = 587;

smtp.Credentials = new System.Net.NetworkCredential ("[email protected]", "yourpassword");

smtp.EnableSsl = true;

smtp.Send(Msg);

//Msg = null;

lbltxt.Text = "Your Password Details Sent to your mail";

// Clear the textbox valuess

txtEmail.Text = "";

}

else

{

lbltxt.Text = "The Email you entered not exists.";

}

catch (Exception ex)

{

Console.WriteLine("{0} Exception caught.", ex);

}