/// <summary>
    ///Handles the Click event of btnClear.
    ///On page load the function is used to get list of medications.
    /// <Author>Author: Rishu Chopra</Author>
    /// <CreatedDate>Date: 01-Nov-07</CreatedDate>
    /// </summary>
    private void GetMedicationDrug()
    {
        Streamline.UserBusinessServices.ClientMedication ObjectClientMedication = null;
        DataSet DataSetDrug = null;

        //Code added by Loveena in ref to Tash#2571 dated 02Sep2009.
        //DataRow[] dataRowStaff = null;
        try
        {
            ObjectClientMedication = new Streamline.UserBusinessServices.ClientMedication();
            DataSetDrug            = new DataSet();
            if (System.Configuration.ConfigurationSettings.AppSettings["UseSoundexMedicationSearch"] == null || System.Configuration.ConfigurationSettings.AppSettings["UseSoundexMedicationSearch"].ToString() == "")
            {
                System.Configuration.ConfigurationSettings.AppSettings["UseSoundexMedicationSearch"] = "N";
            }
            char showDosagesInList =
                (System.Configuration.ConfigurationSettings.AppSettings["ShowDosagesInDrugList"].ToUpper() == "TRUE")
                    ? 'Y'
                    : 'N';

            DataSetDrug = ObjectClientMedication.ClientMedicationDrug(Request.QueryString["MedicationName"].ToString(), Convert.ToChar(System.Configuration.ConfigurationSettings.AppSettings["UseSoundexMedicationSearch"].ToString()), showDosagesInList);

            DrugSearchCriteria = Request.QueryString["MedicationName"].ToString();
            DataView DataViewDrug = new DataView(DataSetDrug.Tables[0]);
            DataViewDrug.Sort = "MedicationName";
            //DataGridDrug.DataSource = DataViewDrug;
            //DataGridDrug.PageIndex = 0;
            //DataGridDrug.DataBind();
            lvDrugData.DataSource = DataViewDrug;
            lvDrugData.DataBind();
        }
        catch (Exception ex)
        {
            if (ex.Data["CustomExceptionInformation"] == null)
            {
                ex.Data["CustomExceptionInformation"] = "";
            }
            else
            {
                ex.Data["CustomExceptionInformation"] = "";
            }
            if (ex.Data["DatasetInfo"] == null)
            {
                ex.Data["DatasetInfo"] = "";
            }
            Streamline.BaseLayer.LogManager.LogException(ex, LogManager.LoggingCategory.General, LogManager.LoggingLevel.Error, this);
        }
        finally
        {
            ObjectClientMedication = null;
            DataSetDrug            = null;
        }
    }