Esempio n. 1
0
        // dang nhap
        public List <dangNhapDB> dangnhap(string tk, string mk)
        {
            List <dangNhapDB> dangnhap = new List <dangNhapDB>();

            try
            {
                SqlConnection cn = new SqlConnection(ketnoi.cn);
                cn.Open();
                string        sql = "select * from dang_nhap where ten_dang_nhap = '" + tk + "' and mat_khau = '" + mk + "'";
                SqlCommand    cmd = new SqlCommand(sql, cn);
                SqlDataReader rd  = cmd.ExecuteReader();
                while (rd.Read())
                {
                    dangNhapDB dn = new dangNhapDB();
                    dn.ma     = rd.GetString(0);
                    dn.tk     = rd.GetString(1);
                    dn.mk     = rd.GetString(2);
                    dn.chucvu = rd.GetString(3);
                    dangnhap.Add(dn);
                }
                rd.Close();
            }
            catch
            { }
            return(dangnhap);
        }
Esempio n. 2
0
        private void FillCustomerListBox()
        {
            List <dangNhapDB> customers = new List <dangNhapDB>();

            for (int i = 0; i < customers.Count; i++)
            {
                dangNhapDB c = customers[i];

                MessageBox.Show(c.ma.ToString());
            }
        }