Ad:

ASP.NET Discussion Thread
Unsolved
Views: 39502

Dec 22nd, 2005

how to create a dynamic dropdownlist?

Expand Post »

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

Similar Threads

dropdownlist value doesnt get selected in ASP
ASP.NET / C# Dynamic Control in ASP.NET
create dynamic reports in asp.net in ASP.NET
create menu base on database data in VB.NET
Dynamic web pages? Which will exist? in IT Professionals' Lounge

ohgosh

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

41 posts
since Jul 2005

Permalink

Dec 22nd, 2005

Re: how to create a dynamic dropdownlist?

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

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

Permalink

Dec 22nd, 2005

Re: how to create a dynamic dropdownlist?

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

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

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

Permalink

Dec 23rd, 2005

Re: how to create a dynamic dropdownlist?

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

ohgosh

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

41 posts
since Jul 2005

Permalink

Feb 17th, 2009

Re: how to create a dynamic dropdownlist?

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

sethu84

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Sep 2008

Permalink

Mar 30th, 2009

Re: how to create a dynamic dropdownlist?

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

danidev

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2008

Permalink

Mar 30th, 2009

Re: how to create a dynamic dropdownlist?

hi,

check this code

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();

      
        
    }

greeny_1984

Reputation Points: 25

Solved Threads: 29

Posting Whiz

Offline

372 posts
since Apr 2007

Permalink

Apr 13th, 2009

Re: how to create a dynamic dropdownlist? | Complete Solution

To view Complete solution :

<URL SNIPPED, BROKEN LINK>

Thanks.

Last edited by peter_budo; Apr 15th, 2009 at 7:56 am. Reason: Please make sure that posted link is working

antonyvijayanv

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2009

Permalink

Apr 20th, 2009

Re: how to create a dynamic dropdownlist?

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

mbaocha

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Apr 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Asp.net behind code not correct

Next Thread in ASP.NET Forum Timeline: Pass Windows User (domain\userid) to report url in ASCX page

DaniWeb Message

Cancel Changes

User Name
Password