private void filterCrystalReport(string parameter)
{
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load("D:\\FITHOU\\Lập trình hướng sự kiện\\BTLHSK\\BTLHSK\\sinhVienReport.rpt");
quanlysachDataSet2 ds = new quanlysachDataSet2();
SqlConnection con = openSQL();
SqlDataAdapter sda = new SqlDataAdapter("[dbo].[reportSinhVien]", con);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.AddWithValue("@check", parameter);
DataSet st = new DataSet();
sda.Fill(st, "tblSinhVien");
rptDoc.SetDataSource(st);
sinhVienReport.ReportSource = rptDoc;
}
private void filterCrystalReport(string parameter)
{
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load("C:\\Users\\dinhv\\Downloads\\BTLHSK\\BTLHSK\\theLoaiReport.rpt");
quanlysachDataSet2 ds = new quanlysachDataSet2();
SqlConnection con = openSQL();
SqlDataAdapter sda = new SqlDataAdapter("[dbo].[reportTheLoai]", con);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.AddWithValue("@check", parameter);
DataSet st = new DataSet();
sda.Fill(st, "tblTheLoai");
rptDoc.SetDataSource(st);
crystalReportTheLoai.ReportSource = rptDoc;
}
//report
private void filterCrystalReport(string parameter)
{
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load("C:\\Users\\dinhv\\Downloads\\BTLHSK\\BTLHSK\\CrystalReport1.rpt");
quanlysachDataSet2 ds = new quanlysachDataSet2();
SqlConnection con = openSQL();
SqlDataAdapter sda = new SqlDataAdapter("[dbo].[reportSach]", con);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.AddWithValue("@check", parameter);
DataSet st = new DataSet();
sda.Fill(st, "tblSach");
rptDoc.SetDataSource(st);
sachReport.ReportSource = rptDoc;
groupInfor.Visible = false;
danhSachGroup.Visible = false;
controlGroup.Visible = false;
}
