生成PDF文件检索信息后， [英] Generate pdf file after retrieving the information

问题描述

我需要创建从数据库中获得的数据的PDF文件。我得从数据库中检索数据并生成这些数据作为一个PDF文件。

I need to create a pdf file from data obtained from a database. I have to retrieve the data from database and generate these data as a pdf file.

我想有指针（有用的信息）。

I would like to have pointers (helpful information).

感谢您。

推荐答案

您可以使用 iTextSharp的为

protected void btnExportPdf_Click(object sender, EventArgs e)
{
    Response.ContentType = "application/pdf";
    Response.AddHeader("content-disposition", "attachment;filename=BusinessUnit.pdf");
    Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
    StringWriter sw = new StringWriter();
    HtmlTextWriter hw = new HtmlTextWriter(sw);
    GridView grd = new GridView();
    grd.DataSource = yourdatatable.DefaultView//get data from DB in Datatable
    grd.DataBind();
    grd.RenderControl(hw);
    StringReader sr = new StringReader(sw.ToString());
    Document pdfDoc = new Document(PageSize.A2, 8f, 8f, 8f, 8f);
    HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
    PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
    pdfDoc.Open();
    htmlparser.Parse(sr);
    pdfDoc.Close();
    Response.Write(pdfDoc);
    Response.End();
}

这篇关于生成PDF文件检索信息后，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！