/// <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; }
/// <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(); }