void addFlowerToOrder() { //TODO: check if fl_id is not exist in that order var mySql = new mySql(); createSQLSelelct(); createSQLInsert(); mySql.GetData(insertFltoOrder, bindingSourceOrders); dataGridViewAON.DataSource = bindingSourceOrders; mySql.GetData(selectOrder, bindingSourceOrders); dataGridViewAON.SelectionMode = DataGridViewSelectionMode.FullRowSelect; lblAddOrAntallBoxes.Text = mySql.sumColumn(dataGridViewAON, "boxes"); lblAddOrAntallStems.Text = mySql.sumColumn(dataGridViewAON, "stems"); lblAddOrAntallPrice.Text = mySql.sumColumn(dataGridViewAON, "price"); lblAddOrAntallBuckets.Text = mySql.sumColumn(dataGridViewAON, "buckets"); }