protected void Page_Load(object sender, EventArgs e)
        {
            VBFunctions.ADFunctions obj = new VBFunctions.ADFunctions();
            string userID = obj.GetUserName();

            // string dirEntry = obj.GetDirectoryEntry();
            memberships = obj.VerifyGroupMemberships("LDAP://192.168.100.3/ou=Cooper Network Users,dc=coopersurgical1,dc=com", "webapps", "Yankees#1", userID);

            if (!Page.IsPostBack)

            {
                if (memberships == 1 || memberships == 2 || memberships == 3)
                {
                    BusinessUnitReportingChild li = new BusinessUnitReportingChild();

                    DataTable table = new DataTable();

                    ddlBusinessUnitName.DataSource    = li.BusinessUnitNameist().Tables[0];
                    ddlBusinessUnitName.DataTextField = "BusinessUnitName";
                    ddlBusinessUnitName.DataBind();

                    ddlCompanyName.DataSource    = li.CompanyNameList().Tables[0];
                    ddlCompanyName.DataTextField = "CompanyName";
                    ddlCompanyName.DataBind();

                    ddlBusinessUnitManagerName.DataSource    = li.BusinessUnitManagerNameList().Tables[0];
                    ddlBusinessUnitManagerName.DataTextField = "BusinessUnitManagerName";
                    ddlBusinessUnitManagerName.DataBind();

                    newCompanyName.DataSource    = li.CompanyEffectiveNameList().Tables[0];
                    newCompanyName.DataTextField = "CompanyName";
                    newCompanyName.DataBind();

                    newBusinessUnitManagerName.DataSource    = li.BusinessUnitManagerNameList().Tables[0];
                    newBusinessUnitManagerName.DataTextField = "BusinessUnitManagerName";
                    newBusinessUnitManagerName.DataBind();

                    BindGridView();
                }
                else
                {
                    string display = "You must be a member of 'Consolidated Sales Reporting – Admin' or 'Consolidated Sales Reporting – Finance' or 'Consolidated Sales Reporting – Commission' groups to View the page.";
                    ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + display + "');", true);
                }
            }
        }