private void LoadCategories() { var categories = new List <ListViewItem>(); CategoryList.Items.Clear(); DBRequests.MakeRequest(DBRequests.LoadCategories(), (connection, sqlCommand) => { using (var reader = sqlCommand.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { categories.Add(new ListViewItem(reader.GetString(0))); } } 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()); } }); }
private void LoadCategories() { DBRequests.MakeRequest(DBRequests.LoadCategories(), (connection, sqlCommand) => { using (var reader = sqlCommand.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { _categories.Add(new TextInstance { Name = reader.GetString(0), ID = reader.GetInt32(1) }); } } CategoryListBox.Refresh(); } }); }
private void LoadCategories() { _categories.Clear(); CategoryCombo.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); } } CategoryCombo.Items.AddRange(_categories.ToArray()); } }); }