how to create a dynamic dropdownlist?

[ohgosh]

hi all,
do anyone knows how to create a dynamic dropdownlist? the dropdownlist will retrieve the list items from database..

eg: below is code for static dropdownlist where i declare the listitem myself.. but how should i declare listitem retreive from database?

<asp:dropdownlist id="ddl" Runat="server">		
             <asp:ListItem Value="1">A</asp:ListItem>	<asp:ListItem Value="2">B</asp:ListItem>	<asp:ListItem Value="3">C</asp:ListItem>
</asp:dropdownlist>

thanks..

[campkev]

what kind of database are you using, SQL, access?

[campkev]

if you can get the information out of the database and into a DataTable all you need to do is:

DropDownList1.DataSource=dataTableName;
			DropDownList1.DataTextField="NameofDatabaseColumn";
			DropDownList1.DataValueField="NameofDatabaseColumn";
			DropDownList1.DataBind();

if you need help getting it from the database into the datatable let me know

[ohgosh]

what kind of database are you using, SQL, access?

im using ms sql server 2000.. well, i will try the code later

thanks 4 ur help..

[sethu84]

how to create an dynamic event handler for dropdownlist in c#

[danidev]

See following to create dynamic dropdown list with event handler
http://urenjoy.blogspot.com/2009/03/create-dynamic-dropdownlists-in-aspnet.html

[greeny_1984]

hi,

check this code

<asp:DropDownList ID="ddlist" runat="server" ></asp:DropDownList>
  protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
         
            binddropdown();
           
        }
         }


    public void binddropdown()
    {
        SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Integrated Security=SSPI;Persist Security Info=False ");
        SqlDataAdapter da = new SqlDataAdapter("", conn);
        da.SelectCommand = new SqlCommand("select CategoryName,CategoryID from Categories", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "data");
        ddlist.AppendDataBoundItems = true;
        ListItem li = new ListItem();
        li.Text = "Select";
        li.Value = "Select";
        ddlist.Items.Add(li);
        ddlist.DataSource = ds.Tables[0].DefaultView;
        ddlist.DataTextField = "CategoryName";
        ddlist.DataValueField = "CategoryID";
        ddlist.DataBind();

      
        
    }

[antonyvijayanv]

To view Complete solution :

Thanks.

[mbaocha]

Which version of dot net are you using? I think creating a dynamic list box should be much of a difficult thing....