public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
BaiThi rpt = new BaiThi();
rpt.Site = this.Site;
return(rpt);
}
private void btnPreview_Click(object sender, EventArgs e)
{
Report.BaiThi obj = new Report.BaiThi();
string maMH = monHoc.Select(string.Format("[Tên môn học] ='{0}'", comboBox2.Text.Trim()))[0][0].ToString();
string maSV, hoten;
if (DBAccess.nhom == "Sinh viên")
{
maSV = DBAccess.id;
hoten = DBAccess.hoTen;
}
else
{
maSV = sinhVien.Select(string.Format("hoten ='{0}'", comboBox1.Text.Trim()))[0][0].ToString();
hoten = comboBox1.Text.Trim();
}
int lan = Convert.ToInt32(comboBox3.Text);
string[] name = { "@masv", "@mamh", "@lan" };
object[] param = { maSV, maMH, lan };
DataTable bangDiem = DBAccess.ExecuteQuery("SP_LayBaiThi", name, param, 3);
obj.SetDataSource(bangDiem);
obj.SetParameterValue("@masv", maSV);
obj.SetParameterValue("ma sv", maSV);
obj.SetParameterValue("ten", hoten);
obj.SetParameterValue("tenmh", comboBox2.Text.Trim());
obj.SetParameterValue("@mamh", maMH);
obj.SetParameterValue("@lan", lan);
crptView.ReportSource = obj;
}