public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DS_LopTC_HocKy rpt = new DS_LopTC_HocKy();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
if (tbNamhocDsLopTC.Text.Trim() == "")
{
MessageBox.Show("Năm học không được để trống!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string namHoc = checkNamHoc(tbNamhocDsLopTC.Text);
if (namHoc == "")
{
return;
}
DataTable tb = new DataTable();
using (SqlConnection cnn = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("dsLopTCHocKy", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@hocky", numericUpDownDSLopTChocky.Value);
cmd.Parameters.AddWithValue("@namhoc", namHoc);
cmd.Parameters.AddWithValue("@makhoa", cbbKho_DSlopTC.SelectedValue);
using (SqlDataAdapter ad = new SqlDataAdapter(cmd))
{
ad.Fill(tb);
}
}
}
DS_LopTC_HocKy ds = new DS_LopTC_HocKy();
ds.SetDataSource(tb);
InBaoCao bc = new InBaoCao();
bc.CrystalReportViewer1.ReportSource = ds;
bc.ShowDialog();
}
