Articles → ASP .NET GRIDVIEW → Send gridview data on email in asp.net

Send gridview data on email in asp.net

In this article I will explain how to send grid view data on email in asp.net. This topic contains following sections

      1. Software requirement

      2. Prerequisite knowledge

      3. Steps of execution

      4. Create a new table

      5. Add data in the table

      6. Create a new project

      7. Add controls on the page

      8. Add code to bind grid

      9. Add code to send grid view on email

      10. Code explanation

      11. Output

Software requirement

Before you start reading this tutorial you should make sure that

1. Visual studio 2005(or above) is installed on your machine.

2. SQL Server 2005(or above) is installed on your machine

Prerequisite knowledge

Before you go ahead, it is required that you should know

      1. Basics about SQL objects like tables.

      2. How to create tables in SQL server and how to insert data into the table?

      3. How to create a project using visual studio?

      4. Basic knowledge about basic controls like button textbox etc and their events

      5. Basic knowledge about data controls like grid view.

      6. How to bind data in grid view?

      7. How to send email using asp.net?

Steps of execution

In this tutorial I will execute certain steps for the demonstration of sending grid view data on email in asp.net. These steps are

      1. Create a new table

      2. Add data in the table

      3. Create a new project

      4. Add controls on the page

      5. Add code to bind grid

      6. Add code to send grid view on email

Let us execute each step

Create a new table

First of all create a new table. See the screen shot below for table schema

Click to Enlarge

Add data in the table

Add data in the table. See the screen shot below for data

Click to Enlarge

Create a new project

Create a new website (or web based application) using visual studio. See the screen shot below for project structure.

Click to Enlarge

Add controls on the page

Add 2 buttons and a grid view on the page. See the code section below

<asp:GridView ID="gvReport" runat="server"  AutoGenerateColumns="false">
    <HeaderStyle Font-Names="Verdana" Font-Size="Small" BackColor="#90546f" ForeColor="White" BorderStyle="Solid" BorderColor="Black" />
    <RowStyle Font-Names="Verdana" Font-Size="Small"/>
        <Columns>
            <asp:TemplateField HeaderText="Course Name">
                <ItemTemplate>
                    <asp:Label runat="server" Text='<%#Eval("course_name") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Course Code">
                <ItemTemplate>
                    <asp:Label runat="server" Text='<%#Eval("course_code") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Due Date">
                <ItemTemplate>
                    <asp:Label runat="server" Text='<%#Eval("due_date") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <asp:Button ID="btnGetData" runat="server" Text="Get Data" OnClick="btnGetData_Click" />
     
    <asp:Button ID="btnSendOnEmail" runat="server" Text="Send on email" OnClick="btnSendOnEmail_Click" />

      1. Gridview (gvReport) will display data fetch from database.

      2. Button (btnGetData) – Get data from database and bind gridview(gvReport)

      3. Button (btnSendOnEmail) – Email gridview’s data.

Add code to bind grid

Add the following code on click of btnGetData.

protected void btnGetData_Click(object sender, EventArgs e)
{
  DataSet oDataSet = new DataSet();
  using (SqlConnection oConnection = new SqlConnection("connection_string"))
  {
      // Open a connection
      oConnection.Open();
      using (SqlDataAdapter adapter = new SqlDataAdapter("select * from Course", oConnection))
      {

                adapter.Fill(oDataSet);
      }
  }

  gvReport.DataSource = oDataSet.Tables[0];
  gvReport.DataBind();        
}

Here we are fetching data from the database and bind to the grid.

Add code to send grid view on email

Add following code in code behind

protected void btnSendOnEmail_Click(object sender, EventArgs e)
    {
        StringBuilder htmlResponse = new StringBuilder();
        using (StringWriter sw = new StringWriter(htmlResponse))
        {
            using (HtmlTextWriter textWriter = new HtmlTextWriter(sw))
            {
                ((Control)gvReport).RenderControl(textWriter);                
            }
        }

        MailMessage mailMessage = new MailMessage();
        mailMessage.From = new MailAddress("sender_address");
        mailMessage.To.Add("recipient_address");
        mailMessage.Subject = "Report";
        mailMessage.IsBodyHtml = true;
        mailMessage.Body = htmlResponse.ToString();
        
        SmtpClient smtpServer = new SmtpClient("smtp");
        smtpServer.Port = 25;
        smtpServer.Credentials = new System.Net.NetworkCredential("user_name", "password");
        smtpServer.EnableSsl = false;
        smtpServer.Send(mailMessage);
        mailMessage.Attachments.Clear();
        mailMessage = null;


    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        /* Confirms that an HtmlForm control is rendered for the specified ASP.NET
           server control at run time. */
    }

Code explanation

The code above performs 2 functionalities

1. Get the rendered HTML of the grid view

2. Send rendered HTML on email as an email’s body.

Let us explain each functionality.

The best way to get the rendered HTML of a control is to call the RenderControl() method of the Control class. See the code section below

StringBuilder htmlResponse = new StringBuilder();
using (StringWriter sw = new StringWriter(htmlResponse))
{
   using (HtmlTextWriter textWriter = new HtmlTextWriter(sw))
   {
                ((Control)gvReport).RenderControl(textWriter);                
   }
}

In this code I am assigning rendered HTML of the grid view to a variable htmlResponse (which is of type StringBuilder).

In the second part I am sending an email to the recipient with email body as rendered HTML

MailMessage mailMessage = new MailMessage();
mailMessage.From = new MailAddress("sender_address");
mailMessage.To.Add("recipient_address");
mailMessage.Subject = "Report";
mailMessage.IsBodyHtml = true;
mailMessage.Body = htmlResponse.ToString();
        
SmtpClient smtpServer = new SmtpClient("smtp");
smtpServer.Port = 25;
smtpServer.Credentials = new System.Net.NetworkCredential("user_name", "password");
smtpServer.EnableSsl = false;
smtpServer.Send(mailMessage);
mailMessage.Attachments.Clear();
mailMessage = null;

It is required to add ‘VerifyRenderingInServerForm’ method else you will get this run time error - Control 'MainContent_gvReport' of type 'GridView' must be placed inside a form tag with runat=server.

Output

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Friday, April 12, 2013

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250