private void frmExportReport_Load(object sender, EventArgs e) { // tạo mẫu báo cáo CrystalReportEmployee rpt = new CrystalReportEmployee(); // đưa dư liêu lên báo cáo rpt.SetDataSource(frmSalary.salaryEntities); // dua vao báo cao crystalReportViewer1.ReportSource = rpt; // hien thi crystalReportViewer1.Show(); }
private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'bloodBankDBDataSetEmpUpdDatGridView.Staff' table. You can move, or remove it, as needed. this.staffTableAdapter3.Fill(this.bloodBankDBDataSetEmpUpdDatGridView.Staff); // TODO: This line of code loads data into the 'bloodBankDBDataSetEmpUpdID.Staff' table. You can move, or remove it, as needed. this.staffTableAdapter2.Fill(this.bloodBankDBDataSetEmpUpdID.Staff); // TODO: This line of code loads data into the 'bloodBankDBDataSetPatientStaffID.Staff' table. You can move, or remove it, as needed. this.staffTableAdapter1.Fill(this.bloodBankDBDataSetPatientStaffID.Staff); // TODO: This line of code loads data into the 'bloodBankDBDataSet.Staff' table. You can move, or remove it, as needed. this.staffTableAdapter.Fill(this.bloodBankDBDataSet.Staff); //For Crystal Report CrystalReportBloodTest crbt = new CrystalReportBloodTest(); crystalReportViewerTest.ReportSource = crbt; CrystalReportEmployee cremp = new CrystalReportEmployee(); crystalReportViewerEmployee.ReportSource = cremp; CrystalReportStorage crs = new CrystalReportStorage(); crystalReportViewerStorage.ReportSource = crs; //auto fill searchbox try { SqlConnection con = new SqlConnection(cs); con.Open(); string autoQry = "SELECT Name from Staff"; SqlCommand cmd = new SqlCommand(autoQry, con); SqlDataReader dataReader = cmd.ExecuteReader(); AutoCompleteStringCollection autoCompleteStringStaff = new AutoCompleteStringCollection(); while (dataReader.Read()) { autoCompleteStringStaff.Add(dataReader.GetString(0)); } textBoxAutoSearchStaff.AutoCompleteCustomSource = autoCompleteStringStaff; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }