private void Page_Load(object sender, System.EventArgs e)
{
   if(!IsPostBack)
   {
      SqlConnection sqlConnection;
      sqlConnection= new SqlConnection(CONNECTION_STRING);
      sqlConnection.Open();
      SqlCommand sqlCommand = new SqlCommand(
                                     SQLQUERY,
                                     sqlConnection
                                   );
      SqlDataReader sqlReader = null;
      try
      {
         sqlReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection);
         DataGrid1.DataSource = sqlReader; 
         DataGrid1.DataBind();
      }
      finally
      {
         if(sqlReader != null)
            sqlReader.Close();
      }
   }  
}
private void Button1_Click(object sender, System.EventArgs e)
{         
   SendEmail(GetGridHtml());     
}
private string GetGridHtml()
{
   string result = null;
   StringWriter stringWriter = new StringWriter();
   HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
   
   try
   {
      htmlWriter.RenderBeginTag(HtmlTextWriterTag.Html);
      htmlWriter.RenderBeginTag(HtmlTextWriterTag.Body);         
      DataGrid1.RenderControl(htmlWriter);
      htmlWriter.RenderEndTag();
      htmlWriter.RenderEndTag();
      htmlWriter.Flush();
      result = stringWriter.ToString();
   }
   finally
   {
      htmlWriter.Close();
      stringWriter.Close();
   }
   return result;
}
private void SendEmail(string html)
{
   MailMessage mailMessage = new MailMessage();
   mailMessage.To = TOADDRESS;
   mailMessage.From = FROMADDRESS;
   mailMessage.Subject = SUBJECT;
   mailMessage.BodyFormat = MailFormat.Html;
   mailMessage.Body = html;
   SmtpMail.SmtpServer = SMTPSERVER;
   SmtpMail.Send(mailMessage);
}

 
         
     Subscribe
            Subscribe
         Twitter
            Twitter
         Search
            Search
         About
            About
         Learn C#
            Learn C#