public static List <Nhom> DSNhom()
{
var lqq = new List <Nhom>();
var cm = CreateCommand();
cm.CommandText = @"Select MALOP,MANHOM,SOSVDADK from NHOM";
var reader = cm.ExecuteReader();
while (reader.Read())
{
lqq.Add(Nhom.ReadNhom(reader));
}
cn.Close();
return(lqq);
}
public static List <Nhom> DSNhom(string mal)
{
var lqq = new List <Nhom>();
var cm = CreateCommand();
cm.CommandText = @"Select MALOP,MANHOM,SOSVDADK from NHOM where MaLop = @malop1";
cm.Parameters.Add(new SqlParameter("@malop1", mal));
var reader = cm.ExecuteReader();
while (reader.Read())
{
lqq.Add(Nhom.ReadNhom(reader));
}
cn.Close();
return(lqq);
}
