求助，如何在下拉条中显示两个表的内容？

Question

combobox数据

Answer 1

两个表中的数据datatable,然后再合并这两个datatable，再绑定

Answer 2

http://www.cnblogs.com/JuneZhang/archive/2011/12/11/2284243.html

Answer 3

自定义个类，属性有唯一标示Id，组合后的name；
查询出数据添加到list
然后制定ComboBox的displayMember和ValueMember为这两个属性，绑定数据源。

Answer 4

//取出数据库表的字段
 public static ArrayList GetFeildsByTableName(string tableName)
        {
            string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + System.Windows.Forms.Application.StartupPath + "\\temp.mdb";
            System.Data.DataTable dt = new System.Data.DataTable();
            OleDbConnection dbConn = new OleDbConnection(ConnectionString);
            try
            {
                DataView dv = null;
                ArrayList list = new ArrayList();
                string FieldName = null;
                dbConn.Open();
                dt = dbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, tableName, null });
                dbConn.Close();
                int Rows = dt.Rows.Count;
                dv = new DataView(dt);
                dv.Sort = "ORDINAL_POSITION ASC";
                for (int i = 0; i < Rows; i++)
                {
                    if (dv[i]["DESCRIPTION"].ToString().IndexOf("fk") == -1)
                    {
                        FieldName = dv[i]["COLUMN_NAME"] + " " + dv[i]["DESCRIPTION"];
                        list.Add(FieldName);
                    }
                    FieldName = "";
                }
                //清除资源
                dt.Dispose();
                dv.Dispose();
                return list;
            }
            catch (OleDbException ex)
            {
                throw;
            }        }
    　　 ArrayList result1 = GetFeildsByTableName("01");//取出表01的字段
            ArrayList result2 = GetFeildsByTableName("02");//取出表02的字段
            result1.AddRange(result2);  //合并
            var source = result1.Cast<string>().Distinct().ToArray();　//去重复
            comboBox1.DataSource = source;