Пример #1
0
 /// <summary>
 /// 动态向comboBox控件的下拉列表添加数据.
 /// </summary>
 /// <param name="cobox">comboBox控件</param>
 /// <param name="TableName">数据表名称</param>
 public void CoPassData(ComboBox cobox, string TableName)
 {
     cobox.Items.Clear();
     DataClass.MyMeans MyDataClass = new OSM.DataClass.MyMeans();
     SqlDataReader MyDR = MyDataClass.getcom("select * from " + TableName);
     if (MyDR.HasRows)
     {
         while (MyDR.Read())
         {
             if (MyDR[1].ToString() != "" && MyDR[1].ToString() != null)
             {
                 cobox.Items.Add(MyDR[1].ToString());
                 cobox.DisplayMember = "name";
                 cobox.ValueMember = "ID";
             }
         }
     }
 }
Пример #2
0
        /// <summary>
        /// 动态向comboBox控件的下拉列表添加数据.
        /// </summary>
        /// <param name="cobox">comboBox控件</param>
        /// <param name="TableName">数据表名称</param>
        public void CoPassData(ComboBox cobox, string TableName)
        {
            cobox.Items.Clear();
            DataClass.MyMeans MyDataClass = new OSM.DataClass.MyMeans();
            SqlDataReader MyDR            = MyDataClass.getcom("select * from " + TableName);

            if (MyDR.HasRows)
            {
                while (MyDR.Read())
                {
                    if (MyDR[1].ToString() != "" && MyDR[1].ToString() != null)
                    {
                        cobox.Items.Add(MyDR[1].ToString());
                        cobox.DisplayMember = "name";
                        cobox.ValueMember   = "ID";
                    }
                }
            }
        }