如何填充下拉列表中的元素 [英] how to populate elements in drop down list

问题描述

在我们的项目中，我们希望下拉列表的SelectedIndexChanged事件中的大学列表中的下拉列表中的大学名称.如何获取该事件的下拉列表中的大学名称.

我们编写的代码如下.

In our project, we want the college name in drop down list from college table in drop down list''s SelectedIndexChanged event.How I can get collge name in drop down list of that event.

The code written by us is as follow.

protected void ddlCollegename_SelectedIndexChanged(object sender, EventArgs e)
    {
            objsqlconnection = new SqlConnection(strconnectionstring);
            string strquery1 = "select CollegeName from tblCollege_Info";
            objsqlcommand = new SqlCommand(strquery1, objsqlconnection);
           
            try
            {
                objsqlconnection.Open();
                SqlDataReader objreader = objsqlcommand.ExecuteReader();
                while (objreader.Read())
                {
                  
                    ddlCollegename.Items.Add(objreader[1].ToString());
                }
                objreader.Close();
            }
            catch
            {
                Console.WriteLine("Error!!!!!!!1");
            }
            finally
            {
                objsqlconnection.Close();
            }
}

请帮帮我.
谢谢

[edit]对代码块的细微调整-OriginalGriff [/edit]

Please Help me.
Thanks

[edit]Minor tweaks to code block - OriginalGriff[/edit]

推荐答案

objsqlconnection = new SqlConnection(strconnectionstring);
DataSet ds=new DataSet();
            string strquery1 = "select * from tblCollege_Info";
            objsqlcommand = new SqlCommand(strquery1, objsqlconnection);
OleDbAdapter a=new OleDbAdapter();
a.selectCommand=objsqlcommand;
a.fill(ds,"tblCollege_Info");
                     
 try
 {
                   ddlCollegename.DataSource=ds;
ddlCollegename.DataTextField="Collegename";
ddlCollegename.DataValueField="ID";//ie PK of your table
 
           }
            catch
            {
                Console.WriteLine("Error!!!!!!!1");
            }
            finally
            {
                objsqlconnection.Close(); 

使用sqldatasource并将其配置为大学表.对于下拉列表，请选择您的数据源

use sqldatasource & configure it for college table.for dropdownlist select ur datasource

这篇关于如何填充下拉列表中的元素的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！