In my one post I explained you how to Send Grdiview Data in Email. Here I am going to show you how to send DataGridview content in E-mail in window application.
You can also find my other articles related to C#, ASP.Net, jQuery, Java Script and SQL Server.
First take a look on the below image.
In the above image, we have a DataGridView with some data and a button with text "Send Mail". Our requirement is that we have to send the data of DataGridView in mail in tabular form.
For sending the DataGridView content in mail we have to write the following code on Click Event of button.
C# Code
Output MailYou can also find my other articles related to C#, ASP.Net, jQuery, Java Script and SQL Server.
First take a look on the below image.
For sending the DataGridView content in mail we have to write the following code on Click Event of button.
C# Code
private void button1_Click(object sender, EventArgs e) { try { //Create instance of MailMessage Class MailMessage mail = new MailMessage(); //Assign From mail address mail.From = new MailAddress("frommail@gmail.com"); //Set To mail address mail.To.Add(new MailAddress("tomaiil@gmail.com")); //Set Subject of mail mail.Subject = "Send DataGridView Data in Mail"; //Create Mail Body mail.Body = "Please check the following data "; mail.Body += GetTableFromDataGrid(); //for sending body as HTML mail.IsBodyHtml = true; //Create Instance of SMTP Class SmtpClient SmtpServer = new SmtpClient(); //Assign Host SmtpServer.Host = "smtp.gmail.com"; //Assign Post Number SmtpServer.Port = 587; //Setting the credential for authentiicate the sender SmtpServer.Credentials = new System.Net.NetworkCredential("mymail@gmail.com", "password"); //Enable teh Secure Soket Layer to Encrypte the connection SmtpServer.EnableSsl = true; //Sending the message SmtpServer.Send(mail); MessageBox.Show("Mail Sends Successfully!!"); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }In the above code, I have called a function named GetTableFromDataGrid(), which is as follows-
public string GetTableFromDataGrid() { StringBuilder strTable = new StringBuilder(); try { strTable.Append("<table border='1' cellpadding='0' cellspacing='0'>"); strTable.Append("<tr>"); //Create Header Row for Table foreach (DataGridViewColumn col in dataGridView1.Columns) { strTable.AppendFormat("<th>{0}</th>", col.HeaderText); } strTable.Append("</tr>"); //Create Table Rows for (int i = 0; i < dataGridView1.Rows.Count; i++) { strTable.Append("<tr>"); foreach (DataGridViewCell cell in dataGridView1.Rows[i].Cells) { if (cell.Value != null) { strTable.AppendFormat("<td>{0}</td>", cell.Value.ToString()); } } strTable.Append("</tr>"); } strTable.Append("</table>"); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } return strTable.ToString(); }
I hope this article will be helpful for you. I would like to have any feedback from you. Your valuable feedback, question, or comments about this article are always welcome.
No comments:
Post a Comment