SQL value does not populate ASP DropDownList control

Question

I'm trying to populate a dropdown list control. 'Inputs' is the DB. Table is 'ApplicationName', and it has a random value assigned to it.

For some reason, when I click the Test Submit button, nothing is appearing in the control (DropDownList1).

protected void TestSubmit_ServerClick(object sender, EventArgs e)
{
    // Initialize the database connector.
    SqlConnection connectSQL = new SqlConnection();

    // Send the connection string.
    connectSQL.ConnectionString = @"Data Source = localhost\SQLEXPRESS;" + 
        "Initial Catalog = Inputs; Integrated Security = SSPI";

    try
    {
        // Setup our command.
        SqlCommand theCommand = new SqlCommand("SELECT * FROM Inputs", connectSQL);

        // Write the stored value in the text boxes.
        connectSQL.Open();

        SqlDataReader theReader;

        theReader = theCommand.ExecuteReader();
        theReader.Read();

        DropDownList1.Items.Add(theReader["ApplicationName"].ToString());

        theReader.Close();
        connectSQL.Close();
    }
    catch (Exception ee)
    {
        MessageBox("Oopsie: " + ee);
}

p.campbell · Accepted Answer · 2009-08-13 20:17:39Z

4

Have you considered using a SqlDataSource? It'll be far less code for you to maintain and defend against defects for.

     <asp:DropDownList id="DropDownList1"
          runat="server"
          DataTextField="ApplicationName" 
          DataValueField="ApplicationName"
          DataSourceID="AppDataSource">
      </asp:DropDownList>

  <asp:SqlDataSource
          id="AppDataSource"
          runat="server"
          DataSourceMode="DataReader"
          ConnectionString="<%$ ConnectionStrings:MyNorthwind%>"
          SelectCommand="SELECT ApplicationName FROM Inputs">
  </asp:SqlDataSource>

answered Aug 13, 2009 at 20:17

p.campbell

101k70 gold badges265 silver badges326 bronze badges

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

1 Comment

SearchForKnowledge Over a year ago

What if I have one row but multiple columns and each column will populate the dropdownlist? My question is here: stackoverflow.com/questions/30310610/…

Jack Marchetti · Accepted Answer · 2009-08-13 20:12:13Z

0

I think you want to do a while(reader.read())

Then populate something like a dataset or a List, and then set the drop down lists data source to the dataset or list.

answered Aug 13, 2009 at 20:12

Jack Marchetti

15.8k14 gold badges85 silver badges119 bronze badges

Comments

womp · Accepted Answer · 2009-08-13 20:16:59Z

0

If your table name is "ApplicationName"... shouldn't your SQL statement be SELECT * FROM ApplicationName? Did you try looking to see if your reader had any results?

answered Aug 13, 2009 at 20:16

womp

117k27 gold badges240 silver badges271 bronze badges

Comments

Dana · Accepted Answer · 2009-08-13 20:18:03Z

0

If you match the columns selected in your database query with the DataTextField and DataValueField in the definition for your DropDownList, you should just need to do:

DropDownList1.DataSource = theReader;  
DropDownList1.DataBind()

or even

DropDownList1.DataSource = theCommand.ExecuteReader();

answered Aug 13, 2009 at 20:18

Dana

33.1k17 gold badges65 silver badges73 bronze badges

Collectives™ on Stack Overflow

SQL value does not populate ASP DropDownList control

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related