Exemplo n.º 1
0
 private void LoadAlbums()
 {
     DBRequests.MakeRequest(DBRequests.LoadAlbums(), (connection, sqlCommand) =>
     {
         using (var reader = sqlCommand.ExecuteReader())
         {
             if (reader.HasRows)
             {
                 while (reader.Read())
                 {
                     _albums.Add(new TextInstance {
                         Name = reader.GetString(0)
                     });
                 }
             }
             AlbumList.Refresh();
         }
     });
 }
Exemplo n.º 2
0
        private void LoadAlbums()
        {
            _albums.Clear();
            AlbumCombo.Items.Clear();
            DBRequests.MakeRequest(DBRequests.LoadAlbums(), (connection, sqlCommand) =>
            {
                using (var reader = sqlCommand.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            var textInstance = new TextInstance {
                                ID = reader.GetInt32(1), Name = reader.GetString(0)
                            };
                            _albums.Add(textInstance);
                        }
                    }


                    AlbumCombo.Items.AddRange(_albums.ToArray());
                }
            });
        }