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