数据表到Pdf文件和Word文件 [英] Datatable to Pdf file and Word file

问题描述

使用asp.net 将代码表中的数据表导出为pdf文件和word文件的代码.

解决方案

 // 将数据从数据库导入数据表

字符串 strQuery = " ;

SqlCommand cmd = 新 SqlCommand(strQuery);

DataTable dt = GetData(cmd);

// 创建虚拟GridView 

GridView GridView1 = 新 GridView();

GridView1.AllowPaging =  false ;

GridView1.DataSource = dt;

GridView1.DataBind();

Response.ContentType = " ;

Response.AddHeader(" ，

" )；

Response.Cache.SetCacheability(HttpCacheability.NoCache);

StringWriter sw = 新 StringWriter();

HtmlTextWriter hw = 新 HtmlTextWriter(sw);

GridView1.RenderControl(hw);

StringReader sr = 新 StringReader(sw.ToString());

文档pdfDoc = 新 Document(PageSize.A4，10f，10f，10f，0f);

HTMLWorker htmlparser = 新 HTMLWorker(pdfDoc);

PdfWriter.GetInstance(pdfDoc，Response.OutputStream);

pdfDoc.Open();

htmlparser.Parse(sr);

pdfDoc.Close();

Response.Write(pdfDoc);

Response.End(); 

<big>Export to Word</big>

 // 将数据从数据库导入数据表

字符串 strQuery = " ;

SqlCommand cmd = 新 SqlCommand(strQuery);

DataTable dt = GetData(cmd);

// 创建虚拟GridView 

GridView GridView1 = 新 GridView();

GridView1.AllowPaging =  false ;

GridView1.DataSource = dt;

GridView1.DataBind();

Response.Clear();

Response.Buffer =  true ;

Response.AddHeader(" ，

" )；

Response.Charset = " ;

Response.ContentType = "  ;;

StringWriter sw = 新 StringWriter();

HtmlTextWriter hw = 新 HtmlTextWriter(sw);

GridView1.RenderControl(hw);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End(); 

Code to export a datatable to a pdf file and a word file in c sharp using asp.net.

解决方案

<big>Export to PDF</big>

//Get the data from database into datatable

string strQuery = "Select * from customers";

SqlCommand cmd = new SqlCommand(strQuery);

DataTable dt = GetData(cmd);

//Create a dummy GridView

GridView GridView1 = new GridView();

GridView1.AllowPaging = false;

GridView1.DataSource = dt;

GridView1.DataBind();

Response.ContentType ="application/pdf";

Response.AddHeader("content-disposition",

"attachment;filename=DataTable.pdf");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

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

<big>Export to Word</big>

//Get the data from database into datatable

string strQuery = "select * from customers";

SqlCommand cmd = new SqlCommand(strQuery);

DataTable dt = GetData(cmd);

//Create a dummy GridView

GridView GridView1 = new GridView();

GridView1.AllowPaging = false;

GridView1.DataSource = dt;

GridView1.DataBind();

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition",

"attachment;filename=DataTable.doc");

Response.Charset = "";

Response.ContentType = "pplication/vnd.ms-word ";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.RenderControl(hw);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

这篇关于数据表到Pdf文件和Word文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！