private void mybutton1_Click(object sender, EventArgs e) { frmReportPatient p = new frmReportPatient(); Clinic.C.RunReportpatient("select patient.patientId,patient.patientName,patient.phone,patient.email,patient.age,patient.gender,patient.address,faculty.facultyName,level.levelName, (select count(patientId) from patient,faculty,level where patient.facultyId=faculty.facultyId and patient.levelId=level.levelId ) as countpatient from patient,faculty,level where patient.facultyId=faculty.facultyId and patient.levelId=level.levelId ", p); p.Show(); }
//patient public static void RunReportpatient(string select, frmReportPatient p, DataTable table = null) { //عشان اقوله لو الجدول فاضى هديله البيانات من عندى try { if (table == null) { table = DB.GetData(select); } ReportDataSource rds = new ReportDataSource("DataSet1", table); p.reportPatient.LocalReport.DataSources.Clear(); p.reportPatient.LocalReport.DataSources.Add(rds); p.reportPatient.LocalReport.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }