public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1indanhsachphongban rpt = new CrystalReport1indanhsachphongban();
rpt.Site = this.Site;
return(rpt);
}
private void Formfdanhsachphongban_Load(object sender, EventArgs e)
{
var query = "SELECT PHONGBAN.MAPHG, PHONGBAN.TENPHG, NHANVIEN.HOTENNV, PHONGBAN.NG_NHANCHUCTRP " +
"FROM NHANVIEN INNER JOIN " +
"PHONGBAN ON NHANVIEN.PHG = PHONGBAN.MAPHG AND NHANVIEN.MANV = PHONGBAN.TRPHG";
SqlDataAdapter da = new SqlDataAdapter(query, Bang.Bang.cnn);
SqlCommandBuilder cmm = new SqlCommandBuilder(da);
try
{
DataTable b = new DataTable();
da.Fill(b);
CrystalReport1indanhsachphongban rpt = new CrystalReport1indanhsachphongban();
rpt.SetDataSource(b);
crystalReportViewer1.ReportSource = rpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
