BackTerminal.frmBookAdd.InitializeComboBoxLibrary C# (CSharp) Method

        private void InitializeComboBoxLibrary()
        {
            SqlConnection connection = Library.Connection.Instance();
            string queryString = "SELECT name FROM dbo.library;";
            SqlCommand command = new SqlCommand(queryString, connection);
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                string name = (string)reader[0];
                comboBoxLibrary.Items.Add(name);
            }
            comboBoxLibrary.SelectedIndex = 0;
            reader.Close();
        }