Best Way of Exporting DataTable to PDF

How to Export DataTable to PDF using c#

As you know Export data as PDF file in C# is one of the most used functionality in the applications. So here, I am going to sharing how to Export data as PDF using C#.

Following is simple c# code that export data as PDF.

    public void ExportToPDF(string pdfName)

        {

            //Fetching user records with GetUserDetails method.

            /// Here you can wirte your own code to fetch recodes as per you DB connections.

            var UserList = repositoryUser.GetUserDetails();

            DataTable dt = new DataTable();

            dt.Columns.AddRange(new DataColumn[5] { new DataColumn("ID", typeof(long)),

            new DataColumn("Name", typeof(string)),

            new DataColumn("Age", typeof(int)),

            new DataColumn("Address", typeof(string)),

            new DataColumn("DOB", typeof(string)),

            });

            foreach (var x in UserList)

            {

                dt.Rows.Add(x.ID, x.Name, x.Age, x.Address, x.DOB);

            }

            GridView GridView1 = new GridView();

            GridView1.AllowPaging = false;

            GridView1.DataSource = dt;

            GridView1.DataBind();

            Response.ContentType = "application/pdf";

            Response.AddHeader("content-disposition", "attachment;filename=UserList.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.A0, 2f, 1f, 1f, 1f);

            HTMLWorker htmlparser = new HTMLWorker(pdfDoc);

            PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

            pdfDoc.Open();

            htmlparser.Parse(sr);

            pdfDoc.Close();

            Response.Write(pdfDoc);

            Response.End();

        }

YOU MAY ALSO LIKE...

Export data as Excel file in C#
Export data as PDF file in C#
Export data as CSV file in C#
Export data as Word file in C#


I hope you are enjoying with this post! Please share with you friends!! Thank you!!!