public virtual void SetDataSource()
 {
     _allAppointments = _ad.GetList(_sql).OrderBy(x => x.AppointmentDate).ThenBy(x => x.AppointmentHour).ToList();//.ConvertAll(x => x as AppointmentBase);
     _allAppointments.ForEach(x => x.UpdateDisplayNames());
     SetDataGridViewData();
     //_frm.dgAppointment.AutoGenerateColumns = false;
     //_frm.dgAppointment.DataSource = _allAppointments;// bs;// _studentBs.DataSource;
     //_frm.dgAppointment.Refresh();
     //_frm.dgAppointment.Columns[1].DefaultCellStyle.Format = "dd-MMMM-yyyy";
     //_frm.lblAppointmentCount.Text = "Appointment Count: " + _frm.dgAppointment.Rows.Count.ToString();
 }