C#中gridview 的数据汇出到PDF中怎么实现啊？

2011-02-11 05:12:28 299 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

object_hellojie 墨衍会员 · AI 创作全网分发关注 + 加入社区

基于单片机智能家居控制系统设计 *单片机设计介绍，基于单片机智能家居控制系统设计。阅读详情

C#中gridview 的数据汇出到PDF中怎么实现啊？最好提供demo或者下载例子

...全文

手把手教你为RK3588开发板适配RTL8211F网卡：设备树配置与PHY驱动匹配全流程本文详细介绍了在RK3588开发板上适配RTL8211F千兆以太网PHY芯片的全流程，包括硬件原理图确认、设备树配置与PHY驱动匹配。通过实战案例和调试技巧，帮助开发者解决常见问题并优化网络性能，适用于嵌入式Linux开发中的Ethernet网络功能实现。阅读详情

object_hellojie

.NET社区 62,271 成员 668,968 内容

+ 关注 + 加入社区

切换为时间正序

crackdung 2011-02-12

打赏
举报

免費的，功能強大的，能滿足你所有導出功能需要使用這個
http://www.e-iceblue.com/Download/download-dataexport-for-net-now.html

其它樓上說的只是單調的

wwfgu00ing 2011-02-12

打赏
举报

Response.Clear();                Response.ContentType = "application/PDF";                Response.AddHeader("content-disposition", "attachment;filename=test.pdf");                Response.Charset = ""; ReportDocument l_crReportDocument;                l_crReportDocument = new ReportDocument();                ExportOptions l_crExportOptions = new ExportOptions();                DiskFileDestinationOptions l_crDiskFileDestinationOptions = new DiskFileDestinationOptions(); DataTable test=new DataTable("test"); // Remember the test datatable should have same coulmn names as that of .xsd file which you will use for report creating and also datatable name should be same as that of .xsd datatble.l_crReportDocument.Load(Server.MapPath("Report/test.rpt"));l_crReportDocument.SetDataSource(ManagerChequeDataTable);                MemoryStream l_oStream;                l_oStream = (MemoryStream)l_crReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);                Response.Clear();                Response.Buffer = true;                Response.ContentType = "application/PDF";                Response.BinaryWrite(l_oStream.ToArray());                Response.End();

智者知已应修善业 2011-02-11

打赏
举报

wuyq11 2011-02-11

打赏
举报

using iTextSharp.text;

using iTextSharp.text.pdf;

using iTextSharp.text.html;

using iTextSharp.text.html.simpleparser;

protected void btnExportPDF_Click(object sender, EventArgs e)

{

Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.pdf");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

GridView1.DataBind();

GridView1.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();

}

http://www.dotnetspider.com/forum/109866-Gridview-PDF.aspx

xinxing130 2011-02-11

打赏
举报

楼主可以用下wkhtmltopdf.exe这个生成pdf插件简单的需求生成没什么问题很方便

子夜__ 2011-02-11

打赏
举报

itextsharp

/// <summary>



    /// 转换GridView为PDF文档



    /// </summary>



    /// <param name="pobjGrdv">要转换的GridView</param>



    /// <param name="PDFFileName">在服务器端保存PDF时的文件名</param>



    /// <param name="FontPath">PDF甩用字体所在的物理路径</param>



    /// <param name="FontSize">字体大小</param>



    /// <returns>返回调用是否成功</returns>



    public static void ConvertGrdiViewToPdf(GridView pobjGrdv, string PDFFileName, string FontPath, float FontSize)



    {



        //在服务器端保存PDF时的文件名



        string strFileName = PDFFileName + ".pdf";



        // GridView的所有数据全输出



        pobjGrdv.AllowPaging = false;



        //**************************



        int countColumns = pobjGrdv.Columns.Count;



        int countRows = pobjGrdv.Rows.Count;



        if (countColumns != 0 && countRows != 0)



        {



            //初始化一个目标文档类       



            //Document document = new Document();



            //竖排模式,大小为A4，四周边距均为25



            Document document = new Document(PageSize.A4, 0, 0, 0, 0);



            //横排模式,大小为A4，四周边距均为50



            //Document doc = new Document(PageSize.A4.rotate(),50,50,50,50);



            //调用PDF的写入方法流



            //注意FileMode-Create表示如果目标文件不存在，则创建，如果已存在，则覆盖。



            PdfWriter writer = PdfWriter.GetInstance(document,



                new FileStream(HttpContext.Current.Server.MapPath(strFileName), FileMode.Create));



            try



            {



                //创建PDF文档中的字体



                BaseFont baseFont = BaseFont.CreateFont(



                  FontPath,



                  BaseFont.IDENTITY_H,



                  BaseFont.NOT_EMBEDDED);



                //根据字体路径和字体大小属性创建字体



                Font font = new Font(baseFont, FontSize);



                // 添加页脚



                //HeaderFooter footer = new HeaderFooter(new Phrase(footertxt), true);



                HeaderFooter footer = new HeaderFooter(new Phrase("-- ", font), new Phrase(" --", font));



                footer.Border = Rectangle.NO_BORDER;        // 不显示两条横线



                footer.Alignment = Rectangle.ALIGN_CENTER;  // 让页码居中



                document.Footer = footer;



                //打开目标文档对象



                document.Open();



                //**************************



                //根据数据表内容创建一个PDF格式的表



                PdfPTable table = new PdfPTable(countColumns);



                //iTextSharp.text.Table table = new iTextSharp.text.Table(pobjGrdv.Columns.Count);



                // 添加表头



                // 设置表头背景色



                //table.DefaultCell.BackgroundColor = Color.GRAY;  // OK



                //table.DefaultCell.BackgroundColor =



                //(iTextSharp.text.Color)System.Drawing.Color.FromName("#3399FF"); // NG



                table.DefaultCell.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;



                //table.DefaultCell.BackgroundColor = System.Drawing.Color.DodgerBlue; 



                // 添加表头



                for (int j = 0; j < countColumns; j++)



                {



                    table.AddCell(new Phrase(pobjGrdv.HeaderRow.Cells[j].Text, font));    // OK



                }



                // 告诉程序这行是表头，这样页数大于1时程序会自动为你加上表头。



                table.HeaderRows = 1;



                // 添加数据



                // 设置表体背景色



                table.DefaultCell.BackgroundColor = Color.WHITE;



                //遍历原gridview的数据行



                for (int i = 0; i < countRows; i++)



                {



                    for (int j = 0; j < countColumns; j++)



                    {



                        table.AddCell(new Phrase(pobjGrdv.Rows[i].Cells[j].Text, font));



                    }



                }



                //在目标文档中添加转化后的表数据



                document.Add(table);



            }



            catch (Exception)



            {



                throw;



            }



            finally



            {



                //关闭目标文件



                document.Close();



                //关闭写入流



                writer.Close();



            }



            // 弹出提示框，提示用户是否下载保存到本地



            try



            {



                //这里是你文件在项目中的位置,根目录下就这么写



                String FullFileName = System.Web.HttpContext.Current.Server.MapPath(strFileName);



                FileInfo DownloadFile = new FileInfo(FullFileName);



                System.Web.HttpContext.Current.Response.Clear();



                System.Web.HttpContext.Current.Response.ClearHeaders();



                System.Web.HttpContext.Current.Response.Buffer = false;



                System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream";



                System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename="



                    + System.Web.HttpUtility.UrlEncode(DownloadFile.FullName, System.Text.Encoding.UTF8));



                System.Web.HttpContext.Current.Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());



                System.Web.HttpContext.Current.Response.WriteFile(DownloadFile.FullName);



            }



            catch (Exception)



            {



                throw;



            }



            finally



            {



                System.Web.HttpContext.Current.Response.Flush();



                System.Web.HttpContext.Current.Response.End();



            }



        }



        else



        {



            System.Web.HttpContext.Current.Response.Write



                ("<script type='text/javascript'>alert('数据为空，不值得导出pdf！');</script>");



        }



    }



    //然后，在要调用转换的按钮的事件代码中调用就可以了



    //假设传进去的GridView的名字为GridView1



    //假设要保存的文件名为GridView的ID



    //假设字体使用simsun (请注意根据你电脑的实际情况来选择目录)



    //假设字号选择14



    //GridViewToPdf.ConvertGridViewToPdf(this.GridView1,



    //this.GridView1.ID.ToString(), "c:\\winnt\\FONTS\\simsun.ttc,1", 14);



    #endregion



}

全文参考

C#中gridview 的数据汇出到PDF中怎么实现啊？

相关推荐