private void bindDataGV()
    {
        lblOfficerClerk.Visible = false;

        if (DropDOfficerClerk.SelectedValue == "-1")
        {
            lblOfficerClerk.Visible = true;
            reportByName.Visible = false;

            reportbyOfficerGV.DataSource = null;
            reportbyOfficerGV.DataBind();
            return;
        }

        reportByName.Visible = true;
        reportbyOfficerGV.Visible = true;

        string empID = DropDOfficerClerk.SelectedValue.Trim();

        TransactionResponse response = null;
        employeeManager = new EmployeeManager();
        response = employeeManager.getHROfficerPMSReportResultByName(empID);
        DataTable dataTable = null;
        if (response.isSuccessful())
        {
            //get Data from TransactionResponse
            dataTable = (DataTable)response.Data;

            if (dataTable != null && dataTable.Rows.Count > 0)
            {
                reportbyOfficerGV.DataSource = dataTable;
                reportbyOfficerGV.DataBind();
            }
        }
        else
        {
            reportbyOfficerGV.DataSource = null;
            reportbyOfficerGV.DataBind();
            reportByName.Visible = false;
        }
    }
    protected void DropDOfficerClerk_SelectedIndexChanged(object sender, EventArgs e)
    {
        lblOfficerClerk.Visible = false;

        if (DropDOfficerClerk.SelectedValue == "-1")
        {
            lblOfficerClerk.Visible = true;
            reportByName.Visible = false;

            reportbyOfficerGV.DataSource = null;
            reportbyOfficerGV.DataBind();
            return;
        }

        reportByName.Visible = true;
        reportbyOfficerGV.Visible = true;

        string empID = DropDOfficerClerk.SelectedValue.Trim();

        TransactionResponse response = null;
        employeeManager = new EmployeeManager();
        try
        {
            // Notification Manager. 
            response = employeeManager.getHROfficerPMSReportResultByName(empID);
            DataTable dataTable = null;
            if (response.isSuccessful())
            {
                //get Data from TransactionResponse
                dataTable = (DataTable)response.Data;

                if (dataTable != null && dataTable.Rows.Count > 0)
                {
                    reportbyOfficerGV.DataSource = dataTable;
                    reportbyOfficerGV.DataBind();
                }
            }
            else
            {
                reportbyOfficerGV.DataSource = null;
                reportbyOfficerGV.DataBind();
                reportByName.Visible = false;
            }
            //display message to user.
            displayMessageToTheUser(response);
        }
        //CATCH ANY OTHER EXCEPTION, dont let user see any kind of unexpected error
        catch (Exception ex)
        {
            msgPanel.Visible = true;
            ErroroDIV.Visible = true;
            lblErrorMsg.Text = "Unknow error occour while trying to get PMS report for HR Officer/Clerk. please contact your system administrator";
        }

    }