protected void btnGenerate_Click(object sender, EventArgs e) { string path = Server.MapPath("PDF-Files"); string filename = path + "/Report1_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf"; if (File.Exists(filename)) // if file exists { File.Delete(filename); // delete file } DataTable dt = new DataTable(); // get daterange values from form. string dates = Convert.ToString(drreportdate.Text); string[] fromdate = dates.Substring(0, 10).Split('/'); string fromdate1 = (DateTime.Parse(string.Format("{0}/{1}/{2}", fromdate[1], fromdate[0], fromdate[2]))).ToString("yyyy-MM-dd"); // convert to database date format. string[] todate = dates.Substring(13, 10).Split('/'); string todate1 = (DateTime.Parse(string.Format("{0}/{1}/{2}", todate[1], todate[0], todate[2]))).ToString("yyyy-MM-dd"); // convert to database date format. dt = VPCRMSBAL.GetReportData(fromdate1, todate1, Convert.ToDecimal(Session["UserID"].ToString().Trim()), Session["UserRole"].ToString().Trim()); ReportDAL.Report1ExportToPdf(dt); // Generate PDF first. displaypdf.Visible = true; displaypdf2.Visible = false; displaypdf.FilePath = @"~/PDF-Files/Report1_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf"; }