protected void GrdRegistration_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        Organisation org = OrganisationDB.GetByID(GetFormID());

        if (org == null)
        {
            HideTableAndSetErrorMessage("", "Invalid URL Parameters");
            return;
        }

        DataTable dt       = Session["registerreferrertoorg_data"] as DataTable;
        bool      tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value);

        if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow)
        {
            Label     lblId     = (Label)e.Row.FindControl("lblId");
            DataRow[] foundRows = dt.Select("register_referrer_id=" + lblId.Text);
            DataRow   thisRow   = foundRows[0];

            DropDownList ddlReferrer = (DropDownList)e.Row.FindControl("ddlReferrer");
            if (ddlReferrer != null)
            {
                Referrer[] incList_orig = RegisterReferrerDB.GetReferrersOf(org.OrganisationID);
                Referrer[] incList      = Referrer.RemoveByID(incList_orig, Convert.ToInt32(thisRow["referrer_id"]));
                DataTable  referrers    = ReferrerDB.GetDataTable_AllNotInc(incList);
                referrers.DefaultView.Sort = "surname ASC";
                foreach (DataRowView row in referrers.DefaultView)
                {
                    ddlReferrer.Items.Add(new ListItem(row["surname"].ToString() + ", " + row["firstname"].ToString() + " " + row["middlename"].ToString(), row["referrer_id"].ToString()));
                }
                ddlReferrer.SelectedValue = thisRow["referrer_id"].ToString();
            }

            Utilities.AddConfirmationBox(e);
            if ((e.Row.RowState & DataControlRowState.Edit) > 0)
            {
                Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow);
            }
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            DropDownList ddlReferrer = (DropDownList)e.Row.FindControl("ddlNewReferrer");
            if (ddlReferrer != null)
            {
                Referrer[] incList   = RegisterReferrerDB.GetReferrersOf(org.OrganisationID);
                DataTable  referrers = ReferrerDB.GetDataTable_AllNotInc(incList);
                referrers.DefaultView.Sort = "surname ASC";
                foreach (DataRowView row in referrers.DefaultView)
                {
                    ddlReferrer.Items.Add(new ListItem(row["surname"].ToString() + ", " + row["firstname"].ToString() + " " + row["middlename"].ToString(), row["referrer_id"].ToString()));
                }

                if (referrers.Rows.Count == 0)
                {
                    hideFotter = true;
                }
            }

            DropDownList ddlIsClinic = (DropDownList)e.Row.FindControl("ddlNewIsClinic");
            ddlIsClinic.SelectedValue = UserView.GetInstance().IsClinicView ? "1" : "0";
        }
    }