How to set a value to DropDownList items in ASP.Net using C#

Question

I have this code for a DropDownList in ASP.Net :

<asp:DropDownList ID="DropDownList2" runat="server" Width="150px" 
                AutoPostBack="True">
    <asp:ListItem Value="Tronc">Tronc Commun</asp:ListItem>
    <asp:ListItem Value="Sc_Maths">Bac 1 Sc Maths</asp:ListItem>
    <asp:ListItem Value="Sc_Ex">Bac 1 Sc Ex</asp:ListItem>
    <asp:ListItem Value="Eco_Ges">Bac 1 Economie et de Gestion</asp:ListItem>
    <asp:ListItem Value="MathsA">Bac 2 Sc Maths A</asp:ListItem>
    <asp:ListItem Value="P_C">Bac 2 Sc P.C.</asp:ListItem>
    <asp:ListItem Value="S_V_T">Bac 2 Sc S.V.T.</asp:ListItem>
</asp:DropDownList>

what i want is the C# code to fill this DropDownList with these same items with the values, the code i was able to do is this but it only fill it with the items but not the values

str = "(...)";
con = new SqlConnection(str);
req = "select Classe, value from contact";
da = new SqlDataAdapter(req, con);
dt = new DataTable();
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++) 
    DropDownList3.Items.Add(dt.Rows[i][0].ToString());

DropDownList3.Items.Add is this a typo? because from your code the ID is DropDownList2 — Izzy
– Izzy, Commented Apr 21, 2015 at 16:08
You have only one item in the select query. Is there any other column for Text and Value fields? — SelvaS
– SelvaS, Commented Apr 21, 2015 at 16:09
@Izzy well i puted 2 DropDownLists one filled with ASP.Net code (DropDownList2) and the other is the one i want to fill with same items (with their same values) using C#. — Tonner Mààn
– Tonner Mààn, Commented Apr 21, 2015 at 16:12
@SelvaTS i puted only 1 Column in that table just to show the code i usualy do, i'll edit it now so no one will misunderstand it — Tonner Mààn
– Tonner Mààn, Commented Apr 21, 2015 at 16:14

SelvaS · Accepted Answer · 2015-04-21 16:18:36Z

3

You can use DataTextField, DataValueField properties to bind the data.

            str = "(...)";
            con = new SqlConnection(str);
            req = "select Classe, value from contact";
            da = new SqlDataAdapter(req, con);
            dt = new DataTable();
            da.Fill(dt);

            DropDownList2.DataSource = dt;
            DropDownList2.DataTextField = "Classe";
            DropDownList2.DataValueField = "value";
            DropDownList2.DataBind();

answered Apr 21, 2015 at 16:18

SelvaS

2,1251 gold badge24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tonner Mààn Over a year ago

Testing this code right now and giving feedback in a min : )

Tonner Mààn Over a year ago

Worked ! Thank you very much, unfortunatly i can't accept more than 1 answer so i kept the accepted at the other Andrei's as he was first :P

Andrei · Accepted Answer · 2015-04-21 16:18:27Z

2

First make sure you load values from the DB. For that just adjust your select statement to include necessary field:

req = "select Classe, value from contact";

And then insert list items instead of just plain string into the drop down control:

for (int i = 0; i < dt.Rows.Count; i++)
{
    ListItem item = new ListItem(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString());
    DropDownList3.Items.Add(item);
}

edited Apr 21, 2015 at 16:18

answered Apr 21, 2015 at 16:13

Andrei

56.8k10 gold badges92 silver badges114 bronze badges

3 Comments

Tonner Mààn Over a year ago

i puted only 1 Column in that table just to show the code i usualy do, i already edited it as a response to another comment lol, i'll try your code and give you feed back now : )

Andrei Over a year ago

@TonnerMààn, your edit got lost because of the other one. I've recovered it now. As it turns out I have guessed the value field almost right, changed answer to lowercase value to stick to your use case

Tonner Mààn Over a year ago

it is a lowercase value lol i wrote it manually here so i made that mistake thank you for correcting it, also this code worked, so thank you for your help ^_^

Collectives™ on Stack Overflow

How to set a value to DropDownList items in ASP.Net using C#

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related