public List <LoaiBean> timLoai(string key)
{
string sql = "SELECT * FROM loai WHERE tenloai LIKE @tenLoai ";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlParameter ts = new SqlParameter("@tenLoai", key);
cmd.Parameters.Add(ts);
SqlDataReader rs = cmd.ExecuteReader();
List <LoaiBean> ds = new List <LoaiBean>();
while (rs.Read())
{
string maLoai = rs["maloai"].ToString();
string tenLoai = rs["tenloai"].ToString();
LoaiBean loai = new LoaiBean(maLoai, tenLoai);
ds.Add(loai);
}
rs.Close();
return(ds);
}
public List <LoaiBean> getLoai()
{
string sql = "SELECT * FROM loai";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlDataReader rs = cmd.ExecuteReader();
List <LoaiBean> ds = new List <LoaiBean>();
while (rs.Read())
{
string maLoai = rs["maloai"].ToString();
string tenLoai = rs["tenloai"].ToString();
LoaiBean loai = new LoaiBean(maLoai, tenLoai);
ds.Add(loai);
//String[] st = new String[2];
//st[0] = rs[0].ToString();
//st[1] = rs[1].ToString();
}
rs.Close();
return(ds);
}
