Esempio n. 1
0
        private void fillCombobox(ComboBox objCombo, string strTable)
        {
            clsDB objDB = new clsDB(resPinnacle.liveDB);

            SQLiteDataReader objReader = objDB.returnComboBox(strTable);

            while (objReader.Read())
            {
                objCombo.Items.Add(objReader[0]);
            }
            objCombo.SelectedIndex = -1;
            objReader.Close();

            // adding empty space
            objCombo.Items.Add("");
        }
Esempio n. 2
0
        private void LoadControl()
        {
            clsDB objDB = new clsDB(strDB);

            // Loading combobox cmbStaff
            cmbStaff.SelectedIndex = -1;
            SQLiteDataReader objReader = objDB.returnComboBox("Staff");

            cmbStaff.Items.Add("All Staff");
            while (objReader.Read())
            {
                cmbStaff.Items.Add(objReader["Staff"]);
            }
            cmbStaff.SelectedIndex = 0;
            objReader.Close();
            Status = "All";
        }