// method to get all the products
public void GetAllProducts()
{
// using Fill() method
//_adpProducts.FillProducts(_tblProducts);
// using Get() method
_tblProducts = _adpProducts.GetProducts();
//Console.WriteLine("\n\n+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+\n");
foreach (var row in _tblProducts)
{
Console.WriteLine($"{row.ProductID,5} {row.ProductName,-40} {row.UnitPrice,10} {row.UnitsInStock,10}");
}
}
