public List <sinhvien> searchSinhVien(String search)
{
List <sinhvien> list = new List <sinhvien>();
String query = "Select * from sinhvien where masv='" + search + "' or hoten ='" + search + "' or malop='" + search + "' or tenkhoa='" + search + "' or diachi='" + search + "' or ngaysinh='" + search + "' or gioitinh='" + search + "'";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sinhvien s = new sinhvien();
s.sinhvienIDateReader(reader);
list.Add(s);
}
reader.Close();
} catch (Exception e) {
}
return(list);
}
public List <sinhvien> getListSinhvien()
{
List <sinhvien> list = new List <sinhvien>();
String query = "Select * from sinhvien";
try
{
SqlCommand cmd = new SqlCommand(query, getConnection());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sinhvien s = new sinhvien();
s.sinhvienIDateReader(reader);
list.Add(s);
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(list);
}
