public List <tongket> searchTK(String search)
{
List <tongket> list = new List <tongket>();
String query = "Select * from tongket where masv='" + search + "'";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tongket b = new tongket();
b.tongKetIDataReader(reader);
list.Add(b);
}
reader.Close();
} catch (Exception e) {
}
return(list);
}
public List <tongket> getDsTongKet()
{
List <tongket> list = new List <tongket>();
String query;
query = "Select * from tongket ";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tongket l = new tongket();
l.tongKetIDataReader(reader);
list.Add(l);
}
reader.Close();
} catch (Exception e) {
}
return(list);
}
