public void remove_row(TableLayoutPanel panel, int row_index_to_remove)
        {
            if (row_index_to_remove >= panel.RowCount)
            {
                return;
            }

            // delete all controls of row that we want to delete
            for (int i = 0; i < panel.ColumnCount; i++)
            {
                Control control = panel.GetControlFromPosition(i, row_index_to_remove);
                panel.Controls.Remove(control);
            }

            // move up row controls that comes after row we want to remove
            for (int i = row_index_to_remove + 1; i < panel.RowCount; i++)
            {
                for (int j = 0; j < panel.ColumnCount; j++)
                {
                    var control = panel.GetControlFromPosition(j, i);
                    if (control != null)
                    {
                        panel.SetRow(control, i - 1);
                    }
                }
            }

            // remove last row
            panel.RowStyles.RemoveAt(panel.RowCount - 1);
            panel.RowCount--;
        }
        private void startServiceBtn_Click(object sender, EventArgs e)
        {
            MySqlConnection con = DBconnections.GetConnection();
            MySqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            foreach (Control ctr in serviceTabell.Controls)
            {
                if (ctr is CheckBox)
                {

                    CheckBox tmp = ctr as CheckBox;

                    if (tmp.Checked)
                    {
                        cmd.CommandText = "Select status FROM service Where serviceNr ='" + tmp.Name + "';";
                        MySqlDataReader read = cmd.ExecuteReader();

                        String status = (read["status"].ToString());
                        if (status != "startet")
                        {
                            cmd.CommandText = "UPDATE Service SET Status = 'startet' WHERE ServiceNr ='" + tmp.Name + "';";
                            cmd.ExecuteNonQuery();
                        }else
                        {
                            //label.Text = "Servicen er allerede startet";
                            //label.Visible = true;
                        }

                    }
                }
            }

            DBconnections.Dispose(con);
        }
    }