public KategoriBarang GetById(int id) { KategoriBarang kategoribarang = null; using (var conn = new SqlConnection(constr)) { conn.Open(); String query = "SELECT*FROM KategoriBarang where ID=@0"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@0", id); SqlDataReader reader = cmd.ExecuteReader(); KategoriBarang kb = null; while (reader.Read()) { kb = new KategoriBarang(reader); } } return(kategoribarang); }
public List <KategoriBarang> getAll() { List <KategoriBarang> list = new List <KategoriBarang>(); using (var conn = new SqlConnection(constr)) { conn.Open(); string query = "SELECT*FROM Kategori"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); KategoriBarang KB = null; while (reader.Read()) { list.Add(KB); } conn.Close(); } return(list); }