private void StudentMarksReport_Load(object sender, EventArgs e) { cryrpt.Load(@"D:\SchoolManagementSystem\StudentMarksCrystalReport1.rpt"); con.Open(); StudentDataSet1 dst = new StudentDataSet1(); SqlDataAdapter sda = new SqlDataAdapter("Select EM.Term, EM.Year, EM.Mark From ExamMarks EM", con); DataTable dt = new DataTable(); sda.Fill(dt); cryrpt.SetDataSource(dt); crystalReportViewer1.ReportSource = cryrpt; con.Close(); }
private void StudentDetailReport2_Load(object sender, EventArgs e) { cryrpt.Load(@"D:\SchoolManagementSystem\StudentDetailsCrystalReport2.rpt"); con.Open(); StudentDataSet1 dst = new StudentDataSet1(); SqlDataAdapter sda = new SqlDataAdapter("Select * From Student", con); DataTable dt = new DataTable(); sda.Fill(dt); cryrpt.SetDataSource(dt); crystalReportViewer1.ReportSource = cryrpt; con.Close(); }