syntax error populating listbox with sql query result

Question

I am trying to populate a listbox with the following code but I get an error saying ListItem could not be found. Also rathen than creating a new listbox here I want to populate one on my windows forms gui called listbox1 but it says it does not exist in the current context if I change the first line to ListBox lb = listbox1();

ListBox lb = new ListBox(); 
string connectionString = "your connection string here"; 
using (SqlConnection con = new SqlConnection(connectionString)) 
{ 
    con.Open(); 
    string query = "SELECT column FROM myitemstable"; 
    using (SqlCommand cmd = new SqlCommand(query, con)) 
    { 
        using (SqlDataReader reader = cmd.ExecuteReader()) 
        { 
            while (reader.Read()) { 
                lb.Items.Add(new ListItem((string)reader["column"])); 
            } 
        } 
    } 
}

listbox1.Items.Add(new ListItem((string)reader["column"])); . no need to declare anything — anouar.bagari
– anouar.bagari, Commented Jun 15, 2012 at 10:31

Damith · Accepted Answer · 2012-06-15 16:43:39Z

1

when you drag and drop control to UI, Visual studio generate code for it. (Check your designer.cs file)

listbox1 is the object created by the designer, you can directly add items to it.

you can't do below

ListBox lb = listbox1();

because listbox1 is object.

edited Jun 15, 2012 at 16:43

answered Jun 15, 2012 at 15:25

Damith

63.2k13 gold badges106 silver badges154 bronze badges

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

Collectives™ on Stack Overflow

syntax error populating listbox with sql query result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related