private void UpdatePrescriptionDGV()
        {
            //method that updates the datagrid
            PharmacyDataTier aPharm = new PharmacyDataTier();
            DataSet          ds1    = new DataSet();

            ds1 = aPharm.GetPrescription(frmSearchPrescriptions.myID);
            dgvPrescriptions.DataSource = ds1.Tables[0];
        }