public LoaiSanPhamCollection() { DataTable dt = DataAccess.ViewForGridView("Loaisanpham_ViewAll"); foreach (DataRow dr in dt.Rows) { LoaiSanPham lsp = new LoaiSanPham(); lsp.LoaisanphamID = int.Parse(dr["LoaisanphamID"].ToString()); lsp.Tenloaisanpham = dr["Tenloaisanpham"].ToString(); lst.Add(lsp); } }
public static List<LoaiSanPham> ViewAll() { if (conn.State == ConnectionState.Open) conn.Close(); conn.Open(); SqlCommand sc = new SqlCommand("Loaisanpham_ProcViewAll", conn); sc.CommandType = CommandType.StoredProcedure; SqlDataReader reader = sc.ExecuteReader(); List<LoaiSanPham> lstLsp = new List<LoaiSanPham>(); while (reader.Read()) { LoaiSanPham lsp = new LoaiSanPham(); lsp.Tenloaisanpham = (reader["Tenloaisanpham"] != null ? reader["Tenloaisanpham"].ToString() : ""); lsp.LoaisanphamID = (reader["LoaisanphamID"] != null ? int.Parse(reader["LoaisanphamID"].ToString()) : 0); lstLsp.Add(lsp); } reader.Close(); conn.Close(); return lstLsp; }