private void mybutton1_Click(object sender, EventArgs e)
        {
            frmReportStaff f = new frmReportStaff();

            Clinic.C.RunReportstaff("select staff.staffId,staff.staffName,profession.professionName,staff.phone,staff.email,staff.age,staff.gender,staff.address,specializations.SpecializationsName, (select count(staffId) from profession,staff left join specializations  on specializations.SpecializationsId =staff.SpecializationsId where  staff.staffId!=0 and staff.professionId =profession.professionId ) as countstaff  from profession,staff left join specializations  on specializations.SpecializationsId =staff.SpecializationsId where  staff.staffId!=0 and staff.professionId =profession.professionId ", f);
            f.Show();
        }
示例#2
0
        public static void RunReportstaff(string select, frmReportStaff p, DataTable table = null)
        {
            //عشان اقوله لو الجدول فاضى هديله البيانات من عندى
            try
            {
                if (table == null)
                {
                    table = DB.GetData(select);
                }
                ReportDataSource rds = new ReportDataSource("DataSet1", table);

                p.reportStaff.LocalReport.DataSources.Clear();
                p.reportStaff.LocalReport.DataSources.Add(rds);
                p.reportStaff.LocalReport.Refresh();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }