Exemple #1
0
        /* Hàm load dữ liệu lớp lên CBB */
        void GetCBB_Lop()
        {
            string query = "SELECT ma_lop, ten_lop FROM LOP";

            DB.conn.Open();
            SqlCommand    cmd = new SqlCommand(query, DB.conn);
            SqlDataReader rd  = cmd.ExecuteReader();

            LopDic = new Dictionary <string, CLop>();
            while (rd.Read())
            {
                CLop l = new CLop(rd[0].ToString(), rd[1].ToString());
                cbbLop.Items.Add(l);
                LopDic[l.Ma_lop] = l;
            }
            DB.conn.Close();
        }
Exemple #2
0
        //Lấy dữ liệu cho combobox lớp
        void Get_lop()
        {
            cbbLop.DisplayMember = "Ma_lop";
            cbbLop.ValueMember   = "Ten_lop";
            string query = "SELECT ma_lop,ten_lop FROM LOP";

            DB.conn.Open();
            SqlCommand    cmd = new SqlCommand(query, DB.conn);
            SqlDataReader rd  = cmd.ExecuteReader();

            LopDic = new Dictionary <string, CLop>();
            while (rd.Read())
            {
                CLop gt = new CLop(rd[0].ToString(), rd[1].ToString());
                cbbLop.Items.Add(gt.Ten_lop);
                LopDic[gt.Ma_lop] = gt;
            }
            DB.conn.Close();
        }