public void fill_id(int retval)
        {
            bdr_dt_table  = bdr_tbl_adapt.GetData();
            pers_dt_table = pers_tbl_adapt.GetData();
            for (int i = 0; i < num_rows; i++)
            {
                SplitContainer SC = SC_ar[i];
                foreach (Control c in SC.Panel2.Controls)
                {
                    if (c is MultiColumnComboBox)
                    {
                        switch (type)
                        {
                        case 1:
                            break;

                        case 2:
                            (c as MultiColumnComboBox).DataSource    = bdr_dt_table;
                            (c as MultiColumnComboBox).DisplayMember = "zoeknaam";
                            (c as MultiColumnComboBox).ValueMember   = "bedrijf_nr";
                            break;

                        case 3:
                            (c as MultiColumnComboBox).DataSource    = pers_dt_table;
                            (c as MultiColumnComboBox).DisplayMember = "SearchName";
                            (c as MultiColumnComboBox).ValueMember   = "persoon_nr";
                            break;
                        }
                        c.Invalidate();
                    }
                }
            }
            Load_cbb();
            vul_hier.SelectedValue = retval;
        }
        public void load()
        { //test if set exist!!!
            switch (type)
            {
            case 2:    //bedrijf
                bdr_dt_table        = bdr_tbl_adapt.GetData();
                bdr_var_funct_table = bdr_var_funct_adapt.GetData();
                int x = (int)bdr_var_adapt.KomtVoor(project_nr);
                prev_rows = x;
                if (x > 0)
                {
                    bdr_var_table = bdr_var_adapt.GetDataBy11(project_nr);
                    for (int i = 0; i < x; i++)
                    {
                        add_line(int.Parse(bdr_var_table.Rows[i].ItemArray[2].ToString()), int.Parse(bdr_var_table.Rows[i].ItemArray[3].ToString()));
                    }
                }
                else
                {
                    btn_del.Hide();
                }
                break;

            case 3:    //contact
                pers_dt_table        = pers_tbl_adapt.GetData();
                pers_var_funct_table = pers_var_funct_adapt.GetData();
                int y = (int)pers_var_adapt.KomtVoor(project_nr);
                prev_rows = y;
                if (y > 0)
                {
                    pers_var_table = pers_var_adapt.GetDataBy1(project_nr);
                    for (int i = 0; i < y; i++)
                    {
                        add_line(int.Parse(pers_var_table.Rows[i].ItemArray[2].ToString()), int.Parse(pers_var_table.Rows[i].ItemArray[3].ToString()));
                    }
                }
                else
                {
                    btn_del.Hide();
                }
                break;
            }
        }
        public void UpdateCBBs()
        {
            mcbdict.Clear();
            Save_cbb(this);
            bdr_dt_table  = bdr_tbl_adapt.GetData();
            pers_dt_table = pers_tbl_adapt.GetData();
            for (int i = 0; i < num_rows; i++)
            {
                SplitContainer SC = SC_ar[i];
                foreach (Control c in SC.Panel2.Controls)
                {
                    if (c is MultiColumnComboBox)
                    {
                        switch (type)
                        {
                        case 1:
                            break;

                        case 2:
                            (c as MultiColumnComboBox).DataSource    = bdr_dt_table;
                            (c as MultiColumnComboBox).DisplayMember = "zoeknaam";
                            (c as MultiColumnComboBox).ValueMember   = "bedrijf_nr";
                            break;

                        case 3:
                            (c as MultiColumnComboBox).DataSource    = pers_dt_table;
                            (c as MultiColumnComboBox).DisplayMember = "SearchName";
                            (c as MultiColumnComboBox).ValueMember   = "persoon_nr";
                            break;
                        }
                        c.Invalidate();
                    }
                }
            }
            Load_cbb();
        }