public void LoadBottlesFromAlerts(string alertName) { int alertID = req.GetAlertIDFromName(alertName); /** * defining the datagridview for "removing an alert" */ dvgBottlesSelected.ColumnCount = 3; //option for display dvgBottlesSelected.ColumnHeadersDefaultCellStyle.BackColor = Color.Navy; dvgBottlesSelected.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dvgBottlesSelected.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dvgBottlesSelected.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; dvgBottlesSelected.CellBorderStyle = DataGridViewCellBorderStyle.Single; dvgBottlesSelected.GridColor = Color.Black; //columns name dvgBottlesSelected.Columns[0].Name = "Nom du vin"; dvgBottlesSelected.Columns[1].Name = "Année"; dvgBottlesSelected.Columns[2].Name = "Volume"; dvgBottlesSelected.Columns[0].Width = 130; dvgBottlesSelected.Rows.Clear(); List <Bottles> lstWinesFromAlert = new List <Bottles>(); lstWinesFromAlert = Bottles.GetBottlesWithAlert(alertID); foreach (Bottles bot in lstWinesFromAlert) { string[] row = { bot.Name, bot.Year.ToString(), bot.Volume.ToString() }; dvgBottlesSelected.Rows.Add(row); } }