How to send email to specified rows from GridView

Question

0.00/5 (No votes)

See more:

I have an imported excelsheet in GridView. Now i've to send an email to all records but in a way like email is to be sent after selecting top 10 records from Grid View and when the process is complete an email is send again to the next 10 records and so on.

Following is my code:

C#

void Send_Mail()
    {
        try
        {
            string Pass, FromEmailid, HostAdd;

            foreach (GridViewRow gr in DataGridView.Rows)
            {
                HostAdd = ConfigurationManager.AppSettings["Host"].ToString();
                FromEmailid = ConfigurationManager.AppSettings["FromMail"].ToString();
                Pass = ConfigurationManager.AppSettings["Password"].ToString();

                Label LblName = gr.FindControl("LblName") as Label;
                Label LblMail = gr.FindControl("LblEmail") as Label;

                string Name = LblName.Text;
                string Mail = LblMail.Text;
                string subject = TxtSubject.Text;

                SmtpClient client = new SmtpClient();
                MailMessage msg = new MailMessage();

                NetworkCredential credentials = new NetworkCredential(FromEmailid, Pass);

                client.Host = HostAdd;
                client.Port = 25;
                client.UseDefaultCredentials = false;
                client.Credentials = credentials;
                client.EnableSsl = true;
                MailAddress from = new MailAddress(FromEmailid);
                msg.IsBodyHtml = true;
                msg.Subject = subject;
                msg.Body = ReadTemplate(Name);
                msg.To.Add(Mail);
                msg.From = from;

                client.Send(msg);
                LblMessage.Text = "Email Send Successfully";
                LblMessage.Visible = true;
            }
        }
    }

Posted 10-Mar-14 20:23pm

Nimit Joshi

Add a Solution

Comments

CodingLover 11-Mar-14 2:38am

That means do you want to send the email only to the selected users?

Nimit Joshi 11-Mar-14 3:15am

No No not to the selected users. I want to send mail to all records. But when i' ll send the mail to 3000 records(which i've) then the process is too slow. So that i want to send the mail 100 by 100

nandakishoreroyal 11-Mar-14 2:38am

What is the using of doing that. You are sending email to all the rows right in anyway.

then why need to sort top 10 like that..

Nimit Joshi 11-Mar-14 3:16am

Actually the records no are 3000. So it is too hectic to send the mail to all records that's why i want to send the mail 100 by 100

Aravindba 11-Mar-14 2:56am

u need to send top 10 records form gridview row selected,then again send next top 10 records and so on...

OR

u have a email address in a gridview,and if select rows form gridview and get email address form selected row and send mail

Nimit Joshi 11-Mar-14 3:17am

would you please code it?

Rahul VB 11-Mar-14 3:32am

Firstly,
You want to send mails to a chunk of 10 people at a time, to improve performance, because while sending emails to many people at a time makes the entire application slow?

Secondly,
Have you tried using RowDataBound event. The moment that row is rendered, you pick the record and then send an email to the client.

Thirdly,
The problem why your application is getting slow is that you might be making to many manuplations at post back. Try using AJAX to perform those operations which are not so important.

I think this should help.

Nimit Joshi 11-Mar-14 3:35am

Yes you are right at you first statement. No I did not used RowDataBound event. Would you please code it??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravindba · Accepted Answer · 2014-03-10T21:29:00

Hi Try this

In below gridview u need to add checkbox,then only u use gridview.selecteitems

C#

foreach (GridDataItem gdi in usersGridView.SelectedItems) {


  HostAdd = ConfigurationManager.AppSettings["Host"].ToString();
                FromEmailid = ConfigurationManager.AppSettings["FromMail"].ToString();
                Pass = ConfigurationManager.AppSettings["Password"].ToString();
 
                Label LblName = gr.FindControl("LblName") as Label;
                Label LblMail = gr.FindControl("LblEmail") as Label;
 
                string Name = LblName.Text;
                string Mail = LblMail.Text;
                string subject = TxtSubject.Text;
 
                SmtpClient client = new SmtpClient();
                MailMessage msg = new MailMessage();
 
                NetworkCredential credentials = new NetworkCredential(FromEmailid, Pass);
 
                client.Host = HostAdd;
                client.Port = 25;
                client.UseDefaultCredentials = false;
                client.Credentials = credentials;
                client.EnableSsl = true;
                MailAddress from = new MailAddress(FromEmailid);
                msg.IsBodyHtml = true;
                msg.Subject = subject;
                msg.Body = ReadTemplate(Name);
                msg.To.Add(Mail);
                msg.From = from;
 
                client.Send(msg);
                LblMessage.Text = "Email Send Successfully";
                LblMessage.Visible = true;

//Here delete the data form gridview ,use where condition as LblMail,so it remove row form gridview which are send mail already 
  
}