ASP.NET

ASP.NET RSS

how to create a dynamic dropdownlist?

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Solved Threads: 0

ohgosh

Offline

Light Poster

how to create a dynamic dropdownlist?

Dec 22nd, 2005

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?

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
<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>
<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..

cheers,
ohgosh

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: how to create a dynamic dropdownlist?

Dec 22nd, 2005

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

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: how to create a dynamic dropdownlist?

Dec 22nd, 2005

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

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
DropDownList1.DataSource=dataTableName;
			DropDownList1.DataTextField="NameofDatabaseColumn";
			DropDownList1.DataValueField="NameofDatabaseColumn";
			DropDownList1.DataBind();
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

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Solved Threads: 0

ohgosh

Offline

Light Poster

Re: how to create a dynamic dropdownlist?

Dec 23rd, 2005

•

Originally Posted by campkev

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..

cheers,
ohgosh

•

Join Date: Sep 2008

Posts: 1

Reputation: sethu84 is an unknown quantity at this point

Solved Threads: 0

sethu84

Offline

Newbie Poster

Re: how to create a dynamic dropdownlist?

Feb 17th, 2009

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

•

Join Date: Oct 2008

Posts: 2

Reputation: danidev is an unknown quantity at this point

Solved Threads: 0

danidev

Offline

Newbie Poster

Re: how to create a dynamic dropdownlist?

Mar 30th, 2009

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

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: how to create a dynamic dropdownlist?

Mar 30th, 2009

hi,

check this code

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 <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();
 
 
 
    }
 <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();

      
        
    }