private void BindAssociates(CustomerAccountsVo AccountVo) { DataTable dtJoinHolder = new DataTable(); DataTable dtJoinHolderGV = new DataTable(); DataTable dtNominees = new DataTable(); DataTable dtNomineesGV = new DataTable(); DataRow drJoinHolder; DataRow drNominees; try { dsCustomerAssociates = customerTransactionBo.GetMFFolioAccountAssociates(AccountVo.AccountId, customerVo.CustomerId); dtJoinHolder = dsCustomerAssociates.Tables[0]; dtNominees = dsCustomerAssociates.Tables[1]; if (AccountVo.IsJointHolding == 1) { if (dtJoinHolder.Rows.Count > 0 && dtJoinHolder != null) { dtJoinHolderGV.Columns.Add("AssociateId"); dtJoinHolderGV.Columns.Add("Name"); dtJoinHolderGV.Columns.Add("Relationship"); dtJoinHolderGV.Columns.Add("Stat"); foreach (DataRow dr in dtJoinHolder.Rows) { drJoinHolder = dtJoinHolderGV.NewRow(); drJoinHolder[0] = dr["CA_AssociationId"].ToString(); drJoinHolder[1] = dr["NAME"].ToString(); drJoinHolder[2] = dr["XR_Relationship"].ToString(); drJoinHolder[3] = dr["Stat"].ToString(); dtJoinHolderGV.Rows.Add(drJoinHolder); } gvJoint2.DataSource = dtJoinHolderGV; ViewState["JointHold"] = dtJoinHolderGV; gvJoint2.DataBind(); gvJoint2.Visible = true; //trJointHolders.Visible = true; //trJointHoldersGrid.Visible = true; gvJoint2.Columns[3].Visible = false; trJoint2Header.Visible = true; } else { trJoint2Header.Visible = false; } } if (dtNominees.Rows.Count > 0 && dtJoinHolder != null) { dtNomineesGV.Columns.Add("AssociateId"); dtNomineesGV.Columns.Add("Name"); dtNomineesGV.Columns.Add("Relationship"); dtNomineesGV.Columns.Add("Stat"); foreach (DataRow dr in dtNominees.Rows) { drNominees = dtNomineesGV.NewRow(); drNominees[0] = dr["CA_AssociationId"].ToString(); drNominees[1] = dr["NAME"].ToString(); drNominees[2] = dr["XR_Relationship"].ToString(); drNominees[3] = dr["Stat"].ToString(); dtNomineesGV.Rows.Add(drNominees); } ViewState["Nominees"] = dtNomineesGV; gvNominee2.DataSource = dtNomineesGV; gvNominee2.DataBind(); gvNominee2.Columns[3].Visible = false; gvNominee2.Visible = true; trNominee2Header.Visible = true; } else { trNominee2Header.Visible = false; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerMFAccountAdd.ascx:BindAssociates()"); object[] objects = new object[1]; objects[0] = customerVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }