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();
}