C# RadComboBoxItem.DataBind方法代码示例

 protected void RadComboBoxFirma_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
 {
     if (e.Text.Length > 3)
     {
         string sqlSelectCommand = "";
         sqlSelectCommand = "SELECT [UserID],[UserName] from [telerik_Users] ORDER BY [UserName]";
         SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
         adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
         DataTable dataTable = new DataTable();
         adapter.Fill(dataTable);
         RadComboBoxFirma.Items.Clear();
         foreach (DataRow dataRow in dataTable.Rows)
         {
             string UserName = "";
             RadComboBoxItem item = new RadComboBoxItem();
             item.Text = (string)dataRow["UserName"].ToString();
             item.Value = dataRow["UserId"].ToString();
             UserName = (string)dataRow["UserName"];
             if (dataRow["UserName"] != System.DBNull.Value)
             {
                 UserName = (string)dataRow["UserName"];
             }
             //item.Attributes.Add("FIRMAADI", FirmaAdi);
             //item.Attributes.Add("IL_ILCE", IlIlce);
             RadComboBoxFirma.Items.Add(item);
             item.DataBind();
         }
         Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
         lbl.Text = "Bulunan kayıt sayısı:" + "  " + dataTable.Rows.Count.ToString();
     }
 }

 private void CarregueCombo()
 {
     foreach (EnumeradorFiltroPatente enumerador in EnumeradorFiltroPatente.ObtenhaTodos())
     {
         var item = new RadComboBoxItem(enumerador.Descricao, enumerador.Id.ToString());
         item.Attributes.Add("Codigo", enumerador.Id.ToString());
         cboFiltroPatente.Items.Add(item);
         item.DataBind();
     }
 }

        private void CarregueCombo()
        {
            foreach (var mes in Mes.ObtenhaTodas())
            {
                var item = new RadComboBoxItem(mes.Descricao, mes.Codigo.ToString());

                item.Attributes.Add("Codigo", mes.Codigo.ToString());

                cboMes.Items.Add(item);
                item.DataBind();
            }
        }

        private void CarregueCombo()
        {
            foreach (var apresentacao in Apresentacao.ObtenhaTodas())
            {
                var item = new RadComboBoxItem(apresentacao.Nome, apresentacao.Codigo.ToString());

                item.Attributes.Add("Codigo", apresentacao.Codigo.ToString());

                cboApresentacao.Items.Add(item);
                item.DataBind();
            }
        }

        protected void cboTitular_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
        {
            using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeTitular>())
            {
                cboTitular.Items.Clear();

                foreach (var titular in servico.ObtenhaPorNomeComoFiltro(e.Text, 50))
                {
                    var item = new RadComboBoxItem(titular.Pessoa.Nome, titular.Pessoa.ID.ToString());
                    item.Attributes.Add("DataDoCadastro", titular.DataDoCadastro.Value.ToString("dd/MM/yyyy"));
                    item.Attributes.Add("InformacoesAdicionais", titular.InformacoesAdicionais);
                    cboTitular.Items.Add(item);
                    item.DataBind();
                }
            }
        }

        private void CarregueComboClasseViena(ILeituraRevistaDeMarcas processo)
        {
            cboClassificacaoViena.Items.Clear();
            cboClassificacaoViena.Attributes.Clear();

            foreach (var codigo in processo.ClasseViena.ListaDeCodigosClasseViena)
            {
                var item = new RadComboBoxItem(processo.ClasseViena.EdicaoClasseViena, processo.ClasseViena.EdicaoClasseViena);

                item.Attributes.Add("Codigo",
                                    codigo ?? "Não informada");

                this.cboClassificacaoViena.Items.Add(item);
                item.DataBind();
            }
        }

        protected void cboNCL_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
        {
            var ncls = NCL.ObtenhaPorCodigoComoFiltro(e.Text);

            if (ncls.Count > 0)
            {
                foreach (var ncl in ncls)
                {
                    var item = new RadComboBoxItem(ncl.Codigo, ncl.Codigo);

                    item.Attributes.Add("Descricao", ncl.Descricao);
                    item.Attributes.Add("Natureza", ncl.NaturezaDeMarca.Nome);

                    cboNCL.Items.Add(item);
                    item.DataBind();
                }
            }
        }

        private void CarregueComboClasseNacional(ILeituraRevistaDeMarcas processo)
        {
            cboClassificacaoNacional.Items.Clear();
            cboClassificacaoNacional.Attributes.Clear();

            foreach (var codigo in processo.ClasseNacional.listaDeCodigosDeSubClasse)
            {
                var item = new RadComboBoxItem(processo.ClasseNacional.CodigoClasseNacional, processo.ClasseNacional.CodigoClasseNacional);

                item.Attributes.Add("Especificacao",
                                    processo.ClasseNacional.EspecificacaoClasseNacional ?? "Não informada");

                item.Attributes.Add("SubClasse",
                                    codigo ?? "Não informada");

                this.cboClassificacaoNacional.Items.Add(item);
                item.DataBind();
            }
        }

        protected void ddl_Roles_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
        {
            BallyliffinDataContext db = new BallyliffinDataContext();

            List<sp_MembersByRole_ShortViewResult> roles = db.sp_MembersByRole_ShortView().ToList();

            foreach (sp_MembersByRole_ShortViewResult role in roles)
            {
                RadComboBoxItem item = new RadComboBoxItem();

                item.Text = (string)role.RoleDesc;
                item.Value = role.RoleID.ToString();

                item.Attributes.Add("RoleDesc", role.RoleDesc);
                item.Attributes.Add("Total", role.Total.Value.ToString());

                ddl_Roles.Items.Add(item);

                item.DataBind();
            }
        }

        protected void cboProcedimentosInternos_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
        {
            IList<ITipoDeProcedimentoInterno> listaProcedimentosInternos = new List<ITipoDeProcedimentoInterno>();

            using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeTipoDeProcedimentoInterno>())
            {
                listaProcedimentosInternos = servico.obtenhaTipoProcedimentoInternoPelaDescricao(e.Text);
            }

            if (listaProcedimentosInternos.Count > 0)
            {
                foreach (var procedimentoInterno in listaProcedimentosInternos)
                {
                    var item = new RadComboBoxItem(procedimentoInterno.Descricao, procedimentoInterno.Id.Value.ToString());

                    item.Attributes.Add("ID", procedimentoInterno.Id.ToString());

                    cboTipoDeProcedimentosInternos.Items.Add(item);
                    item.DataBind();
                }
            }
        }

        private void CarregueCombo(IList<Situacao> situacoesADesconsiderar)
        {
            if (situacoesADesconsiderar == null) situacoesADesconsiderar = new List<Situacao>();

            foreach (var situacao in Situacao.ObtenhaTodos())
            {
                if (!situacoesADesconsiderar.Contains(situacao))
                {
                    var item = new RadComboBoxItem(situacao.Descricao, situacao.ID.ToString());

                    cboSituacao.Items.Add(item);
                    item.DataBind();
                }
            }
        }

    protected void RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
    {
        //string BolgeKodu = Session["BolgeKodu"].ToString();
        //string bak = e.Text;
        if (e.Text.Length > 2)
        {
            string BolgeKodu = intBolgeKodu.ToString();
            string sqlSelectCommand = "";
            /*
            if (rdbtnlstAramaTipi.SelectedIndex == 0)//isnodan arama
                sqlSelectCommand = "SELECT [ObjectID], [isno], [adi], [birim] from [tblIsEmri] WHERE [isno] LIKE '%'+ @text + '%' ORDER BY [isno]";
            if (rdbtnlstAramaTipi.SelectedIndex == 1)//is adından arama
                sqlSelectCommand = "SELECT [ObjectID], [isno], [adi], [birim] from [tblIsEmri] WHERE [adi] LIKE '%'+ @text + '%' ORDER BY [adi]";
            if (rdbtnlstAramaTipi.SelectedIndex == 2)//Birimden arama
                sqlSelectCommand = "SELECT [ObjectID], [isno], [adi], [birim] from [tblIsEmri] WHERE [birim] LIKE '%'+ @text + '%' ORDER BY [birim]";
            */
            sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
            SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
            adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
            DataTable dataTable = new DataTable();
            adapter.Fill(dataTable);
            //lblBulunanIsSayisi.Text = dataTable.Rows.Count.ToString();

            RadComboBoxFirma.Items.Clear();
            foreach (DataRow dataRow in dataTable.Rows)
            {
                string IlIlce = "";
                RadComboBoxItem item = new RadComboBoxItem();
                item.Text = (string)dataRow["MUSTNO"].ToString();
                item.Value = dataRow["FIRMAID"].ToString();
                string FirmaAdi = (string)dataRow["FIRMAADI"];
                if (dataRow["IL_ILCE"] != System.DBNull.Value)
                {
                    IlIlce = (string)dataRow["IL_ILCE"];
                }
                item.Attributes.Add("FIRMAADI", FirmaAdi);
                item.Attributes.Add("IL_ILCE", IlIlce);
                RadComboBoxFirma.Items.Add(item);
                item.DataBind();
            }
            Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
            lbl.Text = "Bulunan kayıt sayısı:" + "  " + dataTable.Rows.Count.ToString();
        }
    }

        private void CarregueCombo()
        {
            foreach (var forma in FormaDeRecebimento.ObtenhaTodos())
            {
                var item = new RadComboBoxItem(forma.Descricao, forma.ID.ToString());

                cboFormaDeRecebimento.Items.Add(item);
                item.DataBind();
            }
        }

 protected void RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
 {
     EFDal ed = new EFDal();
     if (e.Text.Length > 2)
     {
         string BolgeKodu = ed.kal_BolgeKoduDon(Context.User.Identity.Name).ToString();
         string sqlSelectCommand = "";
         sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
         SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
         adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
         DataTable dataTable = new DataTable();
         adapter.Fill(dataTable);
         RadComboBoxFirma.Items.Clear();
         foreach (DataRow dataRow in dataTable.Rows)
         {
             string IlIlce = "";
             RadComboBoxItem item = new RadComboBoxItem();
             item.Text = (string)dataRow["MUSTNO"].ToString();
             item.Value = dataRow["FIRMAID"].ToString();
             string FirmaAdi = (string)dataRow["FIRMAADI"];
             if (dataRow["IL_ILCE"] != System.DBNull.Value)
             {
                 IlIlce = (string)dataRow["IL_ILCE"];
             }
             item.Attributes.Add("FIRMAADI", FirmaAdi);
             item.Attributes.Add("IL_ILCE", IlIlce);
             RadComboBoxFirma.Items.Add(item);
             item.DataBind();
         }
         Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
         lbl.Text = "Bulunan kayıt sayısı:" + "  " + dataTable.Rows.Count.ToString();
     }
 }

        protected void cboNaturezaPatente_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
        {
            IList<INaturezaPatente> listaNaturezaPatente = new List<INaturezaPatente>();

            using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeNaturezaPatente>())
                listaNaturezaPatente = servico.obtenhaNaturezaPatentePelaSiglaComoFiltro(e.Text, 50);

            if (listaNaturezaPatente.Count > 0)
            {
                foreach (var naturezaPatente in listaNaturezaPatente)
                {
                    var item = new RadComboBoxItem(naturezaPatente.SiglaNatureza, naturezaPatente.IdNaturezaPatente.Value.ToString());

                    item.Attributes.Add("Descricao", naturezaPatente.DescricaoNaturezaPatente ?? "Não informada");

                    cboNaturezaPatente.Items.Add(item);
                    item.DataBind();
                }
            }
        }