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);
}

Twitter
Search
About
Learn C#