private void frmVisitView_Load(object sender, EventArgs e)
        {
            objHospitalDB = new HospitalDB();
            Visit     objVisit = new Visit(objHospitalDB);
            DataTable dtVisit  = new DataTable();

            dtVisit = objVisit.GetAllAsDataTable();
            ultraGridVisit.DataSource = dtVisit;
        }
 private void ultraBtnVRefresh_Click(object sender, EventArgs e)
 {
     ultraTextSearch.Text      = "";
     ultraDateTimeSearch.Value = "";
     try
     {
         objHospitalDB = new HospitalDB();
         Visit     objVisit = new Visit(objHospitalDB);
         DataTable dtVisit  = new DataTable();
         dtVisit = objVisit.GetAllAsDataTable();
         ultraGridVisit.DataSource = dtVisit;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
         if (objHospitalDB != null)
         {
             objHospitalDB.Dispose();
         }
     }
 }