protected void ibtnExportPDFAppTable_Click(object sender, EventArgs e) { string strfilename = "BooksReportFrom" + txtDate1.Text + "To" + txtDate2.Text; Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=" + strfilename + ".pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridBooks.AllowPaging = false; GridBooks.DataSource = getbooks(); GridBooks.DataBind(); GridBooks.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); }
protected void ibtnExportDocAppTable_click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; string strfilename = "BooksReportFrom" + txtDate1.Text + "To" + txtDate2.Text; Response.AddHeader("content-disposition", "attachment;filename=" + strfilename + ".doc"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-word "; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridBooks.AllowPaging = false; GridBooks.DataSource = getbooks(); GridBooks.DataBind(); GridBooks.RenderControl(hw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); }
protected void ibtnExportExcelAppTable_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; string strfilename = "BooksReportFrom" + txtDate1.Text + "To" + txtDate2.Text; Response.AddHeader("content-disposition", "attachment;filename=" + strfilename + ".xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridBooks.AllowPaging = false; GridBooks.DataSource = getbooks(); GridBooks.DataBind(); GridBooks.RenderControl(hw); string style = @"<style> .textmode { mso-number-format:\@; } </style>"; Response.Write(style); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); }