What is the best way to sending mail from gridview check box checked row

Question

I am using gridview and it contains checkboxes.

when i click submit button, i am sending mail to the customer for every checking record.

if i save record without mail, data will be saving more accurate and fast.

But, when i send mail for every records from the gridview, it's taking long time to process it and done.

I know the reason, it will hit smtp server every records and return back is taking time in the server.

What is the alternative way to sending mail while submit the records...

below is my complete code for reference.

 protected void Submit_Click(object sender, EventArgs e)
        {
            try
            { 		
		System.Threading.Thread.Sleep(3000);
                    //After Setting Page Index Loop through its Rows
                    foreach (GridViewRow gvrow in gbCustomer.Rows)
                    {
                        if (gvrow.RowType == DataControlRowType.DataRow)
                        {
                            var checkbox = gvrow.FindControl("CheckBox1") as CheckBox;
                            if (checkbox.Checked)
                            {
				var Id = (gvrow.FindControl("hdnctrlId") as HiddenField).Value;
                                var CustNo = (gvrow.FindControl("hdnCustNo") as HiddenField).Value;
                                var CustName = (gvrow.FindControl("hdnCustName") as HiddenField).Value;
                                var DOJ = (gvrow.FindControl("hdnDOJ") as HiddenField).Value;
                                //********* Sending Mail
                                SendMail(Id, CustNo, CustName, DOJ);
                                //********* Sending Mail
                             
                                CheckBox chk = (CheckBox)gvrow.FindControl("CheckBox1");
                                chk.Checked = false;
                                CheckBox chkAll = (CheckBox)gbCustomer.HeaderRow.FindControl("chkAll");
                                chkAll.Checked = false;
                            }
                        }
                    }
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Mail Sent successfully.!');window.location.href='NewCustomer.aspx';", true);
	     }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
                ErrorMessage.Visible = true;
            }
            finally
            {
                
            }
        }
  private void SendMail(string Id, string CustNo, string CustName, string DOJ)
        {
            try
            {
                FromEmail = "axl1987@biech.com";
                ToEmail = "bjm21765@biech.com";
                if (!string.IsNullOrEmpty(ToEmail))
                {
                    MailMessage mm = new MailMessage(FromEmail, ToEmail);
                    mm.Subject = "Reg : Customer Request";
                    string strhtml = "";
                    strhtml += "";
                    strhtml += "
";
                    strhtml += "";
                    strhtml += "";
                    strhtml += "";
                    strhtml += "";
                    strhtml += "";
                    strhtml += "";
                    strhtml += "
";
                    strhtml += "Regards,";
                    strhtml += "Alex Paul";
                    strhtml += "";
                    strhtml += "";
                    mm.Body = strhtml;
                    mm.IsBodyHtml = true;
                    SmtpClient smtp = new SmtpClient();
                    smtp.Send(mm);
                }
            }
            catch (Exception ex)
            {
                Response.Write("Error occurred: " + ex.Message);
            }
        }
";
                    strhtml += "Cust. Name ";
                    strhtml += " ";
                    strhtml += "DOJ. ";
                    strhtml += "
";
                    strhtml += " " + CustName + "  ";
                    strhtml += " " + DOJ + "

Accepted Answer

Hi @Gani_tpt,

It depends on network speed + sending server load + receiving server load.

You could try using async.Or you could consider popping up a notification stating that the email has been sent to the user later, rather than forcing them to wait.

The following code example demonstrates sending an email message asynchronously.

https://learn.microsoft.com/en-us/dotnet/api/system.net.mail.smtpclient?view=net-8.0&redirectedfrom=MSDN#examples

protected void SendAsyncEmail(object sender, EventArgs e)
{
    string to = txtTo.Text;
    string from = txtEmail.Text;
    string password = txtPassword.Text;
    string subject = txtSubject.Text;
    string body = txtBody.Text; 
    Thread email = new Thread(delegate()
    {
        SendEmail(to, from, password, subject, body);
    });
 
    email.IsBackground = true;
    email.Start();
    ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Email sent.');", true);
}
 
private void SendEmail(string to, string from, string password, string subject, string body)
{
    using (MailMessage mm = new MailMessage(from, to))
    {
        mm.Subject = subject;
        mm.Body = body;
        mm.IsBodyHtml = false;
        SmtpClient smtp = new SmtpClient();
        smtp.Host = "smtp.gmail.com";
        smtp.EnableSsl = true;
        NetworkCredential NetworkCred = new NetworkCredential(from, password);
        smtp.UseDefaultCredentials = true;
        smtp.Credentials = NetworkCred;
        smtp.Port = 587;
        smtp.Send(mm);
    }
}

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

What is the best way to sending mail from gridview check box checked row

0 additional answers

Your answer