public static List <Removed_events> getEvents() { List <Removed_events> list = new List <Removed_events>(); DB db = new DB(); DataTable items = db.query("SELECT * FROM removed_events"); foreach (DataRow row in items.Rows) { object[] item = row.ItemArray; Removed_events newEvent = new Removed_events(); newEvent.id = Convert.ToInt32(item[0]); newEvent.description = Convert.ToString(item[1]); newEvent.date = Convert.ToDateTime(item[2]); newEvent.note = Convert.ToString(item[3]); newEvent.price = Convert.ToInt32(item[4]); newEvent.childs = getChildInfoFromEventId(newEvent.id); list.Add(newEvent); } return(list); }
private void SetupRemovedEventsTable() { List <Removed_events> events = Removed_events.getEvents(); foreach (Removed_events item in events) { this.dataGridView4.Rows.Add(item.id, item.getChildsName(), item.description, item.date, item.note, item.price); } }