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());
}
}
