display data in text boxes and export to pdf

kuldeep singh

11y2.9k.NET

Good Morning Friends,

I have a employee's salary database and i have designed salary slip in web form and displaying data in that form from data base.

When i am exporting the form to pdf it is only exporting the HTML content only, not the data which i have fetched from data base(using show button)

can anyone give me an idea how to export the web form data to pdf(as it is displayed in web form).

my code

Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
this.Page.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();

19 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gowtham Rajamanickam11y ago
Accepted answer
http://www.codeproject.com/Articles/200079/All-in-One-Export-Data-in-ASP-NET
+1
Upendra Pratap Shahi11y ago
Ur welcome dear..

For better discussion kindly accept the best solution or idea which may help you.
0
kuldeep singh11y ago
now with the help of you friends i am able to export salary slip to pdf ....but can anyone help me how to create salary slip(pdf file) of all employee on single button click.
0
kuldeep singh11y ago
thanks you very much *****Gowtham Rajamanickam***** & *****Upendra Pratap Shahi*****
you saved my hours..
0
Gowtham Rajamanickam11y ago
http://www.c-sharpcorner.com/UploadFile/9f0ae2/export-gridview-into-pdf-in-Asp-Net/
+1
Gowtham Rajamanickam11y ago
http://www.c-sharpcorner.com/UploadFile/9f0ae2/export-gridview-into-pdf-in-Asp-Net/
+1
kuldeep singh11y ago
thanks Upendra Pratap Shahi for the formview idea it is working fine but now the problem is i have dropdownlist(dynamic) to filter data and when exporting to pdf it is also exporting whole list of dropdownlist(such all emp name)...how to stop the export of dropdown list...please help
0
kuldeep singh11y ago
friends help me
0
kuldeep singh11y ago
thanks sanjeeb.... but same problem it is exporting only label name and dropdown data to pdf ...

not exporting the data which is shown in text boxes
....................

0
Upendra Pratap Shahi11y ago
I have suggest one thing, try to use formview control instead of complex of html code.
This is very easy and you can customize this according to your need.
+1
Sanjeeb Lenka11y ago
try this: i created a bind method calling it in both the button click.

private void Bind()
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
con.Open();
string str9 = "select * from ZTEST where vEmployeeName='" + ddlEmployeeName.SelectedItem.Text + "' ";
da1 = new SqlDataAdapter(str9, con);
dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
txtDesignation.Text += dt1.Rows[0]["vEmpDesignation"].ToString();
txtBasic.Text += dt1.Rows[0]["vBasic"].ToString();
txtHRA.Text += dt1.Rows[0]["vHRA"].ToString();
txtSAllowance.Text += dt1.Rows[0]["vSpecialAllowances"].ToString();
txtTA.Text += dt1.Rows[0]["vTA"].ToString();
txtVAllowance.Text += dt1.Rows[0]["vVariableAllowances"].ToString();
txtCAllowance.Text += dt1.Rows[0]["vChildrenAllowances"].ToString();
txtLoan.Text += dt1.Rows[0]["vLoan"].ToString();
txtAdvance.Text += dt1.Rows[0]["vADVANCE"].ToString();
txtPF.Text += dt1.Rows[0]["vPF_EMPLOYEE"].ToString();
txtTDS.Text += dt1.Rows[0]["vTDS"].ToString();
txtOtherDeduction.Text += dt1.Rows[0]["vOTHER"].ToString();
txtEarningTotal.Text += dt1.Rows[0]["vTotalSalaryPM"].ToString();
txtDeducationTotal.Text += dt1.Rows[0]["vTotalDeduction"].ToString();
txtNetSalary.Text += dt1.Rows[0]["vNetPayable"].ToString();
}
}

protected void btnExportToPdf_Click(object sender, EventArgs e)
{
Bind();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
this.Page.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
// to show records on form from data base
protected void btnView_Click(object sender, EventArgs e)
{
Bind();
}
+1
Nanhe Siddique11y ago
http://www.infragistics.com/community/forums/t/60188.aspx

http://www.aspdotnet-suresh.com/2011/04/how-to-export-gridview-data-to-pdf.html
0
kuldeep singh11y ago
thanks hema text boxes and drop down list
0
Hema Latha11y ago
Hi kuldeep singh, where you binded the data which was fetched from database? means in gridview or any other.

See this,

http://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-pdf/
0
kuldeep singh11y ago
html code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%--<%@ Page Language="C#" AutoEventWireup="true" EnableEventValidation = "false" %>--%>

DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title>Salary Sliptitle>

<style type="text/css">

#form1 {

height: 1068px;

}

style>

head>

<body>

<div id="dvText" runat="server">

<form id="form1" runat="server">

<asp:Button ID="btnExportToPdf" runat="server" OnClick="btnExportToPdf_Click" Text="Export" />

<asp:Button ID="btnView" runat="server" OnClick="btnView_Click" Text="View" />

<asp:Panel ID="Panel1" runat="server" Height="78px" style="margin-left: 349px" Width="456px">New Delhiasp:Panel>

 

 

<asp:Panel ID="Panel2" runat="server" Height="430px" style="margin-left: 0px" Width="802px">

<asp:Label ID="Label2" runat="server" Text="Employee Name">asp:Label>

<asp:DropDownList ID="ddlEmployeeName" runat="server" OnSelectedIndexChanged="ddlEmployeeName_SelectedIndexChanged">

asp:DropDownList>

<asp:Label ID="Label3" runat="server" Text="Month">asp:Label>

<asp:DropDownList ID="ddlMonth" runat="server" OnSelectedIndexChanged="ddlMonth_SelectedIndexChanged">

asp:DropDownList>

 

<asp:Label ID="Label4" runat="server" Text="Employee Designation">asp:Label>

<asp:TextBox ID="txtDesignation" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label5" runat="server" Text="Salary Slip">asp:Label>

 

<asp:Label ID="Label6" runat="server" Text="EARNING">asp:Label>

<asp:Label ID="Label7" runat="server" Text="DEDUCTION">asp:Label>

 

 

<asp:Label ID="Label8" runat="server" Text="Particulars">asp:Label>

<asp:Label ID="Label9" runat="server" Text="Amount">asp:Label>

<asp:Label ID="Label10" runat="server" Text="Particulars">asp:Label>

<asp:Label ID="Label11" runat="server" Text="Amount">asp:Label>

 

<asp:Label ID="Label12" runat="server" Text="Basic">asp:Label>

<asp:TextBox ID="txtBasic" runat="server">asp:TextBox>

<asp:Label ID="Label13" runat="server" Text="Loan">asp:Label>

<asp:TextBox ID="txtLoan" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label14" runat="server" Text="HRA">asp:Label>

<asp:TextBox ID="txtHRA" runat="server">asp:TextBox>

<asp:Label ID="Label15" runat="server" Text="Advance">asp:Label>

<asp:TextBox ID="txtAdvance" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label16" runat="server" Text="Special Allowance">asp:Label>

;

<asp:TextBox ID="txtSAllowance" runat="server">asp:TextBox>

<asp:Label ID="Label17" runat="server" Text="PF">asp:Label>

<asp:TextBox ID="txtPF" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label18" runat="server" Text="TA">asp:Label>

<asp:TextBox ID="txtTA" runat="server">asp:TextBox>

<asp:Label ID="Label19" runat="server" Text="TDS">asp:Label>

<asp:TextBox ID="txtTDS" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label20" runat="server" Text="Variable Allowance">asp:Label>

;

<asp:TextBox ID="txtVAllowance" runat="server">asp:TextBox>

<asp:Label ID="Label21" runat="server" Text="Other Deduction">asp:Label>

<asp:TextBox ID="txtOtherDeduction" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label22" runat="server" Text="Child Allowance">asp:Label>

<asp:TextBox ID="txtCAllowance" runat="server">asp:TextBox>

 

 

 

 

 

asp:Panel>

 

 

<asp:Panel ID="Panel5" runat="server" style="margin-left: 0px" Width="814px">

<asp:Label ID="Label23" runat="server" Text="Total">asp:Label>

<asp:TextBox ID="txtEarningTotal" runat="server">asp:TextBox>

<asp:Label ID="Label24" runat="server" Text="Total">asp:Label>

<asp:TextBox ID="txtDeducationTotal" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label25" runat="server" Text="Net Salary(Figure) :-">asp:Label>

<asp:TextBox ID="txtNetSalary" runat="server" Width="602px">asp:TextBox>

 

 

<asp:Label ID="Label26" runat="server" Text="Net Salary(Words) :-">asp:Label>

<asp:TextBox ID="txtNetSalaryW" runat="server" Width="596px">asp:TextBox>

 

 

 

asp:Panel>

 

 

 

 

<asp:Label ID="Label27" runat="server" Text="For Breakthrough Trust">asp:Label>

 

 

<asp:Label ID="Label28" runat="server" Text="Sr. Manager Account">asp:Label>

 

 

<asp:Label ID="Label29" runat="server" Text="Date">asp:Label>

<asp:TextBox ID="txtDate" runat="server">asp:TextBox>

 

 

<asp:Label ID="Label30" runat="server" Text="Place">asp:Label>

<asp:TextBox ID="txtPlace" runat="server">asp:TextBox>

form> div>

body>

html>
0
kuldeep singh11y ago
thanks upendra ... i am just posting my complete code ..pls help
0
kuldeep singh11y ago
thanks sanjeeb... i am confused how to do that i am posting the complete code please help
0
Upendra Pratap Shahi11y ago
Where are you binding the data in this context?
Firstly bind the data then you should export in pdf.

read below articles-

http://www.c-sharpcorner.com/UploadFile/9f0ae2/export-gridview-into-pdf-in-Asp-Net/
http://www.codeproject.com/Articles/200079/All-in-One-Export-Data-in-ASP-NET
+1
Sanjeeb Lenka11y ago
in the export to pdf button click bind all the data to the controls then try.
+1