如何加入Tow Combobox数据

Question

我有两个组合框一，并且来自两个不同表的数据加载第一个combobox代码是

>  OleDbCommand cmd = new OleDbCommand("select empno,ename from emp", con);
            OleDbDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                combobox1.Items.Add(dr[1].ToString());
            }

结果：

KING
BLAKE
CLARK

和第二组合代码是

> OleDbCommand cmd1 = new OleDbCommand("select UnitId,UnitName from
> TableUnit", con);
>             OleDbDataReader dr1 = cmd1.ExecuteReader();
>             while (dr1.Read())
>             {
>                 combobox2.Items.Add(dr1[1].ToString());
>             }

结果：

ACCOUNTING
RESEARCH
SALES
OPERATIONS

我如何让加载数据加入两个结果（combobox1 combox2）到combobox3，例如

KING  ACCOUNTING
BLAKE RESEARCH

Answer 1

您可以以下面的方式合并两个ComboBox内容：

for (int i = 0; i < (combobox1.Items.Count < combobox2.Items.Count ? combobox1.Items.Count : combobox2.Items.Count); i++)
{
       combobox3.Items.Add($"{combobox1.Items[i]} {combobox2.Items[i]}");
}