public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
MarkSheet rpt = new MarkSheet();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
GetExamnumber();
if (lstbx_Students.SelectedItem.ToString() != "")
{
string s1 = "SELECT tbl_subject.subjectnum as [Subject No], tbl_subject.subject as Subject, tbl_ExamResult.Mark, tbl_ExamResult.Grade FROM tbl_subject INNER JOIN tbl_ExamResult ON tbl_subject.subjectnum = tbl_ExamResult.subno INNER JOIN tbl_student ON tbl_ExamResult.adno = tbl_student.adno where tbl_student.sname='" + lstbx_Students.SelectedItem.ToString() + "'";
SqlDataAdapter da1 = new SqlDataAdapter(s1, d.con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
MarkSheet msr = new MarkSheet();
msr.SetDataSource(ds1.Tables[0]);
string s = "SELECT tbl_student.sname, tbl_stddivision.cstandard, tbl_stddivision.division, tbl_student.adno, tbl_exam.exam, tbl_subject.subject, tbl_ExamResult.Mark, ";
s = s + "tbl_ExamResult.Grade, tbl_School.SchoolName, tbl_School.SchoolAddress, tbl_School.Phone FROM tbl_ExamResult INNER JOIN tbl_student ON tbl_ExamResult.adno = tbl_student.adno INNER JOIN";
s = s + " tbl_stddivision ON tbl_student.adno = tbl_stddivision.adno INNER JOIN tbl_exam ON tbl_ExamResult.ExamNo = tbl_exam.examnum INNER JOIN tbl_subject ON tbl_ExamResult.subno = tbl_subject.subjectnum CROSS JOIN tbl_School";
s = s + " where tbl_ExamResult.ExamNo =" + examnum + " And tbl_stddivision.cstandard='" + cmb_Stdrd.Text + "' And tbl_stddivision.division='" + cmb_Divs.Text + "' And tbl_student.sname='" + lstbx_Students.SelectedItem.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(s, d.con);
DataSet ds = new DataSet();
da.Fill(ds);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
msr.SetParameterValue("AdmissionNo", dr[3].ToString());
msr.SetParameterValue("StudentName", dr[0].ToString());
msr.SetParameterValue("Standard", dr[1].ToString());
msr.SetParameterValue("Division", dr[2].ToString());
msr.SetParameterValue("Exam", dr[4].ToString());
//msr.SetParameterValue("TotalMark", dr[3].ToString());
msr.SetParameterValue("SchoolName", dr[8].ToString());
msr.SetParameterValue("Addr", dr[9].ToString());
msr.SetParameterValue("DT", DateTime.Now.ToString());
msr.SetParameterValue("SchoolPhNo", dr[10].ToString());
crystalReportViewer1.ReportSource = msr;
}
}
}
