How to generate Salary slip for all employee on single click

Question

Good Morning Friends, Currently i am creating salary slip one by one (pdf),.... may anyone help how to create salary slip for all employee on single click and send salary slip to the employee on their respective email id

kuldeep singh · Answer

friend trying like this but not working only creating pdf for first record..... (in vb we may use while rs.eof etc. but in c# what is the concept i don't know) any help please.... ................ my code ............ protected void btnShowAndExportToPDF_Click(object sender, EventArgs e) { // bindgrid(); if (conn.State != ConnectionState.Closed) { conn.Close(); } conn.Open(); //1 string str5 = "select * from ztest"; // string str5 = "select * from ZTEST where vEmployeeName='" + ddlEmpName.SelectedItem.Text + "' "; da2 = new SqlDataAdapter(str5, conn); dt2 = new DataTable(); da2.Fill(dt2); //int ii = 0; //while (ii //{ // ii=ii+1; foreach (DataRow rows in dt2.Rows) { //if (dt2.Rows.Count > 0 && dt2.Rows.Count //{ for (int i = 0; i { FormView1.DataSource = dt2; FormView1.DataBind(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=Export.pdf"); // Response.AddHeader("content-disposition", "attachment;filename = '" + vEmployeeNameTextBox.Text +"'); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); HtmlForm frm = new HtmlForm(); FormView1.Parent.Controls.Add(frm); frm.Attributes["runat"] = "server"; frm.Controls.Add(FormView1); frm.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(); } } // } //dt = new DataTable(); //com.Connection = conn; //com.CommandText = "SELECT * FROM ztest"; //sqlda = new SqlDataAdapter(com); //sqlda.Fill(dt); //FormView1.DataSource = dt2; //FormView1.DataBind(); conn.Close(); }

Upendra Pratap Shahi · Answer

for this you have to put all data in data reader and in a single code block put everything, I mean when you read from data reader then bind in this with form view and click export button to to print in pdf and you should have give each file name as differnt then this is not overwrite in your folder while this create a new file and all this thing in a loop. What to do- 1-Put all the data in a data reader 2- read data reader and fetch data on respected 3-bind data in formview inside the loop 4-click exporting also fire when data is bind with form view 5-You shold put your file name as employee basis or different name This may work for you. If this is satisfied you kindly mark the answer as Accepted Answer

Khargesh Rajput · Answer

to show salary slip you may getting result from database where empoyeeID you select now to display show all employyes salary do not use filter with employee, you will get all employees salary and print that page

Nanhe Siddique · Answer

read this link http://www.codeproject.com/Questions/351018/Asp-net-RDLC-How-to-Print-a-report-same-format-for http://codeverge.com/asp.net.crystal-reports/generate-more-than-one-different-page/85114 It may help you

How to generate Salary slip for all employee on single click

Answers (4)