public void load_Fecal() { IniFile ini = new IniFile(ClassSql.MMS_Path); R_Fecalysis1.SetDatabaseLogon(ini.IniReadValue("CONNECTIONSTRING", "Uid"), ini.IniReadValue("CONNECTIONSTRING", "Pwd"), ini.IniReadValue("CONNECTIONSTRING", "Server"), ini.IniReadValue("CONNECTIONSTRING", "Database")); R_Fecalysis1.Load(@"C:\Report\R_Fecalysis.rpt"); Viewer_06.ReportSource = R_Fecalysis1; Viewer_06.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'"; //ClassSql a = new ClassSql(); //TextBox txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox(); //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '6'", txt_ForNo, "Form"); //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '2'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_Fecalysis1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_lab_061.ReportDefinition.ReportObjects["txt_RevNo"]; FormNo.Text = ini.IniReadValue("FORM", "Lab_Fecalysis"); RevNo.Text = ini.IniReadValue("REVISION", "Lab_Fecalysis"); //R_Urinalysis1.Refresh(); Viewer_06.RefreshReport(); RemoveTab(Viewer_06); wizard1.SelectedTab = tabPage6; }
public void load_Fecal() { R_Fecalysis1.Load(@"C:\Report\R_Fecalysis.rpt"); crystalReportViewer6.ReportSource = R_Fecalysis1; crystalReportViewer6.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'"; ClassSql a = new ClassSql(); TextBox txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox(); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '6'", txt_ForNo, "Form"); //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '2'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_Fecalysis1.ReportDefinition.ReportObjects["txt_formNo"]; //TextObject RevNo = (TextObject)R_lab_061.ReportDefinition.ReportObjects["txt_RevNo"]; FormNo.Text = txt_ForNo.Text; //RevNo.Text = txt_RevNo.Text; //R_Urinalysis1.Refresh(); crystalReportViewer6.RefreshReport(); RemoveTab(crystalReportViewer6); wizard1.SelectedTab = tabPage6; }