public List <Product> FindProducts(string catName) { var data = com.FindProducts(catName); List <Product> _products = new List <Product>(); foreach (DataRow row in data.Rows) { var p = new Product(); p.ProductID = Convert.ToInt32(row[0]); p.Name = row[1].ToString(); if (row[5] != null) { p.Updater = row[5].ToString(); } p.Cost = Convert.ToDouble(row[2]); _products.Add(p); } return(_products); }