Export Our GridView Selected Record to a PDF

Rahul Saxena
10y
12.8k
0
1

100

Article

ExportGridViewSelectedRecordToPDF.zip

The following is my data table:

Image 1

My table in design mode:

Image 2
Now my aspx code:
1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4. <html xmlns="http://www.w3.org/1999/xhtml">
5. <head runat="server">
6. <title>Export Record To PDF using iTextSharp</title>
7. </head>
8. <body>
9. <form id="form1" runat="server">
10. <div>
11. <table cellpadding="10" cellspacing="10" style="border: solid 10px red; background-color: Skyblue;"
12. width="90%" align="center">
13. <tr>
14. <td style="height: 35px; background-color: Yellow; font-weight: bold; font-size: 16pt;
15. font-family: Times New Roman; color: Red" align="center">
16. Export Record To PDF
17. </td>
18. </tr>
19. <tr>
20. <td>
21. <asp:GridView ID="GridViewRecord" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
22. RowStyle-BackColor="#A1DCF2" runat="server" AutoGenerateColumns="False"
23. BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px"
24. CellPadding="4">
25. <RowStyle BackColor="White" ForeColor="#330099"></RowStyle>
26. <Columns>
27. <asp:TemplateField>
28. <ItemTemplate>
29. <asp:CheckBox ID="chkSelect" runat="server" />
30. </ItemTemplate>
31. </asp:TemplateField>
32. <asp:BoundField DataField="EmployeeName" HeaderText="Employee Name" ItemStyle-Width="150px" />
33. <asp:BoundField DataField="CompanyName" HeaderText="Company Name" ItemStyle-Width="120px" />
34. <asp:BoundField DataField="ProjectName" HeaderText="Project Name" ItemStyle-Width="100px" />
35. <asp:BoundField DataField="JoiningDate" HeaderText="Joining Date" ItemStyle-Width="150px" />
36. <asp:BoundField DataField="Address" HeaderText="Address" ItemStyle-Width="100px" />
37. </Columns>
38. <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
39. <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
40. <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
42. <HeaderStyle BackColor="#990000" ForeColor="#FFFFCC" Font-Bold="True"></HeaderStyle>
43. </asp:GridView>
44. </td>
45. </tr>
46. <tr>
47. <td>
48. <asp:Button ID="btnExportGridRecord" runat="server" Text="Export To PDF" OnClick="btnExportGridRecord_Click" />
49. </td>
50. </tr>
51. </div>
52. </form>
53. </body>
54. </html>
Now my aspx.cs code:
1. using System;
2. using System.Configuration;
3. using System.Data;
4. using System.Linq;
5. using System.Web;
6. using System.Web.Security;
7. using System.Web.UI;
8. using System.Web.UI.HtmlControls;
9. using System.Web.UI.WebControls;
10. using System.Web.UI.WebControls.WebParts;
11. using System.Xml.Linq;
12. using System.IO;
13. using System.Data.SqlClient;
14. using iTextSharp.text;
15. using iTextSharp.text.html.simpleparser;
16. using iTextSharp.text.pdf;
18. public partial class _Default : System.Web.UI.Page
19. {
20. protected void Page_Load(object sender, EventArgs e)
21. {
22. if (!IsPostBack)
23. {
24. this.BindGridData();
25. }
26. }
28. private void BindGridData()
29. {
30. SqlConnection con = new SqlConnection(@"Server=MyPC\SqlServer2k8;database=Test;Integrated Security=true;");
31. SqlCommand cmd = new SqlCommand("SELECT TOP 15 * FROM Employee");
32. SqlDataAdapter da = new SqlDataAdapter(cmd);
33. cmd.Connection = con;
34. DataTable dt = new DataTable();
35. da.Fill(dt);
36. GridViewRecord.DataSource = dt;
37. GridViewRecord.DataBind();
38. }
40. protected void btnExportGridRecord_Click(object sender, EventArgs e)
41. {
42. using (StringWriter sw = new StringWriter())
43. {
44. using (HtmlTextWriter hw = new HtmlTextWriter(sw))
45. {
46. GridViewRecord.Columns[0].Visible = false;
47. foreach (GridViewRow row in GridViewRecord.Rows)
48. {
49. if (row.RowType == DataControlRowType.DataRow)
50. {
51. row.Visible = (row.FindControl("chkSelect") as CheckBox).Checked;
52. }
53. }
55. GridViewRecord.RenderControl(hw);
56. StringReader sr = new StringReader(sw.ToString());
57. Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
58. HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
59. PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
60. pdfDoc.Open();
61. htmlparser.Parse(sr);
62. pdfDoc.Close();
64. Response.ContentType = "application/pdf";
65. Response.AddHeader("content-disposition", "attachment;filename=Records.pdf");
66. Response.Cache.SetCacheability(HttpCacheability.NoCache);
67. Response.Write(pdfDoc);
68. Response.End();
69. }
70. }
71. }
72. public override void VerifyRenderingInServerForm(Control control)
73. {
74. /* Verifies that the control is rendered */
75. }
76. }
Now run the application:

Image 3
Select records here and click on the Export to PDF button:

Image 4
From here you can open or save the PDF file. Now view your PDF file:

Image 5

Up Next

Ebook Download

View all

Diving into Knockout.JS

Read by 1.7k people

Download Now!

Learn

View all