void Save_PDF() { if (File.Exists(@"\\designsvr1\apps\Design and Supply CSharp\Documents\Jodan Quote\Temp Files\Quote" + Valuesclass.project_id + ".PDF")) { File.Delete(@"\\designsvr1\apps\Design and Supply CSharp\Documents\Jodan Quote\Temp Files\Quote" + Valuesclass.project_id + ".PDF"); CrRptQuote1.ExportToDisk(ExportFormatType.PortableDocFormat, @"\\designsvr1\apps\Design and Supply CSharp\Documents\Jodan Quote\Temp Files\Quote" + Valuesclass.project_id + ".PDF"); } else { CrRptQuote1.ExportToDisk(ExportFormatType.PortableDocFormat, @"\\designsvr1\apps\Design and Supply CSharp\Documents\Jodan Quote\Temp Files\Quote" + Valuesclass.project_id + ".PDF"); } }
void Fill_data() { DataSet ds = new DataSet(); DataSet ds_item = new DataSet(); SqlConnection conn = ConnectionClass.GetConnection_jodan_quote(); SqlDataAdapter select_quote_report = new SqlDataAdapter(Statementsclass.select_quote_report, conn); SqlDataAdapter select_item_report = new SqlDataAdapter(Statementsclass.select_item_report, conn); select_quote_report.SelectCommand.Parameters.AddWithValue("@project_id", Valuesclass.project_id); select_item_report.SelectCommand.Parameters.AddWithValue("@project_id", Valuesclass.project_id); select_quote_report.Fill(ds); select_item_report.Fill(ds_item); CrRptQuote1.SetDataSource(ds.Tables[0]); CrRptQuote1.Subreports[0].SetDataSource(ds_item.Tables[0]); ConnectionClass.Dispose_connection(conn); crystalReportViewer1.ReportSource = CrRptQuote1; crystalReportViewer1.Refresh(); }