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"; } }