Esempio n. 1
0
        /// <summary>
        /// 加载下拉菜单
        /// </summary>
        private void cobAdd()
        {
            cob_Name.Items.Clear();
            cob_Name.Items.Add(F_Main.Login_Name);
            string s = "select Name from t_Login Where GropPope >'" + F_Main.Login_Limit + "'";

            DataClass.MyMeans MyDataClsaa = new PersonalTools.DataClass.MyMeans();
            SQLiteDataReader  MyDR        = MyDataClsaa.ExecuteReader(s);

            if (MyDR.HasRows)
            {
                while (MyDR.Read())
                {
                    if (MyDR[0].ToString() != "" && MyDR[0].ToString() != null)
                    {
                        cob_Name.Items.Add(encrypt.DecryptDES(MyDR[0].ToString()));
                    }
                }
            }
            MyDR.Close();
            cob_Name.Text = F_Main.Login_Name;
        }
Esempio n. 2
0
        /// <summary>
        /// 动态向comboBox控件的下拉列表添加数据.
        /// </summary>
        /// <param name="comboBox">comboBox控件</param>
        /// <param name="SQLstr">SQL语句</param>
        public void comboBoxAddData(ComboBox comboBox, string SQLstr, bool b = false)
        {
            comboBox.Items.Clear();
            DataClass.MyMeans MyDataClsaa = new PersonalTools.DataClass.MyMeans();
            SQLiteDataReader  MyDR        = MyDataClsaa.ExecuteReader(SQLstr);

            if (MyDR.HasRows)
            {
                while (MyDR.Read())
                {
                    if (MyDR[0].ToString() != "" && MyDR[0].ToString() != null)
                    {
                        string mydr0 = MyDR[0].ToString();
                        if (b == true)
                        {
                            mydr0 = encrypt.DecryptDES(mydr0);
                        }
                        comboBox.Items.Add(mydr0);
                    }
                }
            }
            MyDR.Close();
        }