Databases
StackOverflow2013
Postsdbo
POHow to populate a dropdown list in asp.net from a DB table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to populate a dropdown list in asp.net from a DB table
    primarykey
    data
    text
    <p>I'm new to asp.net and I want to populate a dropdown list with values from a table I created. I only want to populate the list with one of the fields- the languages in my table. I think I have connected to the data source correctly, but I don't know what I have to do to get the values into the list. I can enter my own values but I'd rather have this automated.</p> <p>This is what I have so far, but I'm guessing there's more to it than just linking the list to the data source. Any help would be greatly appreciated.</p> <pre><code>&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="&lt;%$ ConnectionStrings:HBshareIndexConnectionString %&gt;" SelectCommand="SELECT * FROM [Web_Metrics] WHERE ([LCID] = @LCID)"&gt; &lt;SelectParameters&gt; &lt;asp:QueryStringParameter Name="LCID" QueryStringField="LCID" Type="Int32" /&gt; &lt;/SelectParameters&gt; &lt;/asp:SqlDataSource&gt; &lt;asp:Label ID="Label1" runat="server" Text="Select LCID: " &gt;&lt;/asp:Label&gt; &amp;nbsp; &amp;nbsp; &lt;asp:DropDownList ID="DropDownList1" Width="150px" runat="server" DataSourceID="SqlDataSource1" DataTextField="LCID" DataValueField="LCID"&gt; &lt;asp:ListItem&gt;Select LCID...&lt;/asp:ListItem&gt; &lt;/asp:DropDownList&gt; </code></pre> <p>Hi Guys, thanks for the help. I got the dropdown list populated now, but I was wondering how do I actually get the repeater I'm using to display the details of the LCID the person selects? I've seen people talking about page.isPostback but I don't know what that is or if it works with my current setup. I need to somehow get the LCID they selected and then refresh the page to show the details of that LCID. Does anyone have any ideas? Thanks</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRebeccaD
    1. USRebeccaD
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to populate a dropdown list in asp.net from a DB table
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to populate a dropdown list in asp.net from a DB table
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to populate a dropdown list in asp.net from a DB table
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMay I suggest that if you're just learning ASP.Net that you start right off with MVC instead of Webforms? Webforms has an awful lot of concepts that are unique to Webforms alone (The page lifecycle being one of the first ones you'll hit). MVC is cleaner (code and html seperated) and also far mroe modular and flexible IMHO
      singulars
      1. POHow to populate a dropdown list in asp.net from a DB table
      1. USBasic
    2. CO@Basic: I think you are misleading the OP. Both have their place and their reasons for usage. I suggest the OP read this to determine which path to take: [When to favor webforms over MVC](http://programmers.stackexchange.com/questions/95212/when-to-favor-webforms-over-mvc)
      singulars
      1. POHow to populate a dropdown list in asp.net from a DB table
      1. USShai Cohen
    3. CO@ShaiCohen There's a reason I ended with "IMHO" - It's always going to be a matter for debate and there are pros and cons to both sides but I'd point out that the core argument pro-webforms in that answer you linked is that if your team already knows how to do it, it's a learning curve to retrain - Which is why I offered a suggestion to someone new to the topic.
      singulars
      1. POHow to populate a dropdown list in asp.net from a DB table
      1. USBasic
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload