public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return(rpt);
}
private void btn_xuatrp_Click(object sender, EventArgs e)
{
dt_SINHVIEN.DefaultView.RowFilter = "MaKhoa = '" + cb_MaKhoa.SelectedValue.ToString() + "'";
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(dt_SINHVIEN.DefaultView);
crystalReportViewer1.ReportSource = rpt;
}
private void Form1_Load(object sender, EventArgs e)
{
cnn = new SqlConnection(@"Data Source=DESKTOP-KS2AHB8\SQLEXPRESS;Initial Catalog=QLSINHVIEN4;Integrated Security=True");
da = new SqlDataAdapter("Select * from KHOA", cnn);
dt_KHOA = new DataTable();
da.Fill(dt_KHOA);
//
da.SelectCommand.CommandText = " select SV.*, K.MaKhoa, K.TenKhoa"
+ " from (SINHVIEN SV inner join LOP L on SV.MaLop = L.MaLop)"
+ " inner join KHOA K on L.MaKhoa = K.MaKhoa";
dt_SINHVIEN = new DataTable();
da.Fill(dt_SINHVIEN);
//
cb_MaKhoa.DataSource = dt_KHOA;
cb_MaKhoa.DisplayMember = "TenKhoa";
cb_MaKhoa.ValueMember = "MaKhoa";
cb_MaKhoa.SelectedIndex = -1;
//
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(dt_SINHVIEN.DefaultView);
crystalReportViewer1.ReportSource = rpt;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return rpt;
}
