Пример #1
0
        public static void cboTypesInit(ComboBox cboTypes)
        {
            cboTypes.Items.Clear();
            DBHelper db  = new DBHelper();
            string   sql = "select * from types";

            try
            {
                DbCommand cmd = db.GetSqlStringCommand(sql);
                using (DbDataReader reader = db.ExecuteReader(cmd))
                {
                    while (reader.Read())
                    {
                        VirtualTrain.model.Type type = new VirtualTrain.model.Type();
                        type.id   = (int)reader["id"];
                        type.name = (string)reader["name"];
                        cboTypes.Items.Add(type);
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Пример #2
0
        //private void cboDifficultiesInit()
        //{
        //cboDifficulties.Items.Clear();
        //ArrayList list = new ArrayList();
        //DBHelper db = new DBHelper();
        //string sql = "select distinct difficulty from questions";
        //try
        //{
        //    DbCommand cmd = db.GetSqlStringCommand(sql);
        //    using (DbDataReader reader = db.ExecuteReader(cmd))
        //    {
        //        while (reader.Read())
        //        {
        //            list.Add((string)reader["difficulty"]);
        //        }
        //    }
        //    cboDifficulties.Items.AddRange((string[])list.ToArray(typeof(string)));
        //}
        //catch (Exception e)
        //{
        //    throw e;
        //}
        //}

        //获得类型的id
        public static int getTypeId(ComboBox comboBox)
        {
            object item = comboBox.SelectedItem;

            if (item != null)
            {
                VirtualTrain.model.Type type = item as VirtualTrain.model.Type;
                return(type.id);
            }
            else
            {
                return(-1);
            }
        }