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