示例#1
0
        private void LoadCategories()
        {
            var categories = new List <ListViewItem>();

            _categories.Clear();
            CategoryList.Items.Clear();
            DBRequests.MakeRequest(DBRequests.LoadCategories(), (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)
                            };
                            _categories.Add(textInstance);
                            categories.Add(new ListViewItem(textInstance.Name));
                        }
                    }


                    CategoryList.Alignment = ListViewAlignment.Left;
                    CategoryList.Dock      = DockStyle.Fill;
                    CategoryList.View      = View.List;

                    // Initialize the tile size.
                    CategoryList.TileSize = new Size(100, 25);
                    CategoryList.Items.AddRange(categories.ToArray());
                }
            });
        }
示例#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());
                }
            });
        }