protected void FillBusinessUnitsForLoginType3() { DataTable dt = new DataTable(); string query = "select distinct bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID in ('" + GetStringValueCommaSeparted(ucRoleFilters.GetCommaSepartedSiteId()) + "')"; dt = new DataTable(); dt = baseObj.GetData(query); ChkBunt.Items.Clear(); ChkBunt.DataSource = dt; ChkBunt.DataTextField = "bu_desc"; ChkBunt.DataValueField = "bu_code"; ChkBunt.DataBind(); }
protected void FillBusinessUnits() { DataTable dt = new DataTable(); string query = "select bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID in ('" + ddlSiteId.SelectedItem.Value.ToString() + "')"; dt = new DataTable(); dt = baseObj.GetData(query); ChkBunt.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { ChkBunt.DataSource = dt; ChkBunt.DataTextField = "bu_desc"; ChkBunt.DataValueField = "bu_code"; ChkBunt.DataBind(); } }