But i need to save into database also.
Following are the code please help me...?
========================================================================
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("DESCRIPTION"),
new DataColumn("QTY IN MTR"),
new DataColumn("RATE PER MTR")});
dt.Rows.Add("100 NB SCH 10", "12", "2715.00");
dt.Rows.Add("80 NB SCH 10","12", "2715.00");
dt.Rows.Add("15 NB SCH 10", "12", "2715.00");
dt.Rows.Add("80 NB SCH 10", "12", "2715.00");
SendPDFEmail(dt);
}
}
private void SendPDFEmail(DataTable dt)
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
string customername = "XYZ";
StringBuilder sb = new StringBuilder();
sb.Append("
![]() | |
| Dear "); sb.Append(customername); sb.Append(" | Date: "); sb.Append(DateTime.Now); sb.Append(" |
| We are send you quotation ............................................................................................................................................ | |
sb.Append("
");
sb.Append("
| "); sb.Append(column.ColumnName); sb.Append(" | ");
|---|
| "); sb.Append(row[column]); sb.Append(" | ");
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
using (MemoryStream memoryStream = new MemoryStream())
{
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, memoryStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
byte[] bytes = memoryStream.ToArray();
memoryStream.Close();
MailMessage mm = new MailMessage("[email protected]", "[email protected]");
mm.Subject = "Quotation";
mm.Body = "Please Find Attachment";
mm.Attachments.Add(new Attachment(new MemoryStream(bytes), customername+".pdf"));
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential();
NetworkCred.UserName = "[email protected]";
NetworkCred.Password = "
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
}
}
}


Guest UserPosted Aug 12, 2014, 12:23 AM