public void NapTheLoai() { TheLoaiDropdown.Items.Clear(); PhanLoaiCollection source = new PhanLoaiCollection(); PhanLoaiBO phanloaiBO = new PhanLoaiBO(); phanloaiBO.TenPhanLoai = "Tất cả"; phanloaiBO.MaPhanLoai = ""; source.Add(phanloaiBO); //add PhanLoaiCollection temp = new PhanLoaiCollection(); temp=phanloaiBUS.TimDSPhanLoai(); for (int i = 0; i < temp.Count; i++) { source.Add(temp.Index(i)); } TheLoaiDropdown.DataSource = source; TheLoaiDropdown.DataTextField = "Tenphanloai"; TheLoaiDropdown.DataValueField = "Maphanloai"; TheLoaiDropdown.DataBind(); }
public PhanLoaiCollection TimDSPhanLoai() { PhanLoaiCollection plColl = new PhanLoaiCollection(); SqlConnection cnn = new SqlConnection(cnnstr); SqlCommand cmd = new SqlCommand("select * from PhanLoai order by TenPhanLoai", cnn); cnn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { PhanLoaiBO plBO = new PhanLoaiBO(); plBO.MaPhanLoai = dr["MaPhanLoai"].ToString(); plBO.TenPhanLoai=dr["TenPhanLoai"].ToString(); plColl.Add(plBO); // string mapl = dr["maphanloai"].ToString(); // plColl.Add(Tim1PhanLoai(mapl)); } cnn.Close(); return plColl; }
public PhanLoaiCollection TimDSCapNhatPhanLoai(string tenphanloai) { PhanLoaiCollection phanloaicoll = new PhanLoaiCollection(); SqlConnection cnn = new SqlConnection(cnnstr); string query = "select * from PhanLoai where tenphanloai <> '' "; query += "order by tenphanloai"; SqlCommand cmd = new SqlCommand(query, cnn); if (tenphanloai != "") { query = "select * from PhanLoai where tenphanloai like @tenphanloai and tenphanloai <>''"; query += "order by tenphanloai"; cmd = new SqlCommand(query, cnn); cmd.Parameters.AddWithValue("@tenphanloai", "%" + tenphanloai + "%"); } cnn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { PhanLoaiBO phanloaiBO = new PhanLoaiBO(); phanloaiBO.MaPhanLoai = dr["maphanloai"].ToString(); phanloaiBO.TenPhanLoai = dr["tenphanloai"].ToString(); phanloaicoll.Add(phanloaiBO); } cnn.Close(); return phanloaicoll; }