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);
}
