Send email when button clicked
no vote
protected void subString()
{
SqlConnection conSplit = new SqlConnection(ConfigurationManager.ConnectionStrings["connMSJ"].ConnectionString);
SqlCommand cmdSplit = new SqlCommand("SELECT Password FROM Member WHERE (Username=@username AND Email=@email)", conSplit);
cmdSplit.Parameters.AddWithValue("@username", txtUsername.Text);
cmdSplit.Parameters.AddWithValue("@email", txtEmail.Text);
conSplit.Open();
SqlDataReader dtrSplit = cmdSplit.ExecuteReader();
if (dtrSplit.Read())
finalString = dtrSplit["Password"].ToString().Substring(0, 5);
dtrSplit.Close();
conSplit.Close();
}
protected void sendResetPass()
{
MailMessage mailMessage = new MailMessage();
mailMessage.To.Add(txtEmail.Text);
mailMessage.From = new MailAddress("admin@MSJ.com");
mailMessag