How can I add data to my dropdown list box in ASP.NET VB.NET?

Question

How can I add a data to my drop down list came from database? My code is this. And when I try using this:

<form id="form1" runat="server">
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
    SelectCommand="SELECT * FROM [renovationproject]"></asp:SqlDataSource>
    <br />

Using Dropdownlist input web control:

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"          DataTextField="tasks" DataValueField="workid">
</asp:DropDownList>

It got errors in a webpage that says controls are not allowed to be put here. I only have an empty dropdown right now.

<asp:DropDownList ID="DdLocation" runat="server"></asp:DropDownList>

What is the error message (specifically)

Chains
– Chains

2011-08-03 05:56:20 +00:00
Commented Aug 3, 2011 at 5:56 — Chains
– Chains, Commented Aug 3, 2011 at 5:56

Chains · Accepted Answer · 2011-08-03 05:54:25Z

3

There are many ways to add data. You can put them in there literally <asp:listitem>; Or here are some basic ones: http://www.w3schools.com/aspnet/aspnet_databinding.asp

You can also look into creating a <asp:datasource>. I recommend you do this with the wizard first (in desing view, you should have a little arrow block near the dropdown list -- start with "choose data source".

You can also bind with a datatable in your code behind. Google keywords asp:dropdownlist, databind(), dataadapter, dataset, datatable.

edited Aug 3, 2011 at 5:54

answered Aug 3, 2011 at 5:44

Chains

13.2k8 gold badges48 silver badges62 bronze badges

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

2 Comments

spicykimchi Over a year ago

This is what I got in wizard "SqlDataSource1" and nothing happens.

Chains Over a year ago

OK -- try deleting the datasource, and also delete the attribute DataSourceID="SqlDataSource1" from your dropdown list. Then try to run the wizard again.

Collectives™ on Stack Overflow

How can I add data to my dropdown list box in ASP.NET VB.NET?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related