C# winfrom中一个Combobox控件中绑定两个数据集 代码如次

C# winfrom中一个Combobox控件中绑定两个数据集 代码如下
   private void InitStationCbo()
        {
            MySqlConnection con = DB.Connection;
            MySqlCommand cmd = null;
            MySqlDataReader dr_station = null;
            MySqlDataReader dr_proid = null;
            MySqlDataReader dr_lotid = null;
            using (con)
            using (cmd = con.CreateCommand())
            {
                cmd.Connection = con;
                con.Open();
                cmd.CommandText = string.Format("select station_id,station_testclass_id ,station_testclass_name from station_attributes,test_stations " 
                  +  " where station_attributes.station_class =test_stations.station_testclass_id  ");
                dr_station = cmd.ExecuteReader();
                #region dr_station
                using (dr_station)
                {
                    if (!dr_station.HasRows)
                    {
                        cboStationClass.DataSource = returnval_s;
                        cboStationClass2.DataSource = returnval_c;
                    }
                    else
                    {
                        while (dr_station.Read())
                        {
                            returnval_s.Add(dr_station.GetInt32("station_id"));
                            returnval_c.Add(dr_station.GetInt32("station_testclass_id"));                  
                            returnval_name.Add(dr_station.GetString("station_testclass_name"));
                           
                        }
                        cboStationClass.DataSource = returnval_s;

                        cboStationClass2.DataSource = returnval_name;
                      
                                       
                    }



                }
       }
}

我想在cboStationClass2中显示station_testclass_id字段+station_testclass_name字段这样的效果,该怎么做

文章评论