Populateing text field and value field of listbox time from SQL <p>I have a SQL database table that has two columns; 'ID' and 'Names'. I want to read this data from database and add it into a ListBox with the 'Name' as the new Items text field and the 'ID' as the value field.</p> <p>This is what I have so far:</p> <pre><code> using (SqlConnection conn = new SqlConnection("ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("SELECT ID, Name FROM Buildings", conn)) { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { for (int i = 0; i &lt; reader.FieldCount; i++) { ........................ } } } </code></pre> <p>Any help would be appreciated.</p>